Skip to content
SPECIFICTION
Get listed

dbmate vs gh-ost

dbmate

github.com

gh-ost

github.com

Side by side

Figuredbmategh-ost
Price fromFree—
Free planYes—
Free trial——
Open source——
WindowsYes—
macOSYesYes
LinuxYesYes
Self-hostedYes—
Plans published10
Spec score · Database Migration Tools8.6 (#3)5.8 (#32)

Plans

dbmate

  • dbmateFree

dbmate pricing →

gh-ost

No plans published.

gh-ost 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

gh-ost

gh-ost has no write-up on Specifiction yet; its figures are above.

Visit github.com