DbSchema Features

Explore & edit databases visually, with a powerful design tool

Interactive Layouts

Gain a better understanding of the schema by creating multiple layouts, each focused on a specific part of it. Use the layouts to browse and edit the schema visually, without having to write any SQL queries. Create new foreign keys just by drag&drop or edit the tables by simply double-clicking. The layouts are fully customizable. Change the position and color of every table to have a better view of the database.

Relational Data Browse

Use this simple tool to view data from multiple tables simultaneously, based on foreign keys. There is no limit to how many tables can be opened at once. Apply filters and data sorting mechanisms to make your browsing more relevant. Add new records or edit existing ones with one click.
Using Relational Data Browse, you can create new virtual foreign keys that will link tables in your local project.

Relational Data Browse
SQL Editor

SQL Editor

Use this powerful queries editor to execute single queries as well as scripts. SQL Editor integrates syntax highlight and code autocompletion so you can seamlessly write queries. The output can be displayed on the screen, on multiple result panes, or spooled directly to a file.

Visual Query Builder

Visual Query Builder

Create queries visually by using different join clauses, where filters or generate group by queries. Easily add tables to the query by simply drag&drop.

Get your free 15 days trial!

Virtual Foreign Key

Virtual Foreign Key

This unique feature allows you to create a foreign key in your local schema. This is especially useful for defining a foreign key that does not exist in the database. This foreign key won’t affect in any way the database.

Schema Synchronization and Deoployment

Schema Synchronization & Deployment

DbSchema uses its own image of the schema, so you can edit it without having to connect to the database. Make changes in the schema offline and synchronize it later with the database. You can synchronize the schema even with a different database. Choose what changes you want to keep from the Schema Synchronization Panel.

Reverse Engineer the Schema

Reverse Engineer the Schema

Start a new project by reverse-engineering the schema from the database. The schema can be saved as a project file, and modified without a database connection. You can connect to any relational database using the JDBC drivers available on the site, or upload your own JDBC drivers.

Random Data Generator

Random Data Generator

Generate test data in your database using configurable, random and reverse regular expression patterns. A predefined repository of patterns will help you find the best data pattern for each column.

Forms and Reports

Forms & Reports

Using our powerful form engine, you can build small applications or create multiple master-detail sections. Use internal Java or Groovy scripts to model the report logic.

Data Loader

Data Loader

DbSchema allows you to easily import data from any delimited text, XML or Excel file. It’s very simple and integrates data pre-validation.