db-migration

Database Migration Workflow

Workflow for database schema and migration changes.

Prerequisites

• Use git-workflow Skill for branch, commit, and PR workflow.
• Refer to .claude/rules/hcl.md for HCL schema rules (SSOT).
• Refer to .claude/rules/sql.md for SQL query rules (SSOT).

Applicable Files

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 generation
• git-workflow - Branch, commit, PR workflow