Skip to content
SPECIFICTION
Get listed

pg-schema-diff

github.com

Self-hosted
Visit github.com
Spec score 6.9 #18 of 25 in Database Schema Comparison Tools

Spec sheet

Purpose
pg-schema-diff compares Postgres schemas and generates SQL migrations to move between them with minimal downtime and locks.Read 8 Oct 2026 · github.com
Support
The contribution guide says maintainers will try to respond to bug reports, feature requests, and questions within one week.Read 8 Oct 2026 · github.com
License
The repository lists the project under the MIT license.Read 8 Oct 2026 · github.com
Applying library plans
Applications using the library are responsible for applying generated plans; the README suggests considering an advisory lock or a second approver.Read 8 Oct 2026 · github.com
Database setup
The CLI connects to Postgres using a connection string and can dump an existing database schema as a starting point.Read 8 Oct 2026 · github.com
Database versions
The project supports Postgres versions 14, 15, 16, and 17; versions 13 and older are unsupported.Read 8 Oct 2026 · github.com
Declarative migrations
It migrates a database to a desired schema defined in plain DDL.Read 8 Oct 2026 · github.com
Delivery
It is available as a command-line tool and a Go library, installable with Homebrew or the Go toolchain.Read 8 Oct 2026 · github.com
Downtime caveat
Some migrations may require downtime, and stateful online migration techniques such as shadow tables are not supported.Read 8 Oct 2026 · github.com
Hazard warnings
The tool warns operators about dangerous operations, and hazards must be approved when applying a plan.Read 8 Oct 2026 · github.com
Interfaces
The project provides a CLI and a Go library, installable through Homebrew or the Go toolchain.Read 8 Oct 2026 · github.com
Maker headquarters
Stripe lists its dual headquarters in San Francisco and Dublin.Read 8 Oct 2026 · stripe.com
Migration limits
Only enum types are supported, and renaming an object is treated as dropping it and adding a new one.Read 8 Oct 2026 · github.com
Migration safety
It warns operators about dangerous operations and validates plans against a temporary database before they are applied.Read 8 Oct 2026 · github.com
Online migrations
It uses native Postgres operations for online migrations wherever possible, including concurrent index builds.Read 8 Oct 2026 · github.com
Online operations
It uses native Postgres operations for online migrations where possible, including concurrent index builds and online index replacement.Read 8 Oct 2026 · github.com
Partitions
The project describes its partition support as strong.Read 8 Oct 2026 · github.com
Security reporting
The security policy directs vulnerability reports to Stripe’s Vulnerability Disclosure and Reward Program and asks reporters not to open public issues or pull requests.Read 8 Oct 2026 · github.com
Support status
The project describes itself as early stage and says it has limited capacity to review direct code contributions.Read 8 Oct 2026 · github.com
Supported versions
The project supports Postgres versions 14, 15, 16, and 17; versions 13 and earlier are unsupported.Read 8 Oct 2026 · github.com

Where Specifiction places it

Alternatives to pg-schema-diffAll alternatives →