JSQLTool - Best Open Source Project, Library, Code in Java

JSQLTool is java swing SQL Tool which can be used to:

connect to a database, using a JDBC or ODBC Driver
view tables, views and synonyms list
for each table/view/synonym see entity details, like: structure, data, indexes, constraints, SQL script and triggers
table data can be visually ordered/filtered; you can add/edit/delete records directly on the table data grid
table data can be exported as insert SQL statements, as text or in an Excel File Format (XLS)
edit SQL statements in a SQL shell (by coloring SQL text according to syntax), by means of it you can execute queries or other statements and see query results; queries may contain parameters
previous SQL statements are recorded to allow re-call and re-execution
view a database schema E/R diagram, store and recall schemas, print and export them
replicate a set of tables to another schema, by creating tables and populating them. Replication task can be replicated to update data
many other features are available, according to the database type: edit/drop contraints, execution query explain plan, trace sessions

See Other Best Database Clients Projects in Java: