goose

goose [options] command

goose is a database migration tool that supports both SQL and Go migrations. It manages database schema changes by versioning migration files and tracking which migrations have been applied.
The tool supports PostgreSQL, MySQL, SQLite, SQL Server, and other databases, providing a consistent interface for schema migrations.

up

Migrate up

Migrate up by one version

Migrate down

Migrate down to specific version

Show migration status

Create new migration (sql or go)

Apply sequential ordering to migrations

Print goose version

Migrations directory (default: migrations)

Migrations table name (default: goosedbversion)

Allow missing migrations

Display version and exit

Display help and exit

Supported databases:
- PostgreSQL
- MySQL/MariaDB
- SQLite3
- SQL Server
- ClickHouse
- Redshift
- TiDB
- Turso

Requires database connection. Migration files must follow naming conventions. Down migrations should be tested carefully. Concurrent migrations may need locking.

goose was created as a language-agnostic migration tool supporting both SQL and Go-based migrations, filling the gap for Go developers needing database migrations.

[migrate](https://github.com/golang-migrate/migrate), [dbmate](https://github.com/amacneil/dbmate), [flyway](https://flywaydb.org/), [liquibase](https://www.liquibase.org/)