Screenshots

Interactive diagrams
g1

Work over multiple layouts ( diagrams )

g1

Edit tables, columns, etc. by double-clicking them.

g1

Add tables to layout by drag and drop from the Structure tree.

g1

Open multiple layouts at a time. A table can be listed in multiple layouts.

g1

Show columns data type in layout.

g1

Foreign keys can be drawn joined to column - a line may be shared by multiple foreign keys.

Connect to database
g1

Configure database connection using JDBC driver

g1

Manage the JDBC drivers and connection Url

g1

Start DbSchema project from existing database and decide which schemes to use

Edit schema online/offline, synchronize schema with the database
g1

Editing schema online will apply changes in database and DbSchema, offline only in DbSchema

g1

Synchronize the schema with the database

g1

Apply commit synchronization actions on the database

Relational browse database data
g1

Browse data from multiple tables. Child tables shows the records related to the parent table.

g1

Add parent table to the browse pane by drag and drop from the layout pane.

g1

Add child table by pressing the Fk icon.

g1

Set filter over one table column.

g1

Show one record or multiple table records at a time.

g1

Data Browse editor is saved in the project file under the owning layout.

SQL Editor
g1

Open the SQL editor inside a layout

g1

Make use of the auto-complete feature

g1

Create multiple result panes and increase the result row height.

g1

Decide to write the SQL result directly to file.

Query Builder
g1

Edit and execute queries using the Query Builder

g1

Choose a different join type

g1

Using aggregate functions will generate Group By queries.

Documentation
g1

Comment your schema using comments for each table and column and Callboxes.

g1

Generate XHTML web interactive documentation.

Look and feel
g1

Architect look and feel

g1

Blue eyes look and feel

g1

Different Java Look and Feel