SQuirreL, Universal SQL Client

SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc, see Introduction.

The minimum version of Java supported is 1.5.x as of SQuirreL version 2.4. See the Old Versions page for versions of SQuirreL that will work with older versions of Java.

The SQuirreL desktop in Ocean Theme:

Features:

- Object Tree of Session window - right-click to access the popup menu which provides access to advanced script generation and graphing features. The graph plugin allows the user to create table charts

- SQL Editor with code completion popup (ctrl+space) open - code completion can be used to access drop-down lists of options that include keywords, tables, columns, views, stored procedures. Code completion also provides join generation functions. For example, look at the table structure here. Hitting ctrl+space after the expression

- SQL Editor with tools popup menu (ctrl+t) shown - with the tools popup any editor function can be located with only a single short cut: ctrl+t Additionally, the list can be searched incrementally with just a few keystrokes

- SQL Editor with bookmark selection popup (ctrl+j) shown - bookmarks are user-defined code templates. SQuirreL comes with several pre-defined example bookmarks for the most common SQL and DDL statements

- Abbreviations and auto corrections dialog - this feature works much like auto corrects in common office products. With the entries shown in the dialog you may for example type 'sf' which will expand to 'SELECT * FROM'

- Editing of SQL results - the result tabs of SQL queries support editing the rows returned from a query on a single table. You may also edit the contents tab of tables in the Object tree

- Graph: Charts of tables and their relations - To create new charts or to add tables to existing charts right mouse click tables in the Object tree and choose the 'Add to graph' menu. Graph manipulation functions can be accessed by using the right-click context popup menu

- Graph: Scaling and distributing tables on configurable page sizes to prepare for printing - use the right-click context popup menu to switch to the scaling and printing mode


For more detailed description see the paper by Gerd Wagner:
- English version
- German version


In theory SQuirreL should work with any DBMS that has a JDBC 2.0 driver. However not all drivers/DBMS's are fully complient with the JDBC 2.0 specification.


Reported working databases:

- Axion Java RDBMS
- Daffodil (One$DB)
- Apache Derby (formerly Cloudscape)
- 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 2.6 SP2 with EDBC driver v1.8
- InstantDB
- Interbase with the Interclient JDBC driver
- Mckoi SQL
- Microsoft Access with the JDBC/ODBC bridge
- Microsoft SQL Server with the Microsoft, WebLogic and jTDS JDBC drivers
- Mimer SQL
- MySQL with the MM MySQL JDBC driver
- Oracle 8i, 9i and 10g with the Oracle thin and OCI drivers
- Pointbase
- PostgreSQL 7.1.3 and higher
- Progress OpenEdge 10.1x
- SAPDB
- Sybase
- Sunopsis XML Driver (JDBC Edition)
- Teradata Warehouse
- ThinkSQL RDBMS


Available translations:

- Spanish
- Brizilian
- Czech
- Bulgarian
- Chinese
- French
- Italian
- German
- Russian