node-pg-migrate

At a glance

• Editor score
  6.7 / 10
• Pricing
  Open source
• Best for
  PostgreSQL JavaScript and TypeScript teams
• Paid from
  Free
• Rollback support
  Yes
• Facts checked
  20 Sep 2026

• 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

Our verdict on node-pg-migrate

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.

Your product? Our editors can test node-pg-migrate in depth and publish a review, labelled as paid · from $149/mo →

node-pg-migrate pricing

node-pg-migrate fact sheet

Alternatives to node-pg-migrate

• FlywayA broad migration platform with free core commands and deeper controls in paid editions.9.4
• AtlasAffordable schema automation with strong migration controls and CI/CD support.9.2
• LiquibaseA governed migration workflow with changelogs, rollback, drift detection, and a free tier.9.1

See all node-pg-migrate alternatives →

Featured on iTechGuides

node-pg-migrate is listed in our Database Migration Tools directory. Add the badge to your site — it links back to this page.

<a href="https://www.itechguides.com/products/node-pg-migrate/"><img src="https://www.itechguides.com/best/badge/node-pg-migrate.svg" alt="Featured on iTechGuides" width="230" height="46"></a>

Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026

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