db-migration
Database schema and migration workflow. Use when modifying database schemas in tools/atlas/ or SQLC queries in tools/sqlc/.
Installation
Follow the repository instructions for this skill and your agent. Review the files and dependencies before adding it to your workflow.
View source ↗GuidesSkill instructions
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 generation -
git-workflow- Branch, commit, PR workflow
Examples
Read the usage examples in the source repository.
View source ↗Source history
- Indexed on
- 2026-01-20
- Index updated
- 2026-01-28
- Branch
- main
Index and sync dates describe this directory. View the source repository for code history.
GitHub ↗chat Comments (0)
Sign in to join the discussion and leave a comment.
No comments yet. Be the first to share your thoughts!