Pgschema
lastmod 2025-09-22created 2025-09-221 edits
Terraform-style declarative Postgres schema migration tool
About
- A CLI tool for managing Postgres database schemas declaratively, like Terraform
- A four-step workflow: dump → edit → plan → apply the schema
- You can transparently preview the SQL to be executed before migrating, allowing reliable application of changes
- Unlike existing ORM-based migration tools, it comprehensively supports Postgres-specific features, and its schema-level comparison is also useful in multi-tenant environments
- Compatible with Postgres 14, 15, 16, and 17