dbmate

dbmate is a free, open-source command-line tool for managing database migrations. It is best suited to teams that want plain SQL and a language-independent workflow. Its broad database coverage and rollback support are useful strengths, but schema dumps bring extra setup and a Spanner-specific constraint.

Overview

Dbmate uses timestamp-versioned SQL files for migrations, avoiding the need for developers to coordinate manually assigned version numbers. As a standalone CLI, it can sit alongside applications written in Go, Node.js, Python, Ruby, PHP, Rust, C++, or other languages and frameworks. That makes it a practical fit for mixed-language teams that prefer SQL over application-language migration code.

The command set covers creating, applying, and rolling back migrations, checking status, dumping or loading a schema, and waiting for a database server. Migrations run atomically in a transaction by default when the database supports transactions; individual migration blocks can opt out. That provides a sensible default while leaving room for migrations that need different transaction behavior.

Key features

Database coverage and schema snapshots

The documented database list includes MySQL, MariaDB, PostgreSQL, SQLite, and ClickHouse, with BigQuery connections and Spanner databases using the PostgreSQL dialect also documented. Dbmate can maintain a schema.sql snapshot for review and diffing in Git, which gives teams a way to see schema changes alongside code. Dumps depend on database client tools such as pg_dump, mysqldump, or sqlite3, so this feature requires setup beyond dbmate itself. Spanner schema dumps are not supported because pg_dump relies on functions Spanner does not provide.

Configuration and distribution

Dbmate 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 published to GitHub Container Registry. Go projects can also use dbmate as a library and embed migrations in an application binary with Go embed; that option is specific to Go rather than a general embedding path for every supported language.

Pricing

Dbmate is open source under the MIT license. Its dbmate plan costs nothing and includes the open-source database migration tool; there is no paid SaaS upsell. The free plan is therefore the complete stated offering rather than a trial or a capped entry tier, with no paid upgrade path described.

Platforms

Dbmate is listed for Linux, macOS, Windows, and self-hosted use. Its documented installation routes include packages, a Linux binary, and Docker images, making it possible to fit the tool into varied development and deployment environments.

Who it's for

Dbmate suits teams that want SQL migrations shared across developers and production servers without choosing a migration framework tied to one application language. It is especially relevant where rollback commands, transaction defaults, and Git-reviewed schema snapshots are useful parts of the workflow. Teams whose process depends on automated Spanner schema dumps should look elsewhere, and any team using schema dumps should account for the required database client tools.

Pros and cons

• Pros: Plain SQL and timestamp-versioned files suit collaborative, language-mixed projects without manual version numbering.
• Pros: Rollback, status checks, and transaction-by-default behavior cover important parts of migration operations.
• Pros: A maintained schema snapshot can be diffed in Git, making changes easier to review alongside code.
• Cons: Schema dumping requires external database client tools, adding dependencies to that workflow.
• Cons: Spanner schema dumps are unsupported, limiting the snapshot workflow for those databases.
• Cons: The project does not state a support service or response time, which may matter to teams needing a defined support commitment.

Alternatives

Compare dbmate with other Database Migration Tools if you are weighing different migration approaches. Choose Skeema if its free Community plan's tables, stored procedures and functions, and 18 linter checks better match a schema-management workflow; its Plus plan is $124 a month. Consider Atlas if you want an open-core tool with a free plan and trial, or FluentMigrator if an Apache-2.0 licensed framework distributed through NuGet is a better fit.

golang-migrate is another free migration tool with no paid plans or usage limits stated on its project pages. Goose is also a free, open-source database migration tool. Choose pgroll if PostgreSQL 14.0 or later and a single cross-platform binary suit your requirements, or Refinery if its MIT-licensed SQL toolkit and selectable database-driver features fit better. Bytebase Enterprise is worth considering if you need its stated Community allowance of up to 20 users and 10 database instances, or want a paid Pro plan billed per user at $20 a month.

Verdict

Choose dbmate if you want a free, language-independent CLI for plain SQL migrations, with rollback and a Git-friendly schema snapshot workflow. Its clearest strengths are flexible language fit and broad database coverage. Look elsewhere if Spanner schema dumps are essential, or if you need a defined support service rather than a self-managed open-source tool.