- Home
- Database Migration Tools
- node-pg-migrate
On the recordRead 11 Oct 202625 facts
node-pg-migrate
On the record
- Automatic rollback
- Reversible operations can infer down migrations when a migration omits a down function.salsita.github.io · read 4 Oct 2026
- Database requirement
- The project documents PostgreSQL 14 or higher as a precondition; lower versions may work but are not officially supported.salsita.github.io · read 4 Oct 2026
- Database scope
- The project says it targets PostgreSQL and has also been tested with CockroachDB.github.com · read 11 Oct 2026
- Dependency
- The getting-started guide says to install the pg library if it is not already present.salsita.github.io · read 11 Oct 2026
- Deployment safeguards
- Pending migrations run in one transaction under an advisory lock, and an order check rejects out-of-sequence migrations.salsita.github.io · read 4 Oct 2026
- Distribution
- The project is released under the MIT License.github.com · read 11 Oct 2026
- Dry runs
- The CLI's up --dry-run prints the SQL without applying it and runs in a read-only transaction.salsita.github.io · read 4 Oct 2026
- Dry-run safety
- Dry runs use a read-only database transaction and apply none of the migration SQL.salsita.github.io · read 11 Oct 2026
- Execution
- Migrations can be run from the command line or through the programmatic runner API.salsita.github.io · read 11 Oct 2026
- Generated SQL
- The tool can print the SQL a real run would execute with the --dry-run option.salsita.github.io · read 11 Oct 2026
- Installation
- The package can be installed with npm, pnpm, yarn, or bun and adds a runnable file to node_modules/.bin.salsita.github.io · read 4 Oct 2026
- Interfaces
- Migrations can be run with CLI commands or through the programmatic runner API.salsita.github.io · read 4 Oct 2026
- License
- The project is released under the MIT License.salsita.github.io · read 4 Oct 2026
- Limit
- The project says it only targets PostgreSQL, rather than supporting multiple database systems.salsita.github.io · read 11 Oct 2026
- Maker
- The repository lists Salsita Software among the project's former maintainers.github.com · read 4 Oct 2026
- Maker background
- Salsita says it was founded in Prague in 2010 and lists its headquarters in Prague, Czechia.salsita.ai · read 4 Oct 2026
- Migration languages
- Migrations can be written in JavaScript, TypeScript, or SQL.salsita.github.io · read 11 Oct 2026
- PostgreSQL coverage
- The pgm API includes operations for database objects such as tables, indexes, functions, triggers, policies, roles, and extensions.salsita.github.io · read 11 Oct 2026
