Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

Goose

pressly.github.io

  • Free plan
  • Windows
  • macOS
  • Linux
  • API
  • Self-hosted
7.6 Club score Visit pressly.github.io

What Goose is

Goose is a free, open-source database migration tool for managing schema changes with incremental SQL and Go migration functions. It is available as both a command-line utility and a library. The CLI can apply, roll back, redo, reset, inspect, and version migrations. SQL migration files use an up annotation and may include an optional down annotation; filenames can use timestamps or sequential numbers. Statements in a migration file run in one transaction by default, though an annotation can run them outside a transaction. Go migration functions can run in a SQL transaction when given a transaction argument. The CLI lists drivers for ClickHouse, Microsoft SQL Server, MySQL, PostgreSQL, SQLite, Turso, Vertica, and YDB. The project also lists embedded and out-of-order migrations, data seeding, and environment variable substitution in SQL migrations. For library use, a provider takes a database dialect, connection, migration filesystem, and optional configuration. The provider does not lock the database during migrations by default, so callers must arrange safe concurrent runs or configure a session locker. Using the provider also requires matching the SQL dialect to the database driver.

Who it suits

Goose suits developers who want to manage database schema changes through SQL files, Go functions, or both. It can also fit projects that need library-based migration configuration or self-hosted use.

Good to know, and what to watch

  • CLI can apply, roll back, redo, reset, inspect, and version migrations.
  • Supports SQL migrations and Go migration functions.
  • Lists drivers for eight databases.
  • Can use directory or embedded migration files.
  • The provider does not lock migrations by default.
  • Callers must match the dialect to the database driver.
  • ClickHouse support has deployment-mode limitations.

Goose

Free

Open source

Getting started

  1. Visit the Goose project website
  2. Install or build the CLI, using Go 1.16 or later when building from source
  3. Choose a supported database driver and matching SQL dialect
  4. Create migration files with up and optional down annotations
  5. Configure the Goose provider with a connection and migration filesystem
  6. Run the CLI to apply or inspect migrations

Limits to check

The provider does not lock the database during migrations by default, so safe concurrent execution must be coordinated or configured with a session locker. ClickHouse support is limited to some deployment modes and may require additional configuration or workarounds.

The Club's review

Goose is an open-source database migration tool for teams evolving schemas with incremental SQL or Go code. It suits developers who want both a scriptable CLI and an embeddable library, especially when they need rollback and inspection commands. The trade-off is operational: applications using the provider must coordinate concurrent runs and align dialect and driver settings themselves.

Overview

Goose manages ordered database changes through SQL migration files and Go migration functions. You can operate it as a command-line utility or integrate its provider with an application’s connection and filesystem abstractions. That combination makes it a practical choice for engineering teams that want migration behavior under their own control rather than a hosted service. It is free, open source and licensed under MIT, with self-hosting supported across its deployment model.

Key features

Operational controls

The CLI can apply, roll back, redo, reset, inspect and version migrations. Rollback and redo commands are useful when recovering from a bad deployment or checking how a change behaves, while inspect and version help operators understand the migration state before acting. This is a broader runbook than a forward-only migration command, but it still expects your team to define safe deployment procedures.

SQL and Go formats

SQL files use an up annotation and can include an optional down section. Filenames may use timestamps or sequential numbers, giving teams a choice between time-based ordering and explicit sequences. Go migration functions provide a code path for changes that do not fit comfortably in SQL; when a transaction argument is supplied, those functions can execute within a SQL transaction.

Transactions and concurrency

Statements in a migration file run in one transaction by default, and an annotation can run a migration outside a transaction when the database operation requires it. The provider does not lock the database during migrations by default. Multiple deployment processes therefore need external coordination, or a configured session locker, to avoid unsafe overlapping runs. That flexibility is useful for controlled environments but is a real responsibility for teams automating migrations in CI/CD.

Drivers and integration

The documented CLI drivers cover ClickHouse, Microsoft SQL Server, MySQL, PostgreSQL, SQLite, Turso, Vertica and YDB. A Goose provider accepts the dialect, database connection, migration filesystem and optional configuration, including directory or embedded filesystems. Callers are responsible for matching the SQL dialect to the selected driver. ClickHouse support is limited to some deployment modes and may need careful configuration or workarounds, so it is not a frictionless choice for every ClickHouse setup.

The project also lists embedded migrations, out-of-order migrations, data seeding and environment-variable substitution in SQL migrations. Building from source requires Go 1.16 or later.

Pricing

Goose — free is the only plan. It is an open-source database migration tool with no paid tier, making it suitable for individual developers, startups and infrastructure teams that can operate their own migration workflow. The free offering does not come with a separate hosted service or commercial support tier in the plan information; teams choosing Goose should be prepared to own coordination, driver configuration and operational decisions.

Platforms

Goose supports API, Linux, macOS, self-hosted deployments and Windows. The API and library model fits applications that need migrations embedded in their startup or deployment code, while the CLI works for dedicated release jobs and administrator workflows. Self-hosting keeps execution in your environment, but also leaves responsibility for database access, locking strategy and CI/CD scheduling with your team.

Who it's for

Choose Goose if your team is comfortable with SQL or Go, wants a migration tool it can run in CI/CD, and values both command-line controls and library integration. It is particularly well suited to organizations supporting several database engines or embedding migration files in an application.

Look elsewhere if you need provider-level locking by default, a managed migration service, or a workflow that hides dialect and driver matching. Teams targeting ClickHouse should also confirm that their deployment mode is covered before standardizing on Goose.

Pros and cons

  • Pro: SQL and Go migrations cover declarative schema changes and code-based operations in one tool.
  • Pro: Apply, rollback, redo, reset, inspect and version commands give operators meaningful recovery and visibility options.
  • Pro: The provider accepts database and filesystem abstractions, including embedded migration files, which supports application integration.
  • Pro: The broad documented driver list makes Goose viable across common relational engines plus ClickHouse, Turso, Vertica and YDB.
  • Con: Provider migrations are not locked by default, so concurrent deployment safety requires a session locker or external coordination.
  • Con: Driver and dialect alignment is the caller’s responsibility, and ClickHouse may require deployment-specific workarounds.

Alternatives

Atlas is a better fit when you want a freemium, open-core tool with a free trial and a core engine under Apache 2.0, plus advanced proprietary features.

Bytebase Enterprise suits teams seeking a web and API platform with a free Community plan for up to 20 users and 10 database instances, alongside paid per-user options.

Skeema is worth considering for MySQL-focused workflows that need its Community feature set and optional Plus plan.

Sqitch is another free, cross-platform database change-management application.

GitHub Accessibility Scanner is a free MIT-licensed GitHub Action rather than a general migration tool.

pgroll is a free option centered on PostgreSQL 14 or later and distributed as a single cross-platform binary.

Refinery is a free MIT-licensed SQL migration toolkit whose database drivers are selected as features.

golang-migrate is a free open-source alternative with no paid plans or usage limits stated on its project pages.

Browse the Database Migration Tools list for more options.

Verdict

Goose is a strong choice for developers and platform teams that want a free, MIT-licensed migration engine with SQL and Go formats, rich CLI controls and a library they can embed. Choose it for that control and broad driver coverage; look elsewhere if your organization cannot take responsibility for concurrency coordination, dialect configuration or database-specific setup.

The verdict

Goose offers migration controls through both a CLI and a library, with SQL and Go formats. Plan for concurrency safety and verify the driver and dialect configuration for your database.

Questions people ask

How much does Goose cost?

Goose is free and open source. The listed plan is free.

Which databases are supported?

Listed CLI drivers include ClickHouse, Microsoft SQL Server, MySQL, PostgreSQL, SQLite, Turso, Vertica, and YDB.

Can migrations be rolled back?

Yes. The CLI can roll back and redo migrations, and SQL files may include a down section.

Where can it run?

Platforms listed are API, Linux, macOS, Windows, and self-hosted environments.

Does it lock the database automatically?

No. The provider does not lock the database by default; a session locker can be configured.

What the maker publishes

CLI and library
The project is both a command-line utility and a library. source
Concurrency
The provider does not lock the database during migrations by default, so callers must ensure migrations run safely; a session locker can coordinate them. source
Concurrency limitation
By default, the provider does not lock the database during migrations, so the caller must ensure migrations are run safely; a session locker can be configured. source
Database driver responsibility
When using the provider, callers are responsible for matching the SQL dialect to the database driver. source
Database support
The documented CLI drivers include ClickHouse, MSSQL, MySQL, PostgreSQL, SQLite, Turso, Vertica, and YDB. source
Driver caveat
The README warns that ClickHouse support is limited to some deployment modes and may require careful configuration or workarounds. source
Go migrations
Go migration functions can run within a SQL transaction when given a transaction argument. source
Go requirement
Building from source requires Go 1.16 or later. source
Library configuration
A Goose provider accepts a database dialect, a database connection, a filesystem for migration files, and optional configuration. source
Library integration
The Goose provider accepts a database connection and filesystem abstraction, including directory or embedded filesystems. source
License
The GitHub repository states that Goose is licensed under the MIT License. source
Migration controls
The CLI can apply, roll back, redo, reset, inspect, and version database migrations. source
Migration formats
It manages database schemas with incremental SQL changes and Go migration functions. source
Migration options
The project README lists embedded migrations, out-of-order migrations, data seeding, and environment variable substitution in SQL migrations. source
Migration transactions
Statements in a migration file run in one transaction by default, with an annotation to run them outside a transaction. source
Platforms
The installation guide documents prebuilt or source installation for macOS, Linux, and Windows. source
Purpose
Goose is a database migration tool for managing database schemas with incremental SQL changes and/or Go functions. source
SQL migration format
SQL migration files use an up annotation and may include an optional down annotation; filenames use a timestamp or sequential number. source
Supported database drivers
The CLI lists ClickHouse, Microsoft SQL Server, MySQL, PostgreSQL, SQLite, Turso, Vertica, and YDB drivers. source

Checked against the maker's pages on 7 Oct 2026.