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.

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.

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.

DB Explorer is a powerful, cross-platform Java-based database query tool and explorer designed for developers, DBAs, and data analysts. It provides an intuitive GUI for connecting to multiple databases including PostgreSQL, MySQL, SQL Server, Oracle, SQLite and Dynamo DB along with support of connection any of database via Generic JDBC driver. Key features include real-time SQL execution with syntax highlighting, interactive schema browsing, result pagination with lazy loading, query export capabilities, and memory management controls including a garbage collection button. The application includes connection pooling, health monitoring, multiple themes, and keyboard shortcuts.

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

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.

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.

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.

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

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.

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.

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.

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

An open-source SQL editor write in Java.

a small and fast Java SQL client

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.

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.

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

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.