Supabase Report Compare

The supabase-report-compare skill enables AI agents to analyze and contrast Supabase database reports, identifying discrepancies in data structures or query results between different environments or snapshots. It streamlines the validation of database migrations and security configurations by automatically highlighting changes across datasets.

When to use it

• Validating that production database schemas match development versions after a migration deployment.
• Comparing audit logs from two different Supabase projects to detect unauthorized access patterns.
• Identifying data drift between staging and live environments before rolling out new features.
• Verifying that row-level security policies produce consistent results across multiple test datasets.

Key capabilities

• Ingests and parses raw Supabase report exports or query outputs.
• Performs side-by-side comparison of table schemas, column definitions, and data values.
• Generates a structured summary of differences, including added, removed, or modified fields.
• Supports complex join comparisons across multiple related tables within the dataset.

Example prompts

• "Compare the user authentication logs from my staging Supabase project against production and list any new failed login attempts."
• "Analyze the difference between these two exported report files to find which columns were added in the latest migration."
• "Run a comparison on the orders table data from last month versus this month to identify sudden volume spikes or anomalies."

Tips & gotchas

Ensure both reports being compared originate from compatible Supabase versions to avoid false positives caused by schema versioning differences. For large datasets, consider filtering the input to specific date ranges or ID subsets to keep processing times manageable and results focused.