| name | db-migration |
|---|---|
| description | Database schema and migration workflow. Use when modifying database schemas in tools/atlas/ or SQLC queries in tools/sqlc/. |
Database Migration Workflow
Workflow for database schema and migration changes.
Prerequisites
- Use
git-workflowSkill for branch, commit, and PR workflow. - Refer to
.claude/rules/hcl.mdfor HCL schema rules (SSOT). - Refer to
.claude/rules/sql.mdfor SQL query rules (SSOT).
Applicable Files
| Path | Description |
|---|---|
tools/atlas/schemas/*.hcl |
HCL schema definitions (source of truth) |
tools/sqlc/queries/*.sql |
SQLC query definitions |
Workflow
1. Modify Schema (HCL)
Edit HCL files in tools/atlas/schemas/.
2. Verify HCL (from rules/hcl.md)
make atlas-fmt && make atlas-lint
3. Generate Migrations
make atlas-dev-reset
4. Test Migration
docker compose down -v && docker compose up -d
5. Regenerate SQLC (from rules/sql.md)
make extract-sqlc-schema-all && make sqlc
6. Verify Go Code
make check-build && make gotest
Self-Review Checklist
- [ ] HCL format/lint passes
- [ ] Migration applies cleanly
- [ ] SQLC generates correctly
- [ ] Go build passes
Related
.claude/rules/hcl.md- HCL rules (SSOT).claude/rules/sql.md- SQL rules (SSOT)go-development- Go verification after SQLC generationgit-workflow- Branch, commit, PR workflow