Supabase Index Trigger Reviewer

Review Postgres indexes, triggers, write amplification, and performance risk in Supabase migrations. Use for slow queries, missing indexes, trigger-heavy designs, stale propagation issues, and DB-side performance tuning.

conectlens Updated 18 repo stars
Product tour: Discover, Lenses, Workflows, Agents, Lensers, LenserBoard

File contents

Supabase Index Trigger Reviewer

Use when

  • query performance is poor
  • triggers are complex or fragile
  • migration changes may increase write cost or contention

Workflow

  1. Identify likely read/write hotspots.
  2. Review index coverage and trigger side effects.
  3. Return exact indexing or trigger simplification recommendations.
  4. Run 'npx supabase migration up --local' to ensure the created migrations applied successfully.

Load only when needed

  • Index and trigger review guide
  • Performance checklist

conectlens/lenserfight commit c943cba9e9

Frequently asked questions

npx get-skill add conectlens/supabase-index-trigger-reviewer