SQuirreL SQL Client
| Company type | Open source software |
|---|---|
| Industry | Database management software |
| Founded | 2001 |
| Founder | Colin Bell |
| Headquarters | International |
| Products | Database management application |
| Website | squirrel-sql |
The SQuirreL SQL Client is a versatile database management application compatible across multiple platforms, leveraging JDBC to allow users to navigate and manipulate databases through JDBC drivers. It incorporates an SQL editor equipped with code completion and syntax highlighting tailored for standard SQL, thereby boosting efficiency. Its modular plugin system permits customization to accommodate database-specific features or general improvements. Built entirely in Java using Swing components for the user interface, it functions on any system supporting a JVM.
Offered as free open source software under the terms of the GNU Lesser General Public License, SQuirreL SQL Client is designed for database professionals who require a flexible and extendable management solution.
Feature summary
- Object Tree enables exploration of database entities such as catalogs, schemas, tables, triggers, views, sequences, procedures, and UDTs.
- The SQL Editor, powered by RSyntaxTextArea, provides syntax highlighting and supports creating, opening, saving, and executing SQL scripts.
- Supports multiple concurrent sessions with different databases, facilitating comparison of data and sharing of SQL commands.
- Operates independently of platform as long as a JVM is present.
- Plugin framework allows integration of vendor-specific enhancements beyond the default JDBC functionality.
- User interface translations are available in various languages including Bulgarian, Brazilian Portuguese, Chinese, Czech, French, German, Italian, Japanese, Polish, Spanish, and Russian.
- Graphing capabilities generate visual representations of table relationships.
- Bookmarks feature offers customizable code snippets with predefined templates for common SQL and DDL statements.
History
Since 2001, the SQuirreL SQL initiative—spearheaded by Colin Bell and supported by an international team of Java developers—has been hosted on SourceForge and has continued active development through 2024.
Supported databases
- Axion Java RDBMS
- Apache Derby
- ClickHouse
- Fujitsu Siemens SESAM/SQL-Server (using SESAM/SQL JDBC driver)
- Firebird (via JayBird JCA/JDBC Driver)
- Hypersonic SQL
- H2 (DBMS)
- IBM Db2 for Linux, IBM i, and Windows platforms
- Informix
- Ingres and OpenIngres
- InstantDB
- InterBase
- Mckoi SQL Database
- Microsoft Access (through JDBC/ODBC bridge)
- Microsoft SQL Server
- Mimer SQL
- MonetDB
- MySQL
- Netezza
- Versions 8i to 11g of Oracle Database
- Pointbase
- Versions 7.1.3 and above of PostgreSQL
- SAPDB
- Sybase
- Sunopsis XML Driver (JDBC Edition)
- Teradata Warehouse
- Vertica Analytic Database