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

MyWebSQL is a web based WYSIWYG Database client written in PHP. It has a simple and intuitive interface with the look and feel of a desktop application, and offers rich features for database management. No installation is needed, just download, extract and you are ready to go. It even has a single file compact version with full functionality, which you can quickly deploy on your server. Currently MyWebSQL supports working with MySQL, PostgreSQL and SQLite databases.

Just use the portable copy of the free sqlitebrowser program, available here : https://sqlitebrowser.org/dl/ to open and test the sample db, that I have given as a download here ( after extracting the zip file ) . Also, I have enclosed, the csv files, that I have used for importing and exporting, from the file menu of the program. Also, watch the video below, for a quick start. Tags: Learn SQL Quickly, Analyze Data Easily, SQL Guide, SQL Samples

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.

The Hironico Db Tool is a graphical database client that can run on all major platforms today. It provides a powerfull, feature rich and user friendly set of tools to work with databases of any vendor using Java drivers while being fast & light.

This project builds upon the MongoDB Java driver to provide a limited JDBC implementation to allow graphical tools such as SQuirreL SQL Client to visualize and manipulate MongoDB collections and documents. It will accept an SQL-like syntax for CRUD operations, where "tables" represent MongoDB collections, and rows are individual documents within a collection. Each row has two columns (ObjectId and Document).

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

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.

Java Database Manager, harnessing the power of JDBC. Makes database management interoperable. Features Database diagram generation, reports generation, graphs generation, code generation and usual database client features.

jdbc2jdbc is a JDBC 2.0 driver (type 4) that sits between a database client and another JDBC driver. It is completely transparent to the database client. Its purpose is to log all actions that the database client executes on the database.

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.

This project is intended to create a common database client to any database that can be accessed via JDBC.

a small and fast Java SQL client

ErlMySQL is a MySQL client written in Erlang and provides API that is very close to Connector/C library. The client is using low level (TCP/IP socket) connection to MySQL server and allows to exchange a data with maximum possible speed. Multiple datasource support and connection pool are incapsulated in the client that increases a performance in concurrent environment.

This is the MzzCRM CRM database script that consists of a single input textbox on a web page that stores them into a MySQL database table. It has one field so that the person inserting the case notes can insert the case notes quickly and has the ability to include full details, or to leave full details out. The script is designed to perform the essential first action of a CRM -- creating the case notes. If needed to browse or access the data later after it was input, use another 3rd party MySQL database client tool to view/report the data. However there is a message box at the top of the interface that lets you know if the row/record was input successfully or conversely whether there was an error. The script performs validation so can handle special characters such as quotation marks. The script supports English and Chinese language.

PhpMyAjax is an open source OOP/PHP5 application designed to mimick the MySQL standard client using AJAX. The app is 100% templatable so can be made to look fun as well as offering the flexibility of a CLI. Great for shared hosts without shell acess.

SDBC is a MS Access-like database client based on Java swing ui, able to connect to both local and network DBMS. It uses Derby for file-based database and JDBC for SQl-based DBMS.

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

Sq Database Client is an open source database client which has the ability to access any database which has a JDBC driver. It is intended for application developers, and focuses on viewing, sorting, and manipulating data.

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.

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.

Simple SQL query tool that allows to connect to MSSQL and MySQL servers and MS Access files. A form of linking queries is possible and showing result in a map or in a chart is build in.

db2db is a database client for transferring database objects (tables, their data, primary keys, foreign keys, indexes) among heterogeneous RDBMS. db2db is written in java and uses jdbc.

Easy Database Client (easydbclient) is a database client based on Java version 1.5.x, JDBC and SQL. It is intended to easily change from one database to another and manipulate it