Divide complex schemas into separate layouts (groups of tables) for a better representation of the database. Use the layouts to browse and edit the schema visually, without having to write any SQL queries.
Double-click any table directly in diagram to edit.
Create new foreign keys by drag&drop of one table column
Design schema offline and create it later in database
Draw foreign key line from table to table or from column to column mode.
Use different foreign key notation: Idefix, Barker, etc.
Use for each table a different color, place comment callouts.
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.
View data from multiple tables simultaneously based on normal or foreign key relationships.
Double click any cell to edit
Your data browse editor will be saved in the project file so you can access it next time you start DbSchema.
Apply filters and data sorting mechanisms to browse more efficiently
If your schema is missing foreign keys, create virtual foreign keys. They also can be used in relational data browsing.
Easily access BLOB or CLOB files in DbSchema
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.
DbSchema offers a wide variety of predefined patterns.
DbSchema analyzes the column name and anticipates the data type.
Add a new pattern or edit existing ones.
See and organize patterns from pattern repository.
Visual Query Builder
Build SQL Queries visually, without having to write any line of code. Add and edit tables with a simple click.
Tables can be joined using normal or virtual foreign keys.
Can switch between LEFT, OUTER and EXITS joins
Make use of COUNT(*), AVG(), SUM()
Set filters on columns
Connect to any Database & Reverse Engineer the Schema
Start a new project by reverse engineering the schema. Save the schema structure to the project file and you can reopen it without database connection.
Connect to any relational database using JDBC Drivers
If the database you’re working with is not on our drivers list, upload its JDBC Driver in DbSchema
Open and edit your schema without being connected to the database
Work on your database through secured connections
DbSchema is using it’s own image of the schema saved to the project file. This enables you to open and modify the schema offline, then synchronize it when you connect to the database.
Choose what happens with each difference found in the schema.
Easily convert your schema to a different database.
You can generate SQL Scripts for every database modification.
Use DbSchema to update the database to the latest schema version.
Automate Your Tasks
DbSchema can read Groovy or Java Scripts enabling you to easily automate tasks:
Forms & Reports
DbSchema integrates a very powerful and fully customizable Forms & Reports Engine that can be used for:
DbSchema integrates multiple themes so you can personalize your interface.