dbmate

dbmate is a lightweight database migration tool that runs as a command line program. It is framework agnostic, so it works with projects written in many languages.

dbmate keeps the database schema in sync across developers and production servers. You create migration files, run them up or down and check their status. A status command shows which migrations have been applied, and a migration lock can serialize concurrent runs so two deployments do not collide.

• Single command line tool
• Works with any language or framework
• Status command for applied migrations
• Migration lock for concurrent runs
• Plain SQL migration files

Backend developers who want simple migrations without adopting a framework. Small teams that prefer plain SQL migration files may also like it.

dbmate is open source under the MIT licence and free to use. It is a standalone program, so it can run on a developer machine or in a build pipeline. Because migrations are written as SQL, you can see exactly what runs against the database.