JSQLTool

JSQLTool is java swing SQL Tool which can be used to connect to a database, using a JDBC or ODBC Driver and view tables, views and synonyms list. Table data can be visually ordered or filtered. You can add/edit/delete records directly on the table data grid and table data can be exported as insert SQL statements, as text or in an Excel File Format. You can 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. The 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, and replicate a set of tables to another schema, by creating tables and populating them.