postgres-migrations
SKILL.md
What I do
- Summarize steps for creating .up.sql/.down.sql migrations, using golang-migrate
- Provide guidance for keeping sqlc queries (queries.sql) in sync with DB state
- Highlight test patterns for migrations to avoid accidental destructive changes
When to use me
Use when growing/changing your schema or when generating new go types with sqlc. Ensures teamwide discipline and repeatability in DB evolution.
Example Usage
Reference when editing files in backend/internal/db/migrations/ and regenerating code with sqlc after migration deployment.