Does it support transaction safety?

The skill reviews transaction scopes to ensure they are atomic and correctly ordered to prevent deadlocks and inconsistent data states.

Can it help with slow SQL queries?

Yes, it identifies queries that trigger full table scans, suggests missing composite indexes, and flags inefficient patterns like SELECT * or leading wildcards.

How does this skill prevent production downtime?

It analyzes migrations for high-risk operations like long-running table locks and missing 'Online DDL' parameters, suggesting safer alternatives for large-scale data.

Does it handle data privacy concerns?

Yes, it includes checks for PII protection, encrypted data at rest, and the implementation of soft deletes and audit trails for compliance.

Database Code Reviewer

Name: Database Code Reviewer
Author: xinbenlv

byxinbenlv

数据库管理

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.

主要功能

0 GitHub stars
Data Integrity & Constraint Verification
Migration Safety & Rollback Validation
Query Performance & Index Optimization
Transaction Boundary & Deadlock Analysis
PII Compliance & Audit Trail Checking

使用场景

Ensuring atomic operations across multiple database models to maintain consistency.
Optimizing application repository code to resolve N+1 query issues and missing indexes.
Pre-deployment review of complex SQL migrations to prevent table locks.

关于

主要功能

0 GitHub stars
Data Integrity & Constraint Verification
Migration Safety & Rollback Validation
Query Performance & Index Optimization
Transaction Boundary & Deadlock Analysis
PII Compliance & Audit Trail Checking

使用场景

Ensuring atomic operations across multiple database models to maintain consistency.
Optimizing application repository code to resolve N+1 query issues and missing indexes.
Pre-deployment review of complex SQL migrations to prevent table locks.