SQuirreL SQL Client

Infobox_Software
name = SQuirreL SQL Client
developer = Colin Bell, Gerd Wagner, Rob Manning and others
latest_release_version = 2.6.7
latest_release_date = September 17, 2008
operating_system = Cross-platform
platform = Java
genre = Database administration tool
license = LGPL
website = [http://www.squirrelsql.org/ www.squirrelsql.org]

The SQuirreL SQL Client is a database administration tool. It uses JDBC to allow users to explore and interact with databases via a JDBC driver. It provides an editor that offers code completion and syntax highlighting for standard SQL. It also provides a plugin architecture that allows plugin writers to modify much of the application's behavior to provide database-specific functionality or features that are database-independent. As this desktop application is written entirely in Java with Swing UI components, it should run on any platform that has a JVM.

SQuirreL SQL Client is free as open source software that is distributed under the GNU Lesser General Public License.

Feature Summary

* Object Tree allows for browsing database objects such as catalogs, schemas, tables, triggers, views, sequences, procedures, UDTs, etc.
* The SQL Editor is based on the NetBeans core editing components to provide syntax highlighting. It can be used to open, create, save and execute files containing SQL statements.
* Supports simultaneous sessions with multiple databases.
* It runs on any platform that has a JVM.
* Plugin architecture to facilitate database vendor-specific extensions (Information or actions not available using standard JDBC - see SQuirreL SQL Client Plugin API for more details)
* Translations for the user interface are available in 8 languages (Bulgarian, Brazilian Portuguese, Chinese, Czech, French, German, Italian, Spanish).

History

The SQuirreL SQL project was developed by a team of Java developers around the world and led by Colin Bell. It has been hosted as a SourceForge project since 2001, and is still being developed today.

Supported databases

* Axion Java RDBMS.
* Apache Derby
* Daffodil (One$DB)
* Fujitsu Siemens SESAM/SQL-Server with the SESAM/SQL JDBC driver
* Firebird with the JayBird JCA/JDBC Driver
* FrontBase
* HSQLDB
* Hypersonic SQL
* H2_(DBMS)
* IBM DB2 for Linux, OS/400 and Windows
* Informix
* Ingres (and OpenIngres)
* InstantDB
* InterBase
* Mckoi SQL Database
* Microsoft Access with the JDBC/ODBC bridge.
* Microsoft SQL Server
* Mimer SQL
* MySQL
* Oracle Database 8i, 9i, 10g, 11g
* Pointbase
* PostgreSQL 7.1.3 and higher
* SAPDB
* Sybase
* Sunopsis XML Driver (JDBC Edition)
* Teradata Warehouse
* ThinkSQL RDBMS