Features Overview

DbSchema Layouts

DbSchema uses layouts to represent the schema. New tables, columns or foreign keys can be created directly in the layout. Double-click a column or table to edit it or drag a column over another to create a foreign key.

To have a better understanding of the schema you can create multiple layouts, each focused on a specific part of the schema. A table may show in more than one layout. The layouts and the schema structure will be saved in the DbSchema project file. Read more about layouts...

Reverse Engineer Schema From Database

When you start a new DbSchema project you can choose to connect to the database and load the schema into DbSchema. The schema structure will be saved in the DbSchema project file.

DbSchema uses JDBC drivers to connect to any relational database.

Relational Data Browse

An amazingly simple and efficient relational data explorer that offers simultaneous views of data from multiple tables and features numerous filters, data sorting mechanisms, and much more. The advantage is the ability to explore the data from table to table based on the foreign keys joining the tables. Read more...

SQL Editor

Sql editor with syntax highlighting and code completion may help you during query editing. It can execute simple queries as well as scripts. The output can be displayed on screen or spooled directly to a file. You can auto-format SQL queries, do explain plan and many others. Read more...

Query Builder

Graphically compose complex queries. You can make use of different join clauses like LEFT OUTER JOIN, you can use WHERE filters or GROUP BY clauses. All this work is intuitive, you don't have to remember table or column names. Adding new table to the query is an easy job. You can also make use of GROUP BY clauses into your queries. Read more...

Flexible Application Interface & DbSchema Project File

DbSchema uses layouts to let you structure your work. Inside the layout you can have Data Browse Panes, SQL Editors and Query Builders. Saving the DbSchema project to file all of them will be saved. Opening the application next time will also open this editors.

Generate Schema Scripts

In DbSchema you can generate the schema scripts and optimal export the data into script. Using the generated script you can recreate the schema on any database.

One Project - Multiple Databases & Schema Synchronization

DbSchema is using its own image of the project schema. This will be saved in the DbSchema project file to disk. You can reopen the project without connecting to database and continue to edit the schema. Than you can connect to different databases and synchronize the schema. This means that you can decide for each table, column, etc. which is missing on database or local project to create it or drop it on one side ( from database or from local project ).

Convert Schema to a Different Database

Since the DbSchema project is independent from database you can change the project Rdbms in Project Properties. Than you can create or synchronize your schema with a different database. Changing the schema Rdbms will apply a new data type mapping for all columns, based also on the standard java SQL data types.

Smart Printing

DbSchema can print the best layout images. You can also print the layouts as images or generate HTML documentation including small-size vector images.

Documentation

You can enter comments or call-outs for any of the schema tables, columns, etc. Moving the mouse over the layouts you will see this comments as tooltips. This may help you easy understand the tables and columns definition. Using the feature of generating HTML documentation including SVG image of the layout you can post an interactive HTML documentation in your project or on the Web.