SQuirreL SQL Client

Database administration tool

This article needs additional citations for verification. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed.
Find sources: "SQuirreL SQL Client" – news · newspapers · books · scholar · JSTOR (December 2014) (Learn how and when to remove this message)

|

SQuirreL SQL Client

Developer(s)| Colin Bell, Gerd Wagner, Rob Manning and others
Stable release|

4.6.0[1] / 2023-06-04 [±]

Preview release|

20231120_2225[2] / November 20, 2023; 20 months ago (2023-11-20)[2]

Repository|

* sourceforge.net/p/squirrel-sql/git/ci/master/tree/

Operating system| Cross-platform
Platform| Java
Type| Database administration tool
License| LGPL
Website| 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.[3]

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

## Feature summary

[edit]

* Object Tree allows for browsing database objects such as catalogs, schemas, tables, triggers, views, sequences, procedures, UDTs, etc.
* The SQL Editor, based on RSyntaxTextArea by fifesoft.com, provides syntax highlighting. It can open, create, save and execute files containing SQL statements.
* SQuirreL supports simultaneous sessions with multiple databases. This allows comparing data and sharing SQL statements between databases.[4]
* SQuirreL runs on any platform that has a JVM.
* A plugin architecture facilitates database vendor-specific extensions (information or actions not available using standard JDBC)
* Translations for the user interface exist in: (Bulgarian, Brazilian Portuguese, Chinese, Czech, French, German, Italian, Japanese, Polish, Spanish, Russian).
* Graph capabilities can generate charts showing table relationships.[5]
* Bookmarks - user-defined code templates. SQuirreL comes with predefined example bookmarks for the most common SQL and DDL statements.[5]

## History

[edit]

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 was still under active development in 2024.[6]

## Supported databases

[edit]

* Axion Java RDBMS.
* Apache Derby
* ClickHouse
* Fujitsu Siemens SESAM/SQL-Server with the SESAM/SQL JDBC driver
* Firebird with the JayBird JCA/JDBC Driver
* Hypersonic SQL
* H2 (DBMS)
* IBM Db2 for Linux, IBM i and Windows
* Informix
* Ingres (and OpenIngres)
* InstantDB
* InterBase
* Mckoi SQL Database
* Microsoft Access with the JDBC/ODBC bridge.
* Microsoft SQL Server
* Mimer SQL
* MonetDB
* MySQL
* Netezza
* Oracle Database 8i, 9i, 10g, 11g
* Pointbase
* PostgreSQL 7.1.3 and higher
* SAPDB
* Sybase
* Sunopsis XML Driver (JDBC Edition)
* Teradata Warehouse
* Vertica Analytic Database

## See also

[edit]

* Free and open-source software portal

* SQL
* Comparison of database tools

## References

[edit]

1. ^ "SQuirrel SQL Client - Browse/1-stable". sourceforge.net. Retrieved 2023-11-25.
2. ^ a b "SQuirreL SQL Client - Browse /3-snapshots at SourceForge.net". sourceforge.net. Retrieved 2023-11-25.
3. ^ Wagner, Gerd; Griffin, Glenn. "SQuirreL, a Universal SQL Client" (PDF). Retrieved 2009-04-15.
4. ^ Martinig, Franco. "SQuirreL SQL Client". Retrieved 1 March 2011.
5. ^ a b "SQuirreL SQL Client Home Page". SourceForge.net. Retrieved 2009-04-15.
6. ^ Bell, Colin. "SQuirreL SQL Client - Browse Files at SourceForge.net". SourceForge. Retrieved 19 February 2020.

## External links

[edit]

* Official website