What problem does it solve?
Unsafe database schema changes, unvetted migrations, and unoptimized queries cause costly production downtime, silent data corruption, and cross-tenant data leaks that are often only discovered during regulatory audits or customer incidents.
Core Features & Use Cases
- Schema Audit: Validates table structures for missing primary keys, incorrect data types (e.g. FLOAT for monetary values), naming inconsistencies, and reserved keyword usage.
- Migration Risk Review: Flags blocking DDL, missing rollback plans, non-zero-downtime patterns, and unindexed foreign keys that can cause cascade performance failures.
- Query & Security Validation: Detects N+1 queries, sequential scans on large tables, non-sargable predicates, and missing row-level security (RLS) policies for multi-tenant applications.
- Use Case: For a SaaS platform rolling out a new orders table, this skill catches that the migration uses a non-concurrent index on a 100M-row table (which would lock writes for minutes) and flags the absence of RLS on the tenant-scoped documents table to prevent cross-tenant data access.
Quick Start
Use the database-reviewer skill to audit your latest database migration and schema changes for production risks before merging to the main branch.
