DbSchema Layouts

DbSchema layouts are interactive. Tables, columns, foreign keys can be created directly in the layout. The layouts ( you can create more ) are saved to project file.

JDBC Connection DbSchema Diagram DbSchema ER Diagram DbSchema Layout
DbSchema Table Editor DbSchema Database Foreign Key DbSchema Drag and Drop
DbSchema Query Builder DbSchema Configuration DbSchema select tables DbSchema Preview Data DbSchema search table

Relational Data Browse and Editor

Relational Data Browse is one module inside DbSchema useful for exploring and editing table data by keeping track of the foreign keys between the tables.

Relational Data Browse DbSchema Filter data
DbSchema data filtering DbSchema edit table data Visible diagram columns

Query Builder

Visual oriented query builder with different join types, group by, etc.

Query Builder Query Builder add Table SQL Preview Window
Graphical Execution Plan Query builder join conditions

Sql Editor

Autocomplete-enabled SQL editor with groovy support, script execution, graphical explain plan, etc.

SQL Editor SQL Autocomplete editor SQL graphical execution plan SQL History

Schema Documentation

DbSchema can generate web-compatible HTML5 documentation including the interactive layout images ( *.svg ).
By moving the mouse over the tables or columns comments can be read.

Database Schema scripts PNG database diagram HTML5 database documentation