SQL Workbench/J is a free, DBMS-independent, cross-platform SQL query tool. It is written in Java and thus it should run on any operating system that provides a Java Runtime Environment.

It's main focus is on running SQL scripts (either interactively or as a batch), graphical query building or administration of the database is not the focus.

Current stable version: Build 100 (2008-05-17)
Current development build: 100.1 (2008-06-17)

Features:

• Display result data from SQL queries (Screenshot)
• Edit, insert and delete data directly in the result table (Screenshot)
• Automatically detect and delete dependent rows when deleting rows from the result table
• Full support for BLOB data in query results, SQL statements, export and import. Read more...
• Reformatting (Pretty-Print) of SQL Statements (Screenshot)
• Powerful export command to write text files, XML, HTML or SQL (including BLOB data).
  All user tables can be exported into a directory with a single command. Export files can be compress "on-the-fly".
• Powerful text and XML file import. A set of files (including compressed files) can be imported from a directory with a single command. Foreign key constraints are detected to insert the data in the correct order
• Select rows from related tables according to their foreign key definitions (Screenshot1 Screenshot2).
  
• Makros (aka aliases) for frequently used SQL statements
• Variable substitution in SQL statements including smart prompting for values (can be combined with Makros)
• Generate XML report of the database structure that can be used for re-engineering a database model.
• Compare two database for differences in the structure. The XML output can be transformed into the approriate SQL ALTER statements using XSLT
• A DataPumper tool to copy data directly between two servers (Screenshot).
  The functionality of the DataPumper is also available as a SQL command for batch processing
• Auto completion for tables and columns in SQL statements (Screenshot)
• All SQL Scripts (including Workbench specific commands) can be run in batch mode
• Connection profiles can be grouped for better overview (Screenshot)
• Support for pluggable Look & Feels (e.g. JGoodies Looks)
• Support for PreparedStatement if the JDBC driver implements the necessary meta data calls
• SQLWorkbench/J is free (License agreement)

SQL Workbench/J also displays important information about the structure of a database schema

• Display table, view and procedure definitions (Screenshot)
• Display view, procedure and trigger source code (Screenshot)
• Display foreign key constraints between tables (Screenshot)
• Search for data across all (character) columns in several tables (Screenshot)

RSS Feed available

Please report comments or bugs in the forum
Your feedback is very much welcome!