Open Source Java 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.

An easy-to-use BI server built for SQL lovers. Power data analysis in SQL and gain faster business insights. Platform independent web application. Single JAR file + Single SQLite DB file. Get up and running in 5 minutes. PostgreSQL, Oracle, SQL Server, MySQL, Elasticsearch... You name it. No ETLs, no generated SQL, polish your own SQL query to transform data. Pixel-perfect positioning + Drag'n'Drop support to customize the reports and charts in your own way. Utilize the power of dynamic SQL with query variables to connect Filters and Charts. Capture the snapshot of historical data. Free up space in your own database. Three system level role configurations + Group based report access control. Custom the language pack and translations just for your audience. Auto refresh, drill through, fullscreen, embeds, color themes + more features in development.

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.

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

includes SQL editor with syntax highlighting, code completion and templates, visual editing of database objects (tables, indexes, etc.), debugger of stored procedures, editable results, import/export features

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.

ORBIT : Operating Business Intelligence Tool Making Data Accessible Through Centralized Database Access ORBIT is a business intelligence tool designed to make data accessible to a broad audience within your company by centralizing access to databases. With this application, users can easily create reports, perform interactive analyses, and extract insights from raw data. The application simplifies data handling by providing easy-to-use features for non-technical users while maintaining flexibility for advanced queries.

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.

A command line database interface / sql client written in Java. Can be run from a command shell. Configurable via command line or properties files. Features command history and more...

SQL Star, a SQL client provides a common Graphical User Interface (GUI) for all database servers (like, oracle, microsoft sql server, mysql etc.,) using JAVA JDBC 3.0 API With type 4 driver.

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.

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.

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

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).

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.

Web-based Squirrel SQL client. it allow you to view database structure, import/export and manage your databases, including create database, table, store procedure, view,trigger and user. it support oracle, db2, mysql, MS SQL server, FireBird,Postgres

Some experimental SQL client generation code for building client packages and other various half completed trials - (mostly around databases, particular Firebird).

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.

Lily Sql Client is a pure java client that supports jdbc databases such as Oracle, Mysql, DB2, and so on. It's written in java and runs on windows, linux and Mac OS.

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.

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.

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).

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