Reading the ERD Diagram: Layout, Pan/Zoom, Isolate Mode, and Export
Diagram mode is the default view once a schema exists. Tables auto-layout on first analysis — a highest-degree-first traversal groups connected tables together, then an overlap-resolution pass makes sure nodes never collide — and you can drag any table afterward to override its position manually.
Navigation
- Pan by clicking and dragging the canvas background
- Zoom with the scroll wheel (zooms toward your cursor), the +/− buttons, or “Fit to screen”
- Click a table to select it, or hover to highlight it and everything it’s directly connected to — everything else dims
- A minimap in the bottom-right corner shows every node and your current viewport at a glance
The legend
- Solid green edge — a real, defined foreign key constraint
- Dashed amber edge — an inferred relationship, detected from naming convention (e.g.
user_idmatching auserstable) rather than a formalFOREIGN KEY - Red border — a table with at least one flagged gap
Isolate mode
Right-click a table for a context menu, then choose Isolate to hide everything except that table and its direct relations — useful on a large schema where the full diagram is noisy. A banner appears while isolated with a control to reset back to the full diagram.
Other canvas controls
- A “Show only gaps” filter toggle (available in both the sidebar and the canvas) hides tables with no flagged issues
- Each table’s column list is capped at 4 visible rows by default, with a “+N more” control to expand it — keeps dense tables from dominating the canvas until you ask to see them fully
- Click a table to open its sticky-note panel — free-text notes keyed to that table name, saved and loaded along with the rest of the schema
- Newly added tables (via Add Table in DDL mode) render with a distinct highlight until your next Save
Exporting
The diagram can be exported as SVG (direct download) or PNG (the SVG rasterized at 2x scale before download), preserving gap-flag styling. The exported filename is derived from the schema’s name in the top bar, so rename the schema first if you want a specific filename.