dbmate

dbmate is a free, open-source command-line tool for managing SQL migrations across development and production databases. It best suits teams that want a language-independent workflow and direct control over migration SQL. Its main trade-off is that schema dumps depend on external database clients, and Spanner dumps are unsupported.

Overview

Dbmate keeps schema changes in timestamp-versioned SQL files, avoiding hand-assigned migration numbers that can collide when developers work in parallel. Because it runs as a standalone command-line tool, teams can use it with Go, Node.js, Python, Ruby, PHP, Rust, C++, or other languages and frameworks. That makes it a reasonable fit for mixed-language projects, but less compelling for teams that want migrations expressed in application code.

Its commands cover creating, applying, and rolling back migrations, checking status, dumping or loading a schema, and waiting for a database server. Migrations run in a transaction by default when the database supports transactions; individual migration blocks can opt out. This provides a useful atomic default without forcing every migration into the same transaction behavior.

Key features

Database coverage and schema tracking

Dbmate supports MySQL, MariaDB, PostgreSQL, SQLite, and ClickHouse, and documents BigQuery connections plus Spanner databases using the PostgreSQL dialect. It can maintain a schema.sql snapshot for source control, making schema changes easier to review and diff in Git. The dump workflow relies on database client tools such as pg_dump, mysqldump, or sqlite3, so teams need those installed as well as dbmate. Spanner is a particular exception: schema dumps are unsupported because pg_dump uses functions Spanner does not provide.

Configuration and deployment

Dbmate reads DATABASE_URL by default and can load environment variables from a .env file, which keeps routine connection setup straightforward. Installation options include NPM, Homebrew, Scoop, a Linux binary, and Docker images published to GitHub Container Registry. Go applications can also use dbmate as a library and embed migrations into an application binary with Go embed. These options suit teams that want to run migrations in their own environments rather than adopt a hosted service.

Pricing

Dbmate is free and open source under the MIT license. Its plan is free, with no free-trial period or paid SaaS upsell. That makes the full migration tool accessible without a seat or usage charge; the cost is operational instead, including installing any database client tools needed for schema dumps. It is a strong fit for teams comfortable maintaining their own command-line workflow, but not for buyers seeking a paid support or hosted-service plan.

Platforms

Dbmate supports Linux, macOS, Windows, and self-hosted use. Its multiple installation routes make it workable across developer machines and deployment environments, though schema-dump requirements still depend on the relevant database client being present.

Who it's for

Choose dbmate if your team prefers plain SQL, needs rollback support, and wants one migration workflow across different application languages. It is also well suited to teams that want schema snapshots under version control and are comfortable supplying database client utilities. Look elsewhere if you need Spanner schema dumps, an application-language migration framework, or a hosted service and support commitments.

Pros and cons

• Pro: Plain SQL and timestamp-versioned files give developers direct control over database changes while reducing migration-number conflicts.
• Pro: Rollback, status checks, schema loading and dumping, and database-wait commands cover more than just applying migrations.
• Pro: Transactional execution is the default where supported, with per-migration opt-outs for exceptions.
• Con: Schema dumps require external database client tools, adding setup work beyond installing dbmate.
• Con: Spanner schema dumps are not supported, limiting the snapshot workflow for those databases.
• Con: The project does not provide a stated support service or response time, so teams needing a defined support commitment should consider another option.

Alternatives

Database Migration Tools is the broader category to browse when dbmate's SQL-first workflow is not the right fit.

• Skeema is worth considering if you want a freemium option with a free Community plan for tables, stored procedures and functions, and 18 linter checks.
• Atlas is an alternative if an open-core tool with a free plan and free trial better matches your evaluation process.
• FluentMigrator may suit teams seeking an Apache-2.0 licensed framework distributed through NuGet, with provider packages selected separately.
• Goose is another free, open-source database migration tool to compare.
• pgroll is a free option if your database is PostgreSQL 14.0 or later and you want a single cross-platform binary.
• Refinery is a free, MIT-licensed SQL migration toolkit; database drivers must be selected as features.
• Doctrine Migrations is a free, open-source PHP library installed with Composer or downloaded as a PHAR.

Verdict

Dbmate is a strong choice for teams that want free, language-independent SQL migrations with rollback support and Git-friendly schema snapshots. Its focused command-line workflow keeps the tool practical across varied projects. Choose another option if Spanner dumps are essential, you do not want to manage database client utilities, or your team requires a defined support service.