Java Open Source Projects Directory

...dedicated into Java open source projects

  • Increase font size
  • Default font size
  • Decrease font size
SQL Clients


A command line sql client that is targeted to be as userfriendly as possible on the commandline. It contains features like tabcompletion, history, help. It uses JDBC so it can be used in as many database types as possible.



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.



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



HenPlus is a SQL shell written in Java that works for any database that offers JDBC support. It supports:

 * Any JDBC aware database.
 * Has context sensitive command line completion for commands and tables / columns / variables within SQL-commands.
 * Multiple open connection-sessions can be handled in parallel. You can just switch between them. So you can be connected to different databases to experiment with the same statement in all of them, for example.
 * All JDBC-Urls of opened sessions are stored for later command line completion in the connect command.
 * Command line history just like in the bash (with cursor-up/down, CTRL-R, ...)
 * A describe command for database tables, that work all JDBC-Drivers that unveil the appropriate MetaData (Oracle, PostgreSQL, MySQL, DB2...)
 * supports variables that are expanded like shell variables with $VARIABLENAME or ${VARIABLENAME} (with completion of their names, just like in bash)
 * Dumping/Loading files across databases
 * Supports several built-in commands (start, @, @@, spool) and syntax from the Oracle SQL-plus utility (like the single '/' on a line to close a statement). Most Oracle SQL-plus scripts will run directly, so its simple to switch to HenPlus.
 * Allows a per-project storage of the commandline history, variables, plugins and connections.
 * Allows to add your own plugins that behave just like the built-in commands.



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.



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 Oracle's 100% Java JDBC driver.



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. You can find more information about this project at



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
 * manage, edit, and work with SQL files (
 * issue updates, deletes, and inserts using simple, easy-to-use wizards QuantumDB works with any JDBC-complaint database, including:
 * Adabas
 * DB2
 * DB2 on AS400
 * Informix
 * MySQL
 * Oracle
 * Pointbase
 * PostgreSQL
 * Sybase The QuantumDB developers regularly use a wide variety of database products as they add new features to the plugin.

  • «
  •  Start 
  •  Prev 
  •  1 
  •  2 
  •  3 
  •  4 
  •  Next 
  •  End 
  • »

Page 1 of 4