PgDesigner

PostgreSQL DDL Generator

Production-ready SQL from your schema — with every dependency resolved in the right order.

PgDesigner Generate Database DDL Preview dialog showing CREATE TABLE SQL with constraints for AdventureWorks in light theme

Why not just write SQL by hand?

With 10 tables it's fine. With 68 tables, 89 foreign keys, and a mix of enums, domains, views, functions, and RLS policies — the order matters. One misplaced CREATE and your script fails. PgDesigner resolves all of this automatically.

19-step dependency order

DDL is generated in the correct execution order — not alphabetical, but topological. Each step handles a specific object type, so foreign keys never reference tables that don't exist yet.

Steps 1–6

  1. Roles
  2. Schemas
  3. Extensions
  4. Types (enum, composite, range)
  5. Domains
  6. Sequences

Steps 7–12

  1. Tables + PK, UNIQUE, CHECK
  2. Enable row-level security
  3. Indexes
  4. Foreign keys
  5. Table and column comments
  6. Column storage

Steps 13–19

  1. Functions / procedures
  2. Materialized views, then views
  3. Indexes on materialized views
  4. Triggers
  5. RLS policies
  6. Other comments
  7. Grants

Foreign keys are always emitted as ALTER TABLE after all tables are created. Functions come before views, because views may call them; materialized views are sorted by their own inter-dependencies. Identity columns use inline GENERATED … AS IDENTITY — not separate ALTER statements like pg_dump.

99.7% round-trip fidelity — proven on 630+ tables

We don't just claim accuracy — we test it. The full round-trip cycle:

SQL → PGD → DDL → PostgreSQL → pg_dump → PGD → diff = zero changes
630+

tables tested

901

FK matched exactly

99.7%

fidelity

Tested on Chinook, Northwind, Pagila, Airlines, AdventureWorks, a synthetic schema with domains, GIN/GiST indexes, triggers and RLS, and private production schemas. The first five ship with the app as sample projects.

CLI — generate from the terminal

pgdesigner generate schema.pgd
pgdesigner generate -o schema.sql schema.pgd
pgdesigner generate schema.pgd | psql "$DATABASE_URL"

Pipe it into psql, commit it to git, or use it in your CI pipeline. Zero dependencies — single binary.

UI — preview before you generate

Press Ctrl+G to open the Generate DDL dialog. You get a full SQL preview with syntax highlighting, copy to clipboard, and save to file — all before a single statement hits your database.

Related

Diff & ALTER → Visual ERD → CLI Reference →
Download Free All Features