Database Schema & Query Review Gate

A bad query is a slow afternoon; a wrong table design or a migration that locks prod can hold your data and your users hostage. This gate reviews schema, queries, and migrations for what actually bites in production and returns a clear ship decision.

It runs an engine-aware review (Postgres, MySQL, SQLite, SQL Server):

• Schema design — right types, primary/foreign keys, constraints that enforce invariants, sensible normalization

• Indexing — missing indexes on FKs and WHERE/JOIN/ORDER BY columns, composite order, over-indexing, engine-appropriate index types

• Queries — N+1 patterns, SELECT *, full scans, functions on indexed columns, OFFSET pagination, and more

• Security — SQL injection (string-built queries) and least privilege

• Migration safety — destructive/irreversible ops, table-locking rewrites on big tables, backfill and rollback plans

You get a PASS / REVIEW / BLOCK verdict with prioritized fixes, and it points you to EXPLAIN ANALYZE to confirm performance rather than guessing. It's a static review — it defers to your engine's docs and doesn't replace running it on real data.