db-migration

📁 hiromaily/go-crypto-wallet 📅 1 day ago
0
总安装量
1
周安装量
安装命令
npx skills add https://github.com/hiromaily/go-crypto-wallet --skill db-migration

Agent 安装分布

amp 1
opencode 1
kimi-cli 1
codex 1
github-copilot 1
gemini-cli 1

Skill 文档

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

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