supabase-audit

w3bsuki 的头像作者 w3bsuki

Supabase RLS/性能审计。触发于“SUPABASE:”前缀。

📖 中文导读:Supabase RLS/性能审计。触发于“SUPABASE:”前缀。 以下正文为该技能的原始 SKILL.md 内容(英文),上方安装命令可直接使用。

name: supabase-audit description: Supabase RLS/perf audit. Triggers on "SUPABASE:" prefix.

Supabase Audit Skill

On "SUPABASE:" Prompt

  1. Run security advisors: mcp_supabase_get_advisors({ type: "security" })
  2. Run performance advisors: mcp_supabase_get_advisors({ type: "performance" })
  3. List tables and check for missing RLS
  4. Check for select('*') in lib/data/*.ts
  5. Output findings in Phase 1 Audit format

MCP Commands

mcp_supabase_get_advisors({ type: "security" })
mcp_supabase_get_advisors({ type: "performance" })
mcp_supabase_list_tables({ schemas: ["public"] })
mcp_supabase_list_extensions()
mcp_supabase_list_migrations()
mcp_supabase_execute_sql({ query: "SELECT tablename FROM pg_tables WHERE schemaname='public'" })

Anti-Patterns to Flag

  • Tables without RLS policies
  • select('*') in hot paths
  • Missing indexes on foreign keys
  • Secrets in client-accessible queries
  • Wide joins without field projection

Output Format

## Supabase Lane Phase 1 Audit — {date}

### Critical (blocks Phase 2)
- [ ] Issue → Table/File → Fix

### High (do in Phase 2)
- [ ] Issue → Table/File → Fix

### Deferred (Phase 3 or backlog)
- [ ] Issue → Table/File → Fix

When to Run Advisors

Per CODEX decision: Run on any task touching:

  • supabase/ directory
  • lib/supabase/** files
  • SQL/migrations
  • Query shapes in lib/data/

Day 0 always runs security advisors.

Gates

After any fix:

pnpm -s exec tsc -p tsconfig.json --noEmit
REUSE_EXISTING_SERVER=true pnpm test:e2e:smoke

Docs

Topic File
Backend guide docs/guides/backend.md
Engineering docs/ENGINEERING.md
Supabase patterns lib/supabase/