SQuirreL SQL Client explained
SQuirreL SQL Client |
Developer: | Colin Bell, Gerd Wagner, Rob Manning and others |
Latest Preview Version: | 20231120_2225[1] |
Operating System: | Cross-platform |
Platform: | Java |
Genre: | 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.[2]
SQuirreL SQL Client is free as open source software that is distributed under the GNU Lesser General Public License.
Feature summary
- 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.[3]
- 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.[4]
- Bookmarks - user-defined code templates. SQuirreL comes with predefined example bookmarks for the most common SQL and DDL statements.[4]
History
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 2020.[5]
Supported databases
See also
References
- Web site: SQuirreL SQL Client - Browse /3-snapshots at SourceForge.net . sourceforge.net . 2023-11-25 .
- Web site: SQuirreL, a Universal SQL Client. Gerd. Wagner. Glenn. Griffin. 2009-04-15.
- Web site: Martinig. Franco . SQuirreL SQL Client. 1 March 2011.
- Web site: SQuirreL SQL Client Home Page. SourceForge.net. 2009-04-15.
- Web site: Bell . Colin . SQuirreL SQL Client - Browse Files at SourceForge.net . SourceForge . 19 February 2020.