PgDesigner is a visual schema designer built exclusively for PostgreSQL. Design schemas on an ERD canvas (120+ tables), generate production-ready DDL for PostgreSQL 18, compare versions with hazard-aware diff engine, and validate with 66 lint rules — all in a single binary. No cloud, no account, no telemetry. All data stays on your machine. Free for personal use. $19 one-time for commercial.
No reviews yetBe the first to leave a review for PgDesigner
Hunter
📌
Hey Product Hunt! I'm Sergey — I've been designing PostgreSQL schemas professionally for 15+ years.
The problem:
Every schema tool I tried made me choose between:
- PG-specific but dated UI (pgModeler)
- Modern UI but database-agnostic (DrawDB, dbdiagram)
- Diagrams-only, no migrations (dbdiagram.io)
None of them score 4/4 on: PG-specialized + git-friendly format + diff engine + modern browser UI.
What PgDesigner does:
- Visual ERD canvas — tested on 120+ table schemas
- Full PG18 DDL generation (partitions, RLS, domains, triggers)
- Diff engine: compare two schema versions → safe ALTER SQL with hazard warnings (flags data loss, table locks before you run anything)
- 66 lint rules with autofix (missing indexes, naming, FK integrity)
- Git-friendly .pgd XML format — clean diffs in PRs
- Import from pgModeler, DbSchema, SQL dump, or live PG connection
- CLI for CI/CD: lint, diff, generate, convert
Stack: Go + Vue 3.5, ~11K lines, ships as a single binary. No CGO — SQL parsing via pg_query compiled to WebAssembly.
Free for personal and open-source use. Commercial: $19 one-time (individual), $49 (team of 5). No subscription, no telemetry.
Try the live demo — no install, no signup: demo.pgdesigner.io
What PostgreSQL schema pain points do you hit most often? I'm prioritizing the roadmap based on real feedback.