node-pg-migrate
The facts below are what the maker publishes about node-pg-migrate, checked and dated. Our editors have not written about it yet.
The facts
Each one read from node-pg-migrate's own pages, with the date it was checked.
What it does
- Automatic rollback
- Reversible operations can infer down migrations when a migration omits a down function.checked 4 Oct 2026
- Database requirement
- The project documents PostgreSQL 14 or higher as a precondition; lower versions may work but are not officially supported.checked 4 Oct 2026
- Database scope
- The project says it targets PostgreSQL and has also been tested with CockroachDB.checked 11 Oct 2026
- Dependency
- The getting-started guide says to install the pg library if it is not already present.checked 11 Oct 2026
- Deployment safeguards
- Pending migrations run in one transaction under an advisory lock, and an order check rejects out-of-sequence migrations.checked 4 Oct 2026
- Distribution
- The project is released under the MIT License.checked 11 Oct 2026
- Dry runs
- The CLI's up --dry-run prints the SQL without applying it and runs in a read-only transaction.checked 4 Oct 2026
- Dry-run safety
- Dry runs use a read-only database transaction and apply none of the migration SQL.checked 11 Oct 2026
- Execution
- Migrations can be run from the command line or through the programmatic runner API.checked 11 Oct 2026
- Generated SQL
- The tool can print the SQL a real run would execute with the --dry-run option.checked 11 Oct 2026
- Installation
- The package can be installed with npm, pnpm, yarn, or bun and adds a runnable file to node_modules/.bin.checked 4 Oct 2026
- Interfaces
- Migrations can be run with CLI commands or through the programmatic runner API.checked 4 Oct 2026
- License
- The project is released under the MIT License.checked 4 Oct 2026
- Limit
- The project says it only targets PostgreSQL, rather than supporting multiple database systems.checked 11 Oct 2026
- Migration languages
- Migrations can be written in JavaScript, TypeScript, or SQL.checked 11 Oct 2026
- PostgreSQL coverage
- The pgm API includes operations for database objects such as tables, indexes, functions, triggers, policies, roles, and extensions.checked 11 Oct 2026
- PostgreSQL operations
- The pgm API includes operations for tables, indexes, functions, triggers, policies, roles, extensions, grants, and other PostgreSQL objects.checked 4 Oct 2026
- Purpose
- node-pg-migrate manages database migrations for PostgreSQL from Node.js.checked 11 Oct 2026
- Requirements
- The documented prerequisites are Node.js 22.12.0 or higher and PostgreSQL 14 or higher; lower PostgreSQL versions are not officially supported.checked 11 Oct 2026
- Rollback
- Reversible operations can have their down migrations inferred when a migration omits down.checked 11 Oct 2026
- Runtime requirement
- The project documents Node.js 22 or higher as a precondition.checked 4 Oct 2026
- Support and contributions
- The repository welcomes contributors, and the documentation links to troubleshooting guidance.checked 11 Oct 2026
The company
- Maker
- The repository lists Salsita Software among the project's former maintainers.checked 4 Oct 2026
- Maker background
- Salsita says it was founded in Prague in 2010 and lists its headquarters in Prague, Czechia.checked 4 Oct 2026
Alternatives to node-pg-migrate
- 1
Atlas
Free planOpen sourceWebAPILinuxmacOS8.3From $39 a month - 2
DeepFilterNet
Free planOpen sourceAPILinuxmacOSSelf-hosted7.6Free plan - 3
pgroll
Free planOpen sourceLinuxmacOSSelf-hostedWindows7.3Free plan - 4
Skeema
Free planLinuxmacOSWindows6.9From $649 a year - 5
Bytebase Enterprise
Free planWebAPISelf-hosted6.8From $20 a month - 6
Sqitch
Free planLinuxmacOSSelf-hostedWindows6.7Free plan