pg-differ

pg-differ is a Node.js migration tool for PostgreSQL that compares database schemas (tables and sequences) against a metadata definition and generates SQL migration scripts. It supports updating columns without data loss, synchronizing indexes/constraints, and auto-generating schemas from existing database objects. The current stable version is 3.5.1, with releases following semantic versioning. Ships TypeScript types. Requires Node >=10.4.0. Key differentiator: declarative schema definition rather than imperative migration steps, offering both a CLI and programmatic API for safe, reversible database migrations.