node-pg-migrate review

Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026

node-pg-migrate is an open-source Node.js migration tool built primarily for PostgreSQL. It is aimed at development teams that want to define database changes in JavaScript, TypeScript, or SQL and run them from the command line or through a programmatic API. The tool generates SQL from migration operations and covers PostgreSQL schemas, tables, columns, indexes, triggers, views, and other objects. Its self-hosted, mixed-format approach suits teams that want migrations to live alongside application code and remain under their own deployment processes.

Migration control is a central strength. Teams can run up, down, and redo commands, execute migrations in transactions, and use advisory locking to prevent concurrent migration runs. Dry-run previews provide SQL visibility inside a read-only transaction before changes are applied. For reversible operations, node-pg-migrate can infer down migrations by reversing the corresponding up operations, reducing repeated definition work while keeping rollback support available. The programmatic runner API also gives applications and deployment tooling a direct integration point beyond the command line.

The main trade-off is its PostgreSQL-centered scope. The documentation discusses compatibility with other SQL-standard databases, but the product is primarily built around PostgreSQL operations, so teams managing a broad mix of database engines may prefer a tool designed around multi-database workflows. Automatic rollback inference also depends on whether an operation is reversible; teams should define explicit down migrations when needed. Choose node-pg-migrate when your stack is Node.js-based, PostgreSQL is the main database, and you want code-defined migrations with SQL previews, transactional execution, and locking. Look elsewhere if database portability across several engines is the primary requirement.

node-pg-migrate pros and cons

• Where it wins
  • Supports JavaScript, TypeScript, and SQL migration files
  • Previews SQL in a read-only transaction before execution
  • Offers transactions, advisory locking, and a programmatic API
• Where it doesn't
  • Primarily targets PostgreSQL rather than a broad database mix
  • Automatic down migrations apply only to reversible operations
  • Requires Node.js tooling and migration-file management

node-pg-migrate fact sheet, pricing and score →

Advertiser disclosure: iTechGuides is reader-supported. Vendors can pay for top positions in our rankings and for a place on other products' pages, and we may earn a commission when you click some links. Bought places stand at the number bought; this page and our disclosure say so. Paying vendors may get a fuller, more detailed review from our editors, and that review can change their score. How we rank.

Last updated 7 Oct 2026 · How we research and update