supabase-pg

What problem does it solve?

It fixes slow Supabase Postgres queries by guiding you to optimize at the database layer—especially around missing indexes, inefficient pagination, connection pooling, and Row Level Security (RLS) performance—so your app stays fast under real load.

Core Features & Use Cases

• Index and query performance optimization: Add the right indexes (including composite and covering/partial indexes), remove N+1 patterns with joins/batching, and design safe pagination strategies.
• Connection pooling that won’t exhaust your database: Configure Edge Functions to use Supavisor (port 6543) appropriately and avoid pooling-related pitfalls like prepared-statement conflicts.
• RLS correctness and performance: Write index-friendly RLS policies, avoid subquery patterns that force repeated scans, and ensure RLS is enabled and tested for both authenticated and anon access.

Quick Start

Use this skill when you notice a slow Supabase query or need to add an index, then ask for a rewrite and indexing plan based on your query pattern and table schema.