Goose migrations

goose manages schema migrations as numbered SQL files with annotation markers. Apply them from the CLI during development and CI, or embed them in the binary so the service ships its own schema.

File structure

Migrations live in a dedicated directory (conventionally db/migrations/ or migrations/). Each file is numbered and named descriptively:

migrations/
  00001_init.sql
  00002_add_users.sql
  00003_add_status_index.sql

goose orders files lexically, so the numeric prefix must sort correctly. Pick a width and keep it consistent. Never reuse a number; goose will error on collisions.