v1.0.0
Reviews SQL and database design for correctness and performance — indexing strategy, query patterns, normalization, and migration safety. Bad queries and missing indexes are invisible until production traffic exposes them as outages.
A review skill for SQL queries, schema design, and database migrations.
Run this on any PR that touches SQL migrations, ORM models, or raw queries. Critical before deploying schema changes to production databases with significant data volume.
Add database indexes for columns used in WHERE, JOIN, and ORDER BY clauses. Without indexes, the database scans every row in the table for every query — a table with 1M rows takes seconds instead of milliseconds.
Never use SELECT * in production code. SELECT * fetches every column including large text/blob fields you don't need, wastes bandwidth, breaks when columns are added, and prevents the database from using covering indexes.
BeforeMerge scans your pull requests against all 5 Database Review rules automatically. Get actionable feedback before code ships.