26 Open Source SQL Clients

Sql clients are essential tools required by every developer. They help developer to easily execute SQL queries on any database. They are also very important for troubleshooting any database related issue.

1. SQuirreL SQL Client

SQuirreL SQL is the most popular open source SQL clientClient. It provides a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.

2. iSQL-Viewer

iSQL-Viewer is an open-source JDBC 2.x compliant database front end written in Java. It implements across multiple platforms features of the JDBC API. It does everything through a single interface. iSQL-Viewer works with most database platforms, including PostgreSQL, MySQL, Oracle, and Informix. iSQL-Viewer provides a variety of tools and features to carry out common database tasks.

3. LiquiBase

LiquiBase is an open source (LGPL), database-independent library for tracking, managing and applying database changes. It is built on a simple premise: All database changes are stored in a human readable yet trackable form and checked into source control.

4. Henplus

HenPlus is a SQL shell written in Java that works for any database that offers JDBC support. So basically any database. Why do we need this ? Any database comes with some shell, but all of them have missing features (and several shells are simply unusable). And if you work with several databases at once (if you are a developer, then you do this all the time), switching between these tools is tedious.

5. QuantumDB

QuantumDB is a simple but powerful database access plug-in for the
Eclipse Development Platform. QuantumDB allows you to:

• connect to databases using standard JDBC drivers
• review schemas, tables, views and sequences
• look up column, index and foreign key information
• issue ad-hoc queries or other SQL statements against the database

6. dbbrowser

DBBrowser is an open source (GPL license), cross-platform tool which can be used to view the contents of a database. It supports CLOBS and BLOBS. It is designed to work with Oracle and MySQL. The user should never have to write SQL to view the data although a SQL window is provided. Support for ER (Entity Relationship) diagrams, XMLTypes and more DBMS is planned for the next version.

7. Jackcess

Jackcess is a pure Java library for reading from and writing to MS Access databases. It is not an application. There is no GUI. It is a library, intended for other developers to use to build Java applications.

8. SQL Workbench-J

SQL Workbench/J is a DBMS independet frontend for SQL databases. It can be used in batch mode and has strong export and import capabilities. It also offers some extensions to SQL (Variable substitution, BLOB support with local filenames) that try to unify handling SQL databases. It can copy table data directly between two different servers (batch and GUI).

9. SQL Admin

SQL Admin is a Java client application to connect and send queries to different databases through JDBC. The main idea is to create a multiplatform and multidatabase thin client.

10. SQLeonardo

SQLeonardo is a powerful and easy-to-use tool that lets you query databases. When you work in SQLeonardo, you work in a graphical environment and working with data in this environment means you do not need to understand SQL, the standard programming language for talking to databases.

11. SQLMinus

SQLMinus is an SQL Client with many developer-friendly features including :

• auto-linking across tables
• dependency discovery
• simple, intuitive and powerful keys to sort columns and filter data
• tab-completion of table and column names
• expansion of abbreviations (as in vi)
• expansion of previously entered words (as in vim)

12. GUAM

GUAM is, as the name implies, a GUI frontend to allow easy administration of MySQL users. It is written in Java and uses the Swing toolkit. Since it is a pure Java application, it is completely cross-platform and should work on any platform that has a full Java implementation (and maybe even some of the cut-down implementations). GUAM is released under the GNU General Public License (GPL).

13. JSQLTool

JSQLTool is java swing SQL Tool used to view/edit database tables content and to execute sql scripts, by connecting to a database using JDBC/ODBC. JSQLTool supports multi-language and internationalization.

14. Vela

Vela is SQL and PL/SQL client with graphical user interface developed as a open source front end tool using JDBC and Java Swing. It supports Oracle Database. Vela is a Front-End tool for a Oracle developer. It supports most of the common developer tasks such as browsing database objects, viewing table definitions, viewing table data. It also supports editing and compiling SQL and PL/SQL scripts.

15. DbmJ

DbmJui is an attempt to clone DBMGUI, the database manager for MaxDB (formerly known as SAP DB). DBMGUI is written in VB so it can only run on Windows platforms. DbmJui uses the Java programming language. It can run on every platform where a JVM is available. Every version of DbmJui > 0.1.5 (only 0.1.90 for now) uses SWT. Linux/GTK2 and Win32 releases are provided.

16. ViennaSQL

ViennaSQL is a GUI SQL client written in 100% Java. ViennaSQL can communicate with any database that has a JDBC driver. It should run anywhere Java runs. I use it on Linux and Windows NT 4.0 with Oracles 100% Java JDBC driver. ViennaSQL runs each query in a separate thread so the GUI remains alive while a query is running.

17. Adit

Adit is another database interface tool built with Java. Adit is meant to be a lightweight tool for querying a database.

Some of the current features include:

• Connect to any database with a JDBC driver
• Save query results to a delimited file
• Save and restore SQL statements to disk
• View tables and field definitions
• Get information (properties) about a query

18. DataBase Java Console

DataBase Java Console (DBJC) is a console program that allows people to query a database with predefined SQL queries, or to make repetitive queries (with different parameters) for administration purposes.

19. QueryForm

QueryForm is a robust Java application that provides a powerful GUI front end for JDBC-enabled databases. It creates forms on-the-fly through which you can query tables and browse the results with just a few keystrokes or mouse clicks. It also lets you insert, update and delete table rows without typing any SQL statements.

20. SqlShell

SQLShell is a fully functional textual database frontend with features like tabcompletion, command history optimized display and many more. SQLShell uses JDBC to connect to your favorite database. SQLShell has been succesfully tested on windows and linux.

21. PKLite SQL Client

PKLite SQL Client is an Open Source Java program can connect to any JDBC compliant database. It has basic query and update functionality and some simple database information capabilities. The goal of this project was to create a lightweight SQL client (under 1 MB) that was portable, easy to install and be vender independent. There are still some issues to be worked out so that is can be completely database vender independent but with this new build it is able to connect to any database that has a JDBC driver and run on any OS that has a Java VM.

22. jisql

Jisql is a Java based utility to provide a command line interactive session with a SQL server. This application is conceptually modeled on the Sybase isql program with, obviously, strong similarities to Microsoft SQL/Server isql and osql (as Microsoft got SQL Server from Sybase). The program can act in a similar way to Oracles sqlplus and PostgreSQLs psql.

23. Datastream Pro

Datastream Pro is a database browser and data manipulation tool. It is intuitive, easy to use, reliable and stable. It supports almost any JDBC compliant database (tested on Oracle, MySQL, postgreSQL and HSQLDb). It is avaliable on both Linux and Windows. Datastream Pro allows you to browse and edit the data in your database. Run SQL queries and scripts, Simultaneously connect to multiple databases, has an easy to use connection wizard, Secure, personalised settings for connections and preferences and even has a built in text editor.

24. Execute Query

Execute Query is an operating system independent database utility written entirely in Java. Using the flexibility provided by Java Database Connectivity (JDBC), Execute Query provides a simple way to interact with almost any database from simple queries to table creation and import/export of an entire schemas data.

25. MyJSQLView

MyJSQLView provides an easy to use Java based user interface frontend for viewing, adding, editing, or deleting entries in the HSQL, MySQL, Oracle, and PostgreSQL databases. A query tool allows the building of complex SELECT SQL statements. The application allows easy sorting, searching, and import/export of table data.

26. DBSA

DBSA (DataBase Structure Analysis) is a tool for comparing schema snapshots. Differences are reported and an SQL patch can be generated. It includes a basic repository facility for schema history tracking