The art of keeping data together
Interact with the schema directly in the diagram.
Double-click any table header or columns to edit.
Connect to the database using JDBC driver.
All relational databases are supported.
Build hierarchical forms and reports using DbSchema.
Forms and reports for mobile and tablet devices using bootstrap, groovy logic included, etc.
Interactive HTML5 vector images for Web browsers.
The documentation can be opened in the browser and schema comments can be read as mouse-over tooltips.
Foreign key lines are pointing to columns. Two lines may share the same line.
Customizable look and feel.
Edit SQL queries with different join types, group by, order by, just using the mouse.
Insert test data into the tables based on customizable reverse regex-patterns.
Explore and edit data from multiple tables connected with foreign keys.
If you miss foreign keys, create virtual foreign keys in the layout.
DbSchema holds its own image of the schema.
The internal image can be compared with different databases, scripts can be generated.
Multiple layouts can be created. They will be saved to project file.
Choose from the menu to show the column data type in the layout.
Autocomplete-enabled SQL editor, with graphical explain plan, script execution, etc.