# pressly/goose

A database migration tool. Supports SQL migrations and Go functions.

Repository: https://github.com/pressly/goose
Canonical: https://ross.abutalabs.com/products/pressly-goose
Homepage: http://pressly.github.io/goose/
Language: Go
License: NOASSERTION
License Family: other
Topics: database, sql, migration, schema, postgres, mysql, sqlite, golang, go, migrations, database-migrations, postgresql
Last push: 2026-08-22T00:23:03+00:00

## Health v2 (maintenance only)
Score: 93/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 98, release rhythm 82, longevity 100
- inputs: {"age_days": 3842, "days_push": 12, "days_rel": 42, "gap_med": 39, "n_releases_24m": 14}
- flags: no_license
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 11366, forks 692 (observed 2026-08-28T04:10:46.860171+00:00)

## What it is
goose is a database migration tool available both as a CLI binary and a Go library. It manages schema changes through incremental SQL files or Go migration functions across many databases including Postgres, MySQL, SQLite, ClickHouse, and MSSQL.

## Use cases
- run database schema migrations for postgres
- manage incremental sql migration files
- write go function-based database migrations
- seed data and track migration status
- embed migrations in a go application
- migrate sqlite, mysql, and clickhouse schemas from one tool

## When to choose
- you need a battle-tested migration tool for go projects
- you want both sql and programmatic go migrations
- you need broad database driver support including clickhouse and ydb

## When to avoid
- you need declarative or state-based schema management rather than versioned migrations
- your stack is not go-based and you prefer framework-native migration tooling

## Facets
- artifact type: cli-tool
- maturity: stable
- function: database, cli, developer-tools
- domain: databases, developer-tools, backend
- platform: go, cli, cross-platform, windows
- tags: database-migrations, schema-management, sql, postgres, mysql, sqlite, clickhouse, embedded-migrations, linux, macos

## Member repositories
- pressly/goose (main) score 93

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:10:46.860171+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:15:41.799659+00:00, confidence not recorded.
  - readme: https://github.com/pressly/goose (fetched 2026-08-28T04:10:46.860171+00:00, sha d6568ac5b2bd)
  - homepage: http://pressly.github.io/goose/ (fetched 2026-08-29T08:14:27.134852+00:00, sha 6beadc86e9ee)
- Data as of 2026-08-30T08:39:29.467469+00:00.