Visual ERD Diagram Editor
Design your entire PostgreSQL schema visually — drag tables, trace foreign keys, and auto-arrange layouts for 120+ tables without breaking a sweat.
Why another ERD tool?
Most database diagramming tools are either generic (DrawDB, dbdiagram.io) or stuck in the desktop era (pgModeler, MicroOLAP). PgDesigner is built exclusively for PostgreSQL and runs in the browser — with the depth of a desktop app and the speed of a modern web UI.
Interactive canvas that keeps up with you
Every table, column, index, and foreign key is visible and editable directly on the diagram. No switching between tabs or dialogs — the canvas is the editor.
Drag & Drop
Move tables freely. Pan with middle-click or trackpad. Zoom with scroll wheel or shortcuts.
Auto-Layout
One click arranges all tables — no overlaps, FK relationships respected. Works on 120+ tables.
Minimap
Navigate large schemas without losing context. The minimap shows your viewport position in real time.
FK Edge Routing
Foreign keys render as directed edges with smart path routing. Click any edge to open that foreign key in the Table Editor.
See every detail at a glance
Each table node shows column names with types (bigint, text, timestamptz),
inline PK / FK / UNIQUE badges, nullable markers, and a column count in the header.
Double-click any table to open the Table Editor with full column details, constraints, indexes, foreign keys, DDL preview, and lint results.
Handles real production schemas
PgDesigner is tested on five public sample databases, a synthetic edge-case schema, and private production schemas. The largest has 120 tables and 196 foreign keys — the canvas stays smooth.
| Database | Tables | FK | Performance |
|---|---|---|---|
| Chinook | 11 | 11 | Instant |
| Northwind | 14 | 13 | Instant |
| Pagila | 15 | 18 | Instant |
| Airlines | 8 | 8 | Instant |
| AdventureWorks | 68 | 89 | Smooth |
| Synthetic (domains, GIN/GiST, triggers, RLS) | 8 | 9 | Instant |
| Private production schema | 120 | 196 | Smooth |
The five public databases ship with the app as sample projects — open one from the Welcome Screen and start exploring.
Find anything in seconds
The Object Tree gives you a hierarchical view: schemas → tables → columns, indexes, and foreign keys. Need to jump somewhere fast? Ctrl+F opens Go To — type any table, column, or index name and you're there. Click a table to jump to it on the canvas; double-click it or press Enter to open the Table Editor, F2 to rename.
Create without writing SQL
Build your schema directly on the canvas. Press T and click an empty spot to place a table — it gets an identity primary key and opens in the Table Editor. Press F, click the child table, then the parent — the FK column and constraint appear automatically. Need a many-to-many? Press M and click both tables — PgDesigner creates the junction table with a composite PK and both FKs.
Keyboard Shortcuts
Canvas Hotkeys
Press ? to open the full keyboard reference.