Download
goose is a database migration tool. Manage your database schema by creating incremental SQL changes or Go functions. Starting with v3.0.0 this project adds Go module support, but maintains backwards compatibility with older v2.x.y tags. Goose supports embedding SQL migrations, which means you'll need go1.16 and up. If using go1.15 or lower, then pin v3.0.1. We use timestamped migrations by default but recommend a hybrid approach of using timestamps in the development process and sequential versions in production. Supports missing (out-of-order) migrations with the -allow-missing flag, or if using as a library supply the functional option goose.WithAllowMissing() to Up, UpTo or UpByOne. Supports applying ad-hoc migrations without tracking them in the schema table. Useful for seeding a database after migrations have been applied. Use -no-versioning flag or the functional option goose.WithNoVersioning().
Features
- No config files
- Default goose binary can migrate SQL files only
- We don't go build Go migrations functions on-the-fly from within the goose binary
- goose pkg doesn't register any SQL drivers anymore
- Run complex migrations with your own *sql.DB connection
- Create your own custom goose binary
Project Samples
