Goose

What Goose is

Goose is a database migration tool for managing schema changes through incremental SQL files and Go migration functions. It is available as both a command-line utility and a library, with Linux, macOS, Windows, API, and self-hosted options listed. The CLI can apply, roll back, redo, reset, inspect, and version migrations. SQL migration files use an up annotation and may have a down annotation; filenames can use timestamps or sequential numbers. Statements in a migration file run in one transaction by default, though an annotation can place them outside one. Go migration functions can run within a SQL transaction when given a transaction argument. Listed CLI drivers include ClickHouse, Microsoft SQL Server, MySQL, PostgreSQL, SQLite, Turso, Vertica, and YDB. Other listed capabilities include embedded and out-of-order migrations, data seeding, and environment variable substitution in SQL migrations. The library provider accepts a dialect, database connection, migration filesystem, and optional configuration. By default, it does not lock the database during migrations, so callers must coordinate safe runs or configure a session locker. Goose is MIT-licensed and free.