Skip to content

pgdesign

PostgreSQL schema compiler that turns declarative TOML into DDL, content-addressed migrations, diagrams, docs and type-safe client code, with normal-form auditing

Go cli 0.27.1

go install github.com/smm-h/pgdesign/cmd/pgdesign@v0

What it is

PostgreSQL schema compiler that turns declarative TOML into DDL, content-addressed migrations, diagrams, docs and type-safe client code, with normal-form auditing

Describe your database schema in TOML once, and get DDL, normalization auditing, content-addressed migrations, diagrams, docs, and type-safe client code in Go, Python, TypeScript, Java, Kotlin, and Zig

It is for teams who keep a PostgreSQL schema in version control and want every generated artifact, migration and database to stay in step with it.

What it does

Install

Go
go install github.com/smm-h/pgdesign/cmd/pgdesign@v0
npm
npm install pgdesign
PyPI
pip install pgdesign
Package names
  • Gogithub.com/smm-h/pgdesign
  • PyPIpgdesign
  • npmpgdesign

More tools

reposummary

Go

Turn a git repository's history into a Markdown journal: pick a time window or revision range and get a readable digest of what changed, optionally narrated by an LLM

rlsbl

Python

Release orchestration and project scaffolding CLI that bumps versions, validates a structured JSONL changelog, tags only the commit CI verified, and publishes to npm, PyPI, Go and more

safegit

Go

The Git CLI that is safe to hand to your AI Agents: no sharp edges by design, commit concurrency built-in, Git-compatible because it uses Git plumbing under the hood

One email a month

The digest goes out on the first Tuesday of the month: what shipped, in short. Unsubscribe in one click.

You are on the list. Check your inbox for the confirmation.
Read the docs