Reviews database migrations, query performance, and transaction logic to ensure data integrity and prevent production downtime.
The Database Code Reviewer skill acts as a virtual Database Reliability Engineer within Claude Code, focusing on the critical and often risky area of data persistence. It provides structured analysis of schema migrations, identifying potential table-locking operations and missing rollback strategies before they reach production. Beyond migrations, it evaluates query efficiency, index usage, and transaction boundaries to prevent deadlocks and data corruption, while also ensuring compliance with PII protection standards and data retention policies.
主な機能
010 GitHub stars
02Data Integrity & Constraint Verification
03Migration Safety & Rollback Validation
04Query Performance & Index Optimization
05Transaction Boundary & Deadlock Analysis
06PII Compliance & Audit Trail Checking
ユースケース
01Ensuring atomic operations across multiple database models to maintain consistency.
02Optimizing application repository code to resolve N+1 query issues and missing indexes.
03Pre-deployment review of complex SQL migrations to prevent table locks.
