# amacneil/dbmate

🚀 A lightweight, framework-agnostic database migration tool.

Repository: https://github.com/amacneil/dbmate
Canonical: https://ross.abutalabs.com/products/dbmate
Language: Go
License: MIT
License Family: permissive
Topics: database-migrations, golang, nodejs, python, database-schema, docker, mysql, postgresql, sqlite, migration, migrations, clickhouse, database, go, postgres, cpp, rust
Last push: 2026-08-26T17:36:49+00:00

## Health v2 (maintenance only)
Score: 99/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 99, release rhythm 99, longevity 100
- inputs: {"age_days": 3934, "days_push": 7, "days_rel": 7, "gap_med": 20, "n_releases_24m": 24}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 7185, forks 366 (observed 2026-08-28T04:09:56.463665+00:00)

## What it is
Dbmate is a lightweight, framework-agnostic database migration tool distributed as a single standalone binary. It manages timestamp-versioned SQL migrations across MySQL, PostgreSQL, SQLite, ClickHouse, and other databases, keeping schemas in sync across teams and environments.

## Use cases
- run sql database migrations from the command line
- keep database schema in sync across multiple services in different languages
- generate a schema.sql diff file for code review
- create and drop databases in development and test environments
- wait for a database to become available in docker compose setups
- roll back the last applied database migration

## When to choose
- you want plain SQL migrations without coupling to a specific language framework
- you maintain multiple services in different languages and need one consistent migration tool
- you want a single self-contained binary that works in CI and docker
- you need timestamp-versioned migrations to avoid conflicts between developers

## When to avoid
- you prefer migrations written in your application's language or ORM
- you need framework-integrated migration features like auto-generated diffs from models
- you want a GUI or SaaS dashboard for migration management

## Facets
- artifact type: cli-tool
- maturity: stable
- function: database, cli, developer-tools
- domain: databases, developer-tools, backend
- platform: windows, cli, go
- tags: database-migrations, sql-migrations, schema-management, framework-agnostic, postgresql, mysql, sqlite, clickhouse, devops, linux, macos, docker

## Member repositories
- amacneil/dbmate (main) score 99

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:09:56.463665+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-29T17:39:54.791046+00:00, confidence not recorded.
  - readme: https://github.com/amacneil/dbmate (fetched 2026-08-28T04:09:56.463665+00:00, sha 06cca9e40425)
- Data as of 2026-08-30T08:39:29.467469+00:00.