supabase-postgres-tuning

Rewrites and reviews Postgres schemas, queries and settings for Supabase projects, applying 26 performance and safety rules: indexing (composite, partial, covering, GIN/BRIN/hash), keyset pagination, upserts, batch loads, connection pooling and limits, RLS policies and privileges, locking and queue patterns, EXPLAIN ANALYZE and pg_stat_statements diagnostics. Use when the user asks to "speed up a slow Postgres query", "review my schema or migrations", "write an RLS policy", "fix N+1 queries", or "configure pooling for Supabase". Not for MySQL or SQLite dialects, for general application code outside the database layer, or for Supabase Auth/Storage dashboard setup.

Version

v1.0.0

Size

22 KB

Updated

2026-10-03

Your client verifies the signature before reading. This explicit manual read is available on every plan. Free automatically loads five chosen skills; paid plans automatically load relevant skills across the library.