Skip to content
Kitbay
Submit

supabase-postgres-best-practices

MITUpdated on Nov 10, 20263,040GitHub stars

An agent skill from Supabase with rules for writing and reviewing Postgres, both on Supabase and elsewhere.

What the skill teaches

An agent skill from Supabase with rules for writing and reviewing Postgres, both on Supabase and elsewhere. The agent loads it before schema, migration, SQL, index, RLS policy, trigger or function work and when diagnosing slow queries, locking, connection exhaustion or bloat. The rules sit in reference files grouped into eight areas ordered by impact, from query performance, connections and security down to advanced features, and each rule pairs a wrong and a corrected SQL example. It is installed with the skills CLI or as a Claude Code plugin from the supabase/agent-skills repository.

Capabilities

  • Guide schema design and column type choices
  • Review queries and suggest missing or partial indexes
  • Advise on connection pooling and locking
  • Check row-level security policies