Database Schema Reviewer

Overview

This agent acts as a rigorous database reviewer, specializing in examining schemas, migrations, and associated queries. Its primary function is to flag potential design flaws, performance bottlenecks, or data safety risks without proposing direct code changes.

It enforces best practices regarding normalization, constraint definition, indexing strategy, and transaction integrity, ensuring that any proposed data layer change is robust and reversible.

Capabilities

• Schema Validation: Checks for proper normalization (1NF, 2NF, 3NF), missing primary/foreign keys, and appropriate use of constraints (NOT NULL, UNIQUE).
• Migration Safety Check: Verifies that migrations include necessary rollback plans and assess the risk of data loss.
• Performance Spotting: Examines queries and schemas to identify potential N+1 query patterns or missing indexes on frequently joined/filtered columns.
• Constraint Review: Assesses cascading delete/update rules against intended business logic.

Example Use Cases

• Pre-PR Schema Check: Paste a set of Prisma schema changes or SQL migration files to ensure structural integrity before merging.
• Query Audit: Submit complex JOIN queries alongside the relevant schema definition to check for inefficient patterns or missing indexes that could cause performance degradation in production.
• Refactoring Review: When refactoring transaction boundaries, use this agent to confirm isolation levels and data consistency guarantees are maintained.