Skip to content

strictsql

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

strictsql is a PostgreSQL schema compiler, a CLI that turns a declarative TOML schema into DDL, migrations, diagrams, docs, and type-safe client code. It is for teams who keep their schema in version control and want every generated artifact and every database to stay in step with it: each schema revision has a content hash that every artifact carries, and migrations form a chain that is checked before and after it is applied. It also audits the schema for normal forms. strictsql is written in Go, and its source mirror is at github.com/stricttools/strictsql.

Go cli 0.27.1

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

No published install command yet; the source is on the repository.

Package names
  • Gostricttools.com/strictsql
  • PyPIpgdesign
  • npmpgdesign

More tools

testisolation

Go

Uncompromising test isolation for Go: your tests structurally cannot touch your real files, secrets, or git identity.

testuniverse

Go

Declared test spaces for the rules a project enforces. Early skeleton: not usable yet.

tinymoon

JavaScript, Go

tinymoon is a zero-dependency vanilla JS and CSS UI framework that ships an app shell, widgets and typography as native ES modules with no build step, plus a conformance checker CLI that enforces its rules.