메뉴
Database schema and migration workflow. Use when modifying database schemas in tools/atlas/ or SQLC queries in tools/sqlc/.
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
SOC 직업 분류 기준
Set up docs-ssot SSOT documentation structure — migrate existing docs, build, and validate
Documentation update workflow. Use when modifying files in docs/ directory or any markdown files (*.md).
Maps GitHub labels to Skills and Context documents. Use when creating issues (github-issue-creation) or working on issues (fix-issue command).
How to run watch, keygen, and sign wallet CLI commands. Use when executing wallet commands or testing wallet functionality.
Git branch management, commit conventions, and PR creation workflow. Use for all tasks that require code changes, regardless of language or scope.
Solidity smart contract development workflow. Use when modifying smart contracts in apps/eth-contracts/contracts/.
| name | db-migration |
| description | Database schema and migration workflow. Use when modifying database schemas in tools/atlas/ or SQLC queries in tools/sqlc/. |
Workflow for database schema and migration changes.
git-workflow Skill for branch, commit, and PR workflow..claude/rules/hcl.md for HCL schema rules (SSOT)..claude/rules/sql.md for SQL query rules (SSOT).| Path | Description |
|---|---|
tools/atlas/schemas/{db_dialect}/*.hcl | HCL schema definitions (source of truth) |
tools/sqlc/queries/{db_dialect}/*.sql | SQLC query definitions |
Edit HCL files in tools/atlas/schemas/{db_dialect}/.
Dialect directories:
tools/atlas/schemas/postgres/*.hcltools/atlas/schemas/mysql/*.hclmake atlas-fmt && make atlas-lint
Run all three targets after modifying HCL schemas:
# Regenerate migrations, extract SQLC schemas, and generate Go code for PostgreSQL
make regenerate-all-from-atlas
# Regenerate for MySQL
make regenerate-all-from-atlas-mysql
# Convert PostgreSQL schemas to SQLite and generate Go code for SQLite
make regenerate-all-from-atlas-sqlite
Each target handles: Atlas migrations → Docker DB reset → SQLC schema extraction → SQLC code generation.
After running the regenerate targets, confirm each DB dialect has exactly one migration SQL file:
tools/atlas/migrations/postgres/{db-name}/*.sql ← one file, updatedtools/atlas/migrations/mysql/{db-name}/*.sql ← one file, updatedDB names: keygen, sign, watch
make check-build && make go-test
make regenerate-all-from-atlas succeeds (postgres)make regenerate-all-from-atlas-mysql succeeds (mysql)make regenerate-all-from-atlas-sqlite succeeds (sqlite)tools/atlas/migrations/{postgres,mysql}/{db-name}/ has exactly one .sql file and it is updated.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