Open Source SQL Clients

SQuirreL SQL Client is a graphical SQL client written in Java that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.

TOra is a Toolkit for Oracle which aims to help the DBA or developer of database applications. Features PL/SQL debugger, SQL worksheet with syntax highlighting, DB browser and a full set of DBA tools. TOra also includes support for MySQL and Postgres.

Redash is an essential tool to help you make sense of your data. It allows everyone, regardless of level of technical know-how to harness the power of data. SQL users connect, query, visualize and share data easily and efficiently, allowing everyone in their organization to use the data. Redash combines the power and comfort of an SQL client with the collaborative benefits of a cloud-based service. It lets you create big, beautiful and easy to digest visualizations on dashboards for better decision-making. Redash supports a multitude of SQL and NoSQL data sources, and can be extended to support even more. Best of all it’s open source, so you can customize and add features to suit your organization’s needs perfectly.

Eclipse SQL Client for database querying/browsing any JDBC compliant database. It supports plugins with specialized functionality for individual databases (Oracle, DB2, MySQL, PostgreSQL, Sybase, Informix) and can be extended.

Jisql is a Java based utility to provide a command line interactive session with a SQL server. It can connect to any database with a JDBC driver.

Quantum is a database plugin for Eclipse (needs GEF, Point Eclipse at http://quantum.sourceforge.net/update-site). It currently supports most databases with a JDBC driver. It shows tables, views, and sequences in a tree format and provides an SQL editor

JspMyAdmin 2 is the software for MySql database administration over Web. It provides a user friendly design to manage most of the MySql database administration. Create and Manage database objects (Databse, Table, View etc..) with simple mouse clicks.

JSQL Edit is a database-independent SQL client that allows graphical manipulation for making queries to databases. JSQL Edit is written in Java and uses JDBC for connectivity and Java Swing for a graphical user interface.

Vela is a Open Source SQL and PL/SQL client software for Oracle database with a graphical user interface developed using Java Swing. It is a Front-End tool for a Oracle developer. It supports most of the common developer tasks.

DBPad is a GUI-based SQL client for relational databases. As long as you have a JDBC driver for your DB, you can use DBPad to view or manipulate your data and metadata of your tables.

Eclipse SQL plug-in. Contains SQL editor and executor. Table editor, data retrieve and migration tools. Plug-in has extensions to be used in other projects that need database connectivity.

a small and fast Java SQL client

ProDBA The cross platform Oracle development/administration tool written in Java. Features a powerful SQL editor and schema navigator. Can export dynamic queries to the web.

Currently dead. Web-based SQL client that can connect to any number of databases using JDBC. Provides a clean, simple and fast interface using HTML and Javascript to make it very easy to run common SQL queries. Faster than your average Swing-based client

SQL-Kitten is a generic sql client written in Java that can be used to connect to any jdbc compliant database. Some features are: Run SQL queries, Search within resultsets, Easy insert/update/delete, insert/update CLOB and BLOB datatype

SQLMinus - "sqlplus minus the pain". This SQL Client (Java) is very configurable, completes table and column names upon tabbing. Completes other words and abbrevs (vi-style). Powerful auto-linking across tables. Powerful auto-joining across tables.

DB Copy Plugin is a plugin for the SQuirreL SQL Client (1.2beta6 and 2.0 RC1+) that allows copying database objects (schema def and data) from one session window to another. The sessions can be disparate database vendors (Oracle -> MySQL, for instance).

Simple java based command line SQL editor. Will connect to any database that you can provide a JDBC Type 4 driver for (in the form of a jar).

Sqled is a simple sql editor to write and execute sql and ddl commands, and shows query results in a grid table view. It helps user with sintax highliting and table list selection.

A low weight replacement for TOAD. Java based app had tabbed UI to support multiple connections.

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.

A small .NET application that allows you to connect to the Microsoft Access database files (*. mdb) and execute SQL-queries to them. More information in russian can be fount here - http://2lx.ru/2009/02/mdb-sql-client/

Lightweight SQL querying tool written in Java. Connects to any JDBC compliant database and will run on any OS with a Java VM. Features: keyword highlighting, result formatting, statement history, multi-window, multiple database connects at one time.

This project will add support for editing Oracle PL/SQL objects right inside the NetBeans IDE, including syntax highlighting, code folding and indentation. See Wiki for more information.

SQL editor, execution of scripts, export results (.xls).