DIAGRAM & DISCOVERY

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_id matching a users table) rather than a formal FOREIGN 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.

ERD Factory

Schema visualization & analysis for people who ship databases.

© 2026 ERD Factory