#106106th of 204 in Backends, databases and hosting
goose
Database schema migration tool for Go, as CLI and library
- Stars
- 11.7k
- License
- custom license
- Last commit
- Nov 2026
- Last release
- Nov 2026
- Language
- Go
10,493 on 25 Apr 202611,707 on 14 Nov 2026
From GitHub's daily star counts.
Checked on GitHub.
Overview
Goose applies versioned schema changes written as SQL files or Go functions, tracking state in a migrations table (default goose_db_version). It runs as a CLI or is imported as a Go library, with commands such as up, down, redo, status, fix and validate. Drivers include Postgres, MySQL, SQLite, ClickHouse, MSSQL, Spanner, YDB and others.
Who it is for: Go and backend developers managing database schema migrations
Strengths
- Supports SQL and Go migrations, plus migrations embedded in the binary via go:embed
- Many drivers: Postgres, MySQL, SQLite, Spanner, MSSQL, ClickHouse, YDB, Redshift, TiDB
- Build tags (e.g. no_postgres) strip unused drivers for a smaller binary
- Out-of-order migrations, env var substitution in SQL, and a fix command for sequential numbering
Weaknesses
- Go migrations require building your own goose binary; the stock CLI runs SQL only
- Container image has no shell and supports .sql migrations only
- ClickHouse is only fully supported in some deployment modes
- MySQL needs parseTime and multiStatements enabled for status and multi-statement files
What it needs
- no GPU
- Docker
- Needs A supported database (Postgres, MySQL, SQLite, etc.)
What changed
From the release notes. No flag means the note does not say so, not that the upgrade is safe.
Known problems
Reported, then fixed by a linked change
- Latest vulnerability scan fails with High and Critical Go vulnerabilities for stdlib, crypto and net ↗ (opens in a new tab)5 reactions · closed 11 Oct 2026Fixed by chore: update Go dependencies ↗ (opens in a new tab)
- goose validate fails to parse inlined functions ↗ (opens in a new tab)0 reactions · closed 22 Oct 2026Fixed by fix: allow inlined migration functions in goose validate ↗ (opens in a new tab)
- Type of the 'tstamp' field in the 'goose_db_version' table (Y2K38) ↗ (opens in a new tab)0 reactions · closed 2 Sept 2026Fixed by fix: use DATETIME instead of TIMESTAMP for MySQL/TiDB tstamp column (Y2K38) ↗ (opens in a new tab)
- Creating two migrations at the same time ↗ (opens in a new tab)0 reactions · closed 2 Sept 2026Fixed by fix: return clear error when migration file already exists ↗ (opens in a new tab)
Titles are the reporters' own words, taken from the project's GitHub issues and ranked by reactions. We have not tried to reproduce any of them.
Also in Backends, databases and hosting
See all 204| Rank | Project | Score |
|---|---|---|
| 1 | bunJavaScript and TypeScript runtime with bundler, test runner and package manager | 94 out of 100 |
| 2 | coolifySelf-hosted Heroku and Vercel alternative that deploys apps and databases over SSH | 93 out of 100 |
| 3 | strapiHeadless CMS that generates REST and GraphQL APIs from content models | 92 out of 100 |
| #4 | traefikHTTP reverse proxy and load balancer that auto-discovers routes from orchestrators | 92 out of 100 |
| #5 | appwriteBackend with auth, databases, storage, functions and an MCP server for agents | 92 out of 100 |