dbmate review
A focused open-source CLI for versioned SQL migrations, rollback, and schema.sql maintenance.
Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026
dbmate is an open-source, standalone command-line tool for keeping database schemas synchronized across developers and production servers. It is designed for teams that want application-independent migrations in plain SQL rather than a framework-specific system. Migrations use timestamped files with explicit up and down sections, while database connections are handled through database URLs. The tool runs on Windows, macOS, and Linux and is distributed as a self-contained binary or Docker image.
Its strongest fit is database portability. dbmate supports MySQL, MariaDB, PostgreSQL, SQLite, and ClickHouse, along with BigQuery and PostgreSQL-dialect Spanner connections. That range gives teams a consistent migration workflow across different database environments. Beyond applying migrations, the CLI provides status, wait, create, drop, dump, and load commands. It also exports and maintains a complete schema.sql file, which gives teams a separate representation of the current schema alongside the migration history. Choose dbmate when SQL files, broad connectivity, and a framework-agnostic workflow matter more than a graphical interface or language-specific integration.
The migration model covers the core operational path: create and run timestamp-versioned migrations, define rollback steps, and execute migrations atomically inside transactions when the connected database supports them. Its open-source model keeps the product focused on the command line rather than dividing capabilities across paid tiers. Teams should consider an alternative if they need a visual migration workflow, features beyond SQL-based files, or transaction behavior that does not depend on database support. For developers and operations teams comfortable with CLI tooling, dbmate is a focused choice for portable schema changes and explicit rollback management.
dbmate pros and cons
- Where it wins
- Timestamped SQL migrations with explicit up and down sections
- Rollback and atomic transactions when supported by the database
- Supports major databases plus BigQuery and Spanner connections
- Where it doesn't
- Command-line workflow may not suit teams seeking a visual interface
- Atomic transactions depend on database support
- No AI features are included
dbmate fact sheet, pricing and score →
Advertiser disclosure: iTechGuides is reader-supported. Vendors can pay for top positions in our rankings and for a place on other products' pages, and we may earn a commission when you click some links. Bought places stand at the number bought; this page and our disclosure say so. Paying vendors may get a fuller, more detailed review from our editors, and that review can change their score. How we rank.
Last updated · How we research and update