goose

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().