SQuirreL SQL Client

The SQuirreL SQL Client is a Java desktop application that combines the power of JDBC and Swing to allow users to explore and interact with any database using a JDBC driver written for that database. It provides a powerful editor that offers code completion and syntax highlighting for standard SQL. It provides a common interface for interacting with any supported database. It also provides a rich plugin architecture that allows plugin writers to modify much of the behavior available to provide database-specific functionality or features that are database-independent.

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.
SQL Editor based on the NetBeans core editing components for syntax highlighting.
Written entirely in Java with Swing UI components so it is platform agnostic.
Translations for the user interface are available in 8 languages.

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 and is still being developed today.

Supported Databases

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