SQuirreL SQL Client
squirrel-sql.sourceforge.io
- Free plan
- Windows
- macOS
- Linux
- Self-hosted
What SQuirreL SQL Client is
SQuirreL SQL Client is a graphical Java desktop application for viewing database structure, browsing table data and running SQL. It connects through JDBC, so users need a compatible driver for each database; most drivers are not bundled and may need to be obtained from the vendor. The editor provides completion for database objects and SQL terms, and can generate JOIN syntax from foreign keys. Query result tabs allow editing rows from queries on a single table, and results can be exported to Microsoft Excel. Java plugins extend the client, with repository plugins included in the installer. Available examples cover Excel or CSV imports, table graphs, schema refactoring and cross-database queries. Installers are offered for Windows, Linux and macOS. Version 5.1.0 requires Java 17 or later and highlights enhanced encryption for Alias passwords. The project is released under the GNU Lesser General Public License; usage and development questions go through mailing lists that require subscription.
Who it suits
It suits people who want a desktop Java client for JDBC-compatible databases, with SQL editing, single-table result editing and plugin extensions. Users should be prepared to obtain database drivers separately and meet the Java requirement for version 5.1.0.
Good to know, and what to watch
- SQL completion covers database objects and SQL terms.
- Can generate JOIN syntax from foreign keys.
- Result tabs allow editing single-table query rows.
- Plugins include imports, graphing and cross-database queries.
- Results can be exported to Microsoft Excel.
- Most database drivers are not included.
- Version 5.1.0 requires Java 17 or later.
- Mailing-list posting requires subscription.
Plans
Every plan and priceSQuirreL SQL Client
Free plan
The verdict
SQuirreL SQL Client offers JDBC-based database browsing and SQL work, with editable results and plugin options. Check driver availability and the Java requirement before choosing it.
What the maker publishes
- AI integration
- The latest snapshot announced on the site offers MCP server functionality for AI tools to access SQuirreL sessions. source
- Cross database queries
- The Multisource plugin supports queries across databases, cross database updates and synchronization, data virtualization, and SQL dialect and function translation. source
- Database connections
- SQuirreL uses JDBC drivers to connect to databases, and the FAQ says it should work in theory with any DBMS that has a JDBC 2.0 driver. source
- Database connectivity
- It can work with databases that have a compatible JDBC driver, which users may need to obtain from the database vendor. source
- Data import
- The optional Data Import plugin imports Excel or CSV data into a database. source
- Driver availability
- The project says most database drivers are not included because they are proprietary and vendors generally require users to download them directly. source
- Editable results
- Query result tabs support editing rows returned from a query on a single table. source
- Extensibility
- Java plugins extend the application, and plugins from its repository are included in the installer. source
- Extensible
- Its functionality can be extended with Java plugins, and plugins in the project repository are included in the installer. source
- External data disclosure
- The optional SQL Validator plugin sends SQL to a Mimer SQL web service for validation and stores validated SQL anonymously for use by the ISO SQL Standards committee. source
- Graphing
- The Graph plugin can create and print charts of database tables and their foreign key relations, and supports query building with SQL generation. source
- Java requirement
- The 5.1.0 release requires at least Java 17. source
- License
- The project says it has been released under the GNU Lesser General Public License since version 1.1beta2. source
- Operating systems and Java
- The project provides installers for Windows, Linux, and MacOS, and says SQuirreL 5.1.0 requires at least Java 17. source
- Password security
- The 5.1.0 feature highlights include enhanced security for encrypting Alias passwords. source
- Plugin examples
- Available plugins include data import from Excel or CSV, table graphing, schema refactoring, and cross-database queries. source
- Purpose
- SQuirreL is a graphical Java client for viewing JDBC database structure, browsing table data, and issuing SQL commands. source
- Result editing
- Query result tabs support editing rows returned from a query on a single table. source
- Security
- Version 5.1.0 highlights enhanced security for encrypting Alias passwords. source
- SQL editor
- The editor offers code completion for database objects and SQL terms, and can generate JOIN syntax from foreign keys. source
- Support
- The project directs users to its mailing lists for usage questions and developer discussion; posting requires subscription. source
- Supported systems
- Installers are offered for Windows, Linux and other systems, and a separate installer is offered for MacOS. source
Checked against the maker's pages on 9 Oct 2026.