Documentation

pgmold is a PostgreSQL schema-as-code tool. Define schemas in native SQL, diff against live databases, and apply migrations safely.

# See what would change
pgmold plan -s sql:schema.sql -d postgres://localhost/mydb

# Apply the migration
pgmold apply -s sql:schema.sql -d postgres://localhost/mydb

Get started

Installation Install pgmold via Cargo

Quick Start Up and running in 60 seconds

Guides

Multi-File Schemas Organize schema across directories

Filtering Include/exclude by name or type

Adopting pgmold Baseline an existing database

CI/CD Integration GitHub Action and drift detection

Drizzle ORM Use Drizzle schemas as source

Safety Rules Destructive operation guardrails

Reference

CLI Commands All commands and flags

Terraform Provider Schema management in HCL

GitHub Action drift-check action reference