Skip to content
SPECIFICTION
Get listed

dbmate vs node-pg-migrate

dbmate

github.com

node-pg-migrate

salsita.github.io

Side by side

Figuredbmatenode-pg-migrate
Price fromFree—
Free planYes—
Free trial——
Open source——
WindowsYes—
macOSYes—
LinuxYes—
API—Yes
Self-hostedYesYes
Plans published10
Spec score · Database Migration Tools8.6 (#3)7.3 (#25)
DistributionThe README documents installation through NPM, Homebrew, Scoop, a Linux binary, and Docker images published to GitHub Container Registry.The project is released under the MIT License.
LicenseThe repository includes an MIT license.The project is released under the MIT License.
LimitThe README says Spanner schema dumps are not supported because pg_dump uses functions Spanner does not provide.The project says it only targets PostgreSQL, rather than supporting multiple database systems.
PurposeDbmate is a database migration tool that keeps database schemas in sync across developers and production servers.node-pg-migrate manages database migrations for PostgreSQL from Node.js.

Plans

dbmate

  • dbmateFree

dbmate pricing →

node-pg-migrate

No plans published.

node-pg-migrate pricing →

In their own words

dbmate

dbmate is a free, open-source command-line tool for keeping database schemas in sync across developers and production servers. It works independently of application language and can be used with Go, Node.js, Python, Ruby, PHP, Rust, C++, and other languages or frameworks. Migrations are plain SQL in timestamp-versioned files. Commands create, apply, and roll back migrations, check status, dump or load a schema, and wait for a database server. The project lists MySQL, MariaDB, PostgreSQL, SQLite, and ClickHouse, and documents BigQuery connections and Spanner support for databases using the PostgreSQL dialect. Migrations run atomically in a transaction by default when the database supports transactions, though individual migration blocks can opt out. dbmate can maintain a schema.sql dump for source-control review and Git diffs; creating dumps relies on database client tools such as pg_dump, mysqldump, or sqlite3. It reads DATABASE_URL by default and can load environment variables from a .env file. Installation options include NPM, Homebrew, Scoop, a Linux binary, and Docker images. Go applications can use it as a library, and Go embed can package migrations into an application binary.

Visit github.com

node-pg-migrate

node-pg-migrate has no write-up on Specifiction yet; its figures are above.

Visit salsita.github.io