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

SQL

SQL is a programming language designed for managing data in relational database management systems ....

. 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

Swing (Java)

Swing is the primary Java GUI widget toolkit. It is part of Oracle's Java Foundation Classes — an API for providing a graphical user interface for Java programs....

 UI components, it should run on any platform that has a JVM.

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

GNU Lesser General Public License

The GNU Lesser General Public License or LGPL is a free software license published by the Free Software Foundation . It was designed as a compromise between the strong-copyleft GNU General Public License or GPL and permissive licenses such as the BSD licenses and the MIT License...

.

Feature Summary

• Object Tree allows for browsing database objects such as catalogs, schemas, tables, triggers, views, sequences, procedures, UDTs, etc.
• The SQL Editor is based on RSyntaxTextArea by fifesoft.com to provide syntax highlighting. It can be used to open, create, save and execute files containing SQL statements.
• Supports simultaneous sessions with multiple databases. This allows to compare data and share SQL statements between databases.
• It runs on any platform that has a JVM.
• Plugin architecture to facilitate database vendor-specific extensions (Information or actions not available using standard JDBC - see SQuirreL SQL Client Plugin API
  SQuirreL SQL Client Plugin API
  - Introduction :SQuirreL SQL Client uses the JDBC API to interact with a database, which for the most part makes it database implementation-agnostic. However, it can be extended to support implementation-specific features by writing a plugin that uses the Plugin API...
  
   for more details)
• Translations for the user interface are available in: (Bulgarian
  Bulgarian language
  Bulgarian is an Indo-European language, a member of the Slavic linguistic group.Bulgarian, along with the closely related Macedonian language, demonstrates several linguistic characteristics that set it apart from all other Slavic languages such as the elimination of case declension, the...
  
  , Brazilian Portuguese
  Brazilian Portuguese
  Brazilian Portuguese is a group of Portuguese dialects written and spoken by most of the 190 million inhabitants of Brazil and by a few million Brazilian emigrants, mainly in the United States, United Kingdom, Portugal, Canada, Japan and Paraguay....
  
  , Chinese
  Chinese language
  The Chinese language is a language or language family consisting of varieties which are mutually intelligible to varying degrees. Originally the indigenous languages spoken by the Han Chinese in China, it forms one of the branches of Sino-Tibetan family of languages...
  
  , Czech
  Czech language
  Czech is a West Slavic language with about 12 million native speakers; it is the majority language in the Czech Republic and spoken by Czechs worldwide. The language was known as Bohemian in English until the late 19th century...
  
  , French
  French language
  French is a Romance language spoken as a first language in France, the Romandy region in Switzerland, Wallonia and Brussels in Belgium, Monaco, the regions of Quebec and Acadia in Canada, and by various communities elsewhere. Second-language speakers of French are distributed throughout many parts...
  
  , German
  German language
  German is a West Germanic language, related to and classified alongside English and Dutch. With an estimated 90 – 98 million native speakers, German is one of the world's major languages and is the most widely-spoken first language in the European Union....
  
  , Italian
  Italian language
  Italian is a Romance language spoken mainly in Europe: Italy, Switzerland, San Marino, Vatican City, by minorities in Malta, Monaco, Croatia, Slovenia, France, Libya, Eritrea, and Somalia, and by immigrant communities in the Americas and Australia...
  
  , Japanese
  Japanese language
  is a language spoken by over 130 million people in Japan and in Japanese emigrant communities. It is a member of the Japonic language family, which has a number of proposed relationships with other languages, none of which has gained wide acceptance among historical linguists .Japanese is an...
  
  , Polish
  Polish language
  Polish is a language of the Lechitic subgroup of West Slavic languages, used throughout Poland and by Polish minorities in other countries...
  
  , Spanish
  Spanish language
  Spanish , also known as Castilian , is a Romance language in the Ibero-Romance group that evolved from several languages and dialects in central-northern Iberia around the 9th century and gradually spread with the expansion of the Kingdom of Castile into central and southern Iberia during the...
  
  , Russian
  Russian language
  Russian is a Slavic language used primarily in Russia, Belarus, Uzbekistan, Kazakhstan, Tajikistan and Kyrgyzstan. It is an unofficial but widely spoken language in Ukraine, Moldova, Latvia, Turkmenistan and Estonia and, to a lesser extent, the other countries that were once constituent republics...
  
  ).
• Graph capabilities to create charts showing table relationships.
• Bookmarks, which are user-defined code templates. SQuirreL comes with predefined example bookmarks for the most common SQL and DDL statements.

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

SourceForge

SourceForge Enterprise Edition is a collaborative revision control and software development management system. It provides a front-end to a range of software development lifecycle services and integrates with a number of free software / open source software applications .While originally itself...

 project since 2001, and is still being developed today.

Supported databases

• Axion Java RDBMS.
• Apache Derby
  Apache Derby
  Apache Derby is a relational database management system developed by the Apache Software Foundation that can be embedded in Java programs and used for online transaction processing. It has a 2 MB disk-space footprint.Apache Derby is developed as an open source project under the Apache 2.0 license...
  
  
• Daffodil (One$DB)
  Daffodil database
  Daffodil DB is a SQL 99 & JDBC 3.0 compliant 100% Java relational database management system. It has enterprise level features such as full text search, PSM, triggers, etc. It is available in both Embedded & Network editions....
  
  
• Fujitsu Siemens SESAM/SQL-Server with the SESAM/SQL JDBC driver
• Firebird
  Firebird (database server)
  Firebird is an open source SQL relational database management system that runs on Linux, Windows, and a variety of Unix. The database forked from Borland's open source edition of InterBase in 2000, but since Firebird 1.5 the code has been largely rewritten ....
  
   with the JayBird JCA/JDBC Driver
• FrontBase
  FrontBase
  FrontBase is a relational database for Others Mac OS X, MS Windows, Unix to the SQL92 standard support.FrontBase is a robust commercial, scalable database server that can operate virtually maintenance free...
  
  
• Hypersonic SQL
  HSQLDB
  HSQLDB is a relational database management system written in Java. It has a JDBC driver and supports a large subset of SQL-92 and SQL:2008 standards. It offers a fast, small database engine which offers both in-memory and disk-based tables...
  
  
• H2 (DBMS)
  H2 (DBMS)
  H2 is a relational database management system written in Java. It can be embedded in Java applications or run in the client-server mode. The disk footprint is about 1 MB....
  
  
• IBM DB2
  IBM DB2
  The IBM DB2 Enterprise Server Edition is a relational model database server developed by IBM. It primarily runs on Unix , Linux, IBM i , z/OS and Windows servers. DB2 also powers the different IBM InfoSphere Warehouse editions...
  
   for Linux, OS/400 and Windows
• Informix
  Informix
  IBM Informix is a family of relational database management system developed by IBM. It is positioned as IBM's flagship data server for online transaction processing as well as integrated solutions...
  
  
• Ingres (and OpenIngres)
• InstantDB
• InterBase
  InterBase
  InterBase is a relational database management system currently developed and marketed by Embarcadero Technologies. InterBase is distinguished from other DBMSs by its small footprint, close to zero administration requirements, and multi-generational architecture...
  
  
• Mckoi SQL Database
• Microsoft Access
  Microsoft Access
  Microsoft Office Access, previously known as Microsoft Access, is a relational database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of...
  
   with the JDBC/ODBC bridge.
• Microsoft SQL Server
  Microsoft SQL Server
  Microsoft SQL Server is a relational database server, developed by Microsoft: It is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network...
  
  
• Mimer SQL
  Mimer SQL
  Mimer SQL is an SQL-based relational database management system from the Swedish company Mimer Information Technology AB , which has been developed and produced since the 1970s. The Mimer SQL database engine is available for Microsoft Windows, Mac OS X, Linux, Symbian OS, Unix, VxWorks and OpenVMS...
  
  
• MySQL
  MySQL
  MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My...
  
  
• Netezza
  Netezza
  Netezza designs and markets high-performance data warehouse appliances and advanced analytics applications for uses including enterprise data warehousing, business intelligence, predictive analytics and business continuity planning....
  
  
• Oracle Database
  Oracle Database
  The Oracle Database is an object-relational database management system produced and marketed by Oracle Corporation....
  
   8i, 9i, 10g, 11g
• Pointbase
• PostgreSQL
  PostgreSQL
  PostgreSQL, often simply Postgres, is an object-relational database management system available for many platforms including Linux, FreeBSD, Solaris, MS Windows and Mac OS X. It is released under the PostgreSQL License, which is an MIT-style license, and is thus free and open source software...
  
   7.1.3 and higher
• SAPDB
• Sybase
  Adaptive Server Enterprise
  Adaptive Server Enterprise is Sybase Corporation's flagship enterprise-class relational model database server product. ASE is predominantly used on the Unix platform but is also available for Windows.-History:...
  
  
• Sunopsis XML Driver (JDBC Edition)
• Teradata Warehouse
  Teradata
  Teradata Corporation is a vendor specializing in data warehousing and analytic applications. Its products are commonly used by companies to manage data warehouses for analytics and business intelligence purposes. Teradata was formerly a division of NCR Corporation, with the spinoff from NCR on...
  
  
• ThinkSQL RDBMS
• Vertica
  Vertica
  Vertica Systems is an analytic database management software company. Vertica was founded in 2005 by database researcher Michael Stonebraker, and Andrew Palmer; its President and CEO is Christopher P. Lynch. HP announced it would acquire the company in February 2011. On March 22, 2011, HP completed...
  
  Analytic Database