Database Migration Workflow

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

tools/atlas/schemas/*.hcl

tools/sqlc/queries/*.sql

Workflow

1. Modify Schema (HCL)

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 --profile mysql 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