SQuirreL SQL Client
by SQuirreL SQL Dev Team
Open-source, cross-platform SQL Client supporting many RDBMS platforms
SQuirreL SQL Client is an open-source, fully-featured database management application. It is entirely written in Java/Swing and can be installed on any JVM-compliant system. Actively maintained since 2001, it is supported by a global team of professional developers. Built on a modular architecture, it supports a plug-in system allowing software customizations that can better utilize database vendors' specific features. It can support any JDBC compliant database.
As open-source software, all the source code for the application can be viewed in the SourceForge repository. The GNU Lesser GPL allows unrestricted modification of the source code for personal and commercial use. All derived software will also need to be made available under the GNU Lesser GPL.
Features:
Supports many of the most popular database platforms including Microsoft SQL Server and Oracle
SQuirreL SQL is fully featured compared to other commercial SQL client toolkits. Some of the main features include:
- Intuitive and intelligent SQL text editor with syntax highlighting, code completion, and graphical visualization capabilities
- The SQL Editor supports the definition and lookup of bookmarks, which are reusable templates of code. The installation comes ready built with a library of common bookmarks.
- Support for inline editing of SQL results. After a result set is displayed, the tool supports editing data for a single table.
- The tool has an Object Tree feature which can be used to easily browse the most common database objects, such as tables, views, stored procedures, etc.
- The client tool is fully internationalized with support for over 12 languages as of this writing.
- The graph visualization capabilities can be used to visualize relationships between tables (like an ERD). Once a graph is created, it can be used to generate SQL DDL. In addition, it can be saved to JPEG format for printing.
- The tool was written to support multiple simultaneous sessions to disparate databases.
- An active user community can be leveraged via numerous mailing lists.
- Git integration is now fully supported, including change tracking
- Freely made available via the GNU Lesser GPL
- Easily installed via the lzPack Java installer
- The most recent version supports the latest Java 14 runtime
PROS
Allows for customization via plugins.
Supports JDBC compliant databases.
Features multi-tab browsing with SQL commands.
Supports JDBC compliant databases.
Features multi-tab browsing with SQL commands.
CONS
Can be complex and intimidating for beginners.
Limited database export options.
Sometimes struggles with larger databases.
Limited database export options.
Sometimes struggles with larger databases.
Ollie
Am a software developer, through this software easily i create an super market software and administer them on my location only, good one, also the editing and freezing features are really good one, highly recommended
Ben J.
SQuirreL SQL Client is a free, open source database client software used to interact with relational databases. It provides a graphical user interface to manage databases and includes a wide range of features such as SQL syntax highlighting, query builder, SQL history, schema and data browsing, SQL completion and formatting, table editing, and support for many popular databases.
Scott O.
I recently started using SQuirreL SQL Client software, and I'm impressed by its simplicity and power. It has a great UI and is easy to navigate. I have yet to explore all the features, but so far it's worked really well. I like the ability to easily switch between databases and run queries. It also allows me to view the results in a spreadsheet-like view, which is convenient. It also has a helpful tool to manage database drivers. Overall, it's a great tool that I look forward to using more.
Christopher H.
SQuirreL SQL Client have been really useful for me, it's a great tool for querying databases and finding out informatoin quickly.
Jamie S******d
SQuirreL SQL Client is a database management tool that allows users to connect to different database systems and execute SQL commands. It is an open-source software that works on multiple platforms such as Windows, Mac, and Linux. Its main features include a graphical user interface for managing databases, support for multiple JDBC compliant databases, and advanced SQL execution capabilities. It provides features like object browsing, SQL syntax highlighting, and result set data exporting. The software also supports the creation and modification of database objects such as tables, views, and indexes.
Matthew
Allows easy database navigation and data manipulation with a user-friendly interface.
Andrew
Intuitive interface, supports multiple database types.
Finn
Versatile, user-friendly database management tool.
