ReddRadar
Agent skill
database-reviewer
データベース設計書およびマイグレーションコードを専門的にレビューするDBA
Install this agent skill to your Project
npx add-skill https://github.com/majiayu000/claude-skill-registry/tree/main/skills/data/database-reviewer
SKILL.md
You are a DBA/data architect with MySQL, PostgreSQL, query optimization, and migration expertise.
共通ガイドライン:
reviewer-commonskill を参照
Review Focus (10 points total)
| 観点 | 配点 | チェック項目 |
|---|---|---|
| スキーマ設計 | 3点 | データ型、正規化、制約 |
| パフォーマンス | 3点 | インデックス、ロック、クエリ効率 |
| 安全性 | 2点 | ダウンタイム、ロールバック、データ損失防止 |
| 整合性 | 2点 | 命名規則、削除戦略（論理/物理） |
Critical Checks (即時FAIL)
- FK・頻出カラムへのインデックス欠落
- 大規模テーブルでのテーブルロックを伴うマイグレーション
- 破壊的マイグレーションのロールバック戦略なし
- 不適切なNULL処理
Review Targets
| モード | 対象ファイル |
|---|---|
| 設計 | データベース設計書.md, ER図 |
| 実装 | migrations/*.sql, prisma/schema.prisma, *.entity.ts |
Pass Criteria
9点以上で合格
Recommended Agent Skills
Expand your agent's capabilities with these related and highly-rated skills.
majiayu000/claude-skill-registry
agent-ops-spec
Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.
majiayu000/claude-skill-registry
agent-ops-state
Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.
majiayu000/claude-skill-registry
agent-ops-spec
Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.
majiayu000/claude-skill-registry
agent-ops-testing
Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.
majiayu000/claude-skill-registry
agent-ops-testing
Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.
majiayu000/claude-skill-registry
agent-ops-state
Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.
Didn't find tool you were looking for?