- Home
- Database Schema Comparison Tools
- pg-schema-diff
On the recordRead 8 Oct 202620 facts
pg-schema-diff
On the record
- Applying library plans
- Applications using the library are responsible for applying generated plans; the README suggests considering an advisory lock or a second approver.github.com · read 8 Oct 2026
- Database setup
- The CLI connects to Postgres using a connection string and can dump an existing database schema as a starting point.github.com · read 8 Oct 2026
- Database versions
- The project supports Postgres versions 14, 15, 16, and 17; versions 13 and older are unsupported.github.com · read 8 Oct 2026
- Declarative migrations
- It migrates a database to a desired schema defined in plain DDL.github.com · read 8 Oct 2026
- Delivery
- It is available as a command-line tool and a Go library, installable with Homebrew or the Go toolchain.github.com · read 8 Oct 2026
- Downtime caveat
- Some migrations may require downtime, and stateful online migration techniques such as shadow tables are not supported.github.com · read 8 Oct 2026
- Hazard warnings
- The tool warns operators about dangerous operations, and hazards must be approved when applying a plan.github.com · read 8 Oct 2026
- Interfaces
- The project provides a CLI and a Go library, installable through Homebrew or the Go toolchain.github.com · read 8 Oct 2026
- License
- The repository lists the project under the MIT license.github.com · read 8 Oct 2026
- Maker headquarters
- Stripe lists its dual headquarters in San Francisco and Dublin.stripe.com · read 8 Oct 2026
- Migration limits
- Only enum types are supported, and renaming an object is treated as dropping it and adding a new one.github.com · read 8 Oct 2026
- Migration safety
- It warns operators about dangerous operations and validates plans against a temporary database before they are applied.github.com · read 8 Oct 2026
- Online migrations
- It uses native Postgres operations for online migrations wherever possible, including concurrent index builds.github.com · read 8 Oct 2026
- Online operations
- It uses native Postgres operations for online migrations where possible, including concurrent index builds and online index replacement.github.com · read 8 Oct 2026
- Partitions
- The project describes its partition support as strong.github.com · read 8 Oct 2026
- Purpose
- pg-schema-diff compares Postgres schemas and generates SQL migrations to move between them with minimal downtime and locks.github.com · read 8 Oct 2026
- 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.github.com · read 8 Oct 2026
- Support
- The contribution guide says maintainers will try to respond to bug reports, feature requests, and questions within one week.github.com · read 8 Oct 2026
