Database Navigator

Browse through your database in a Mac OS X Finder style column view. You can view and edit your current table content (including BLOB information, like images or RTF text), export your table content to a variety of file formats (CSV, HTML, etc.) or drop and create tables. The Database Navigator is your ideal companion for managing your tables and shows an expert all he wants to see in one window. Corner menus (accessible through the blue triangle in the upper right corner of each list or table) give you access to over 200 actions and assistants based on the currently connected database server and you current selection.

more >>

SQL Viewer

Run SQL Queries (and stored procedures) which display one result table. The result table is displayed in a table view (including BLOB information, like images or RTF text) and can be exported to a variety of formats (CSV, HTML, etc.).

SQL Viewer supports SQL syntax coloring for ANSI SQL92 commands. Queries can be saved in "Favorite Queries".

more >>

SQL Console

Run one or multiple SQL commands (scripts) with the SQL Console. Enter (or load) your commands in the lower part of the console. Database output is displayed in the upper part of the SQL Console or directly copied to the clipboard (depending on settings) in MS Excel tab-delimited format.

Support SQL syntax coloring for ANSI SQL92 commands and table/field name auto-completion for many database servers. Queries can be saved in "Favorite Queries".

more >>

New Connection Assistant

The New Connection Assistant makes it easy to connect to your database server. Select your server type and the New Connection Assistant will check if you have already installed a suitable JDBC driver. The assistant tells you how to get and install a driver if you need one (for several databases the driver download can be done automatically).

Direct Import Assistant

Easily import text files (CSV, tab-delimited, etc.) into your tables. The assistant supports most common file formats (CSV, tab-delimited, etc.) and features, including international character support and character set conversion.

Export Assistant

Export table contents or query results to a wide variety of text file formats (CSV, tab-delimited, XML, HTML or MS Excel).

Create Table Assistant

Graphically compose your new tables. Supports ANSI SQL92 and all special data types offered by Oracle, MS SQL Server, MySQL, PostgreSQL, OpenBase and Sybase. The assistant automatically detects your database type and offers enhanced options for your database server, including all data types, auto-incremental fields (if supported by your database server), primary key creation and many other options.

SQL Query Assistant

Create simple queries with this straight forward and easy to use assistant. Select fields, selection criteria and sort order via a graphical interface. The result is displayed with SQL Viewer.

Data Transfer Manager

Copy tables from test to production servers or migrate tables. The Data Transfer Manager (DTM) makes it easy to transfer data between different database servers, even if you are using databases from different vendors.

PHP and JSP (Java Server Pages) Code Generator

Use SQL4X Manager J to easily build PHP and JSP code from your database and table definitions. The Code Generator automatically creates web pages to list database/table contents and add, edit and delete records.

Reporting Tool

Create and print simple reports with the builtin Reporting Tool. Easily converts your query results or table contents to a report template.

Database Information Panel

The glue to keep all these pieces together is the Database Information Panel which is always visible with status information. You can easily access any of the main interface components and some assistants with the Database Information Panel.

Message Viewer

Database error messages are displayed in a special Message Viewer which logs error messages by time and date.