Proposal: SlowQL static analysis of migration scripts - insights and recommendations

Hi Supabase team, I hope you're doing well. I ran a static analysis of all your migration scripts (supabase/migrations/*.sql) using SlowQL an offline SQL analyzer I maintain with 282 rules covering security, reliability, quality, performance, cost, and compliance. This is not a list of bugs or a criticism of your code. These are insights and observations. Many of the patterns flagged are likely intentional given Supabase’s architecture, RLS requirements, migration strategies, and specific workflows. I’ve tried to surface things that might be worth reviewing or could be improved in the long term, but context is everything. <img width="3432" height="4013" alt="Image" src=" /> Summary of the analysis: • 40 migration files scanned • 34 files with issues (6 clean) • 317 total issues across 32 unique rules The most common category is Quality (226 issues), followed by Reliability (53). There are also 31 critical + high sev…