Visual ERD diagrams, DDL generation, schema diff & safe ALTER migrations for PostgreSQL.
brew install vmkteam/tap/pgdesigner 
PG-specialized. Git-friendly format. Diff/ALTER engine with hazard detection. Visual editor. All four free and open source.
See your entire schema at a glance. Drag, zoom, auto-layout. Tested on 120+ tables with smooth performance.
Production-ready DDL from your model. 19-step dependency order. 99.7% round-trip fidelity on 630+ tables.
Two schemas in, safe migration out. 10 hazard codes, including DELETES_DATA, TABLE_REWRITE and BACKFILL_REQUIRED.
Catch FK mismatches, missing indexes, naming issues, antipatterns. 15 rules with autofix.
Populate your database in one command. FK- and CHECK-aware, 30+ name heuristics, reproducible with seed.
PDD, DBS, DM2, SQL, live PostgreSQL. Migrate from any tool in minutes.
.pgd XML optimized for clean single-line diffs. Review schema changes in pull requests like code.
Partitions, temporal constraints, virtual generated columns, IDENTITY. 70+ data types.
pgdesigner lint, diff, generate, testdata, merge in your pipeline. Zero dependencies, single binary.
Explore a real database schema in your browser. No download, no signup — just click and see.
PG specialization, a git-friendly format, a diff engine with hazard detection, and a visual editor — with no paid edition.
| Feature | PgDesigner | pgModeler | DrawDB | Atlas |
|---|---|---|---|---|
| PG-specialized | ✓ | Yes | — | — |
| Git-friendly format | ✓ | Plus (split model) | — | Yes |
| Diff/ALTER engine | ✓ | Plus | Basic | Yes |
| Hazard detection | ✓ | — | — | Pro (migration lint) |
| Schema lint | 69 rules | Model validation | — | Pro (migration lint) |
| Sample data generator | ✓ | — | — | — |
| Visual ERD | ✓ | Yes | Yes | Pro (cloud) |
| Price (individual) | Free (Apache-2.0) | Plus from $65.90 / 6 mo | Free | Pro $9/dev/mo |
Apache-2.0 — every feature, for any use, including commercial.