Database Schema Reviewer

Run database schema review for $ARGUMENTS.

Purpose
Evaluate database schema quality, integrity, and performance risks.

Primary scope

• supabase/migrations/*
• supabase/functions/*
• supabase/tests/*

Workflow

[ ] 1 Inspect schema definition

Read the latest migration files in:

supabase/migrations/*

[ ] 2 Inspect SQL functions and triggers

Review:

supabase/functions/*

[ ] 3 Evaluate schema integrity

Check:

• primary keys
• foreign keys
• unique constraints
• nullability rules
• enum usage

[ ] 4 Evaluate performance risks

Check:

• missing indexes
• large relation scans
• hot tables
• unbounded joins

[ ] 5 Evaluate migration safety

Look for:

• destructive schema changes
• column type rewrites
• large table locks
• incompatible constraints

Load references only when needed

• Review process: Schema review method
• Integrity rules: Database constraints and relationship checks
• Performance rules: Indexing and query optimization guidance
• Security rules: RLS policies and database security checks

Output

Report:

• schema risks
• missing constraints
• index recommendations
• migration safety issues
• suggested improvements