# 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.

- Skill: `conectlens/supabase-index-trigger-reviewer` (Agent Skill, multi-file: 4 files)
- Install (CLI): `npx skillmds@latest add conectlens/supabase-index-trigger-reviewer`
- Raw SKILL.md: https://api.skillmd.com/api/skills/conectlens/supabase-index-trigger-reviewer/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: conectlens (https://skillmd.com/u/conectlens)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/conectlens/supabase-index-trigger-reviewer

---


# 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](references/REFERENCE.md)
- [Performance checklist](assets/db-perf-checklist.md)