ERD Visualization
Zentro generates an Entity-Relationship Diagram (ERD) from your live database schema — no configuration, no manual drawing. The diagram updates whenever the schema changes.
Opening the ERD
- In the Schema Explorer, click the ERD button in the toolbar
- Or press
Ctrl+Shift+Efrom anywhere in the app
The diagram renders for the currently active database.
What's Shown
| Element | Representation |
|---|---|
| Tables | Rectangles with column list |
| Primary keys | Key icon next to column name |
| Foreign keys | Arrows between tables |
| Nullable columns | Shown in lighter color |
| Indexes | Shown as a tooltip on hover |
Navigation
- Pan — click and drag the canvas
- Zoom — scroll wheel, or use the
+/-controls - Fit to screen — press
For click the fit button - Select table — click any table node to highlight it and its direct relationships
Filtering
For large schemas with many tables, a search box in the ERD toolbar lets you filter visible tables by name. Hidden tables' foreign key edges are also hidden.
The ERD renders up to 100 tables by default. For larger schemas, use the filter to focus on a subsystem.
Exporting
Click Export to download the current view as a PNG image. The exported image captures the visible canvas at 2x resolution.
Supported Databases
ERD generation is supported for PostgreSQL, MySQL, MariaDB, and SQL Server. SQLite foreign key relationships are shown only if the schema defines them with FOREIGN KEY constraints.