Indexing

A reference skill providing PostgreSQL best practices covering query optimization, schema design, indexing strategies, Row Level Security, and connection pooling. Based on Supabase guidelines, it serves as a quick lookup for common patterns like composite indexes, cursor pagination, and queue processing.

This skill teaches SQL optimization techniques including query execution plan analysis (EXPLAIN), indexing strategies (B-Tree, GIN, GiST, BRIN), and common optimization patterns. It covers eliminating N+1 queries, cursor-based pagination, aggregate optimization, materialized views, and table partitioning for PostgreSQL and MySQL databases.

This skill should be used when user asks to "query MongoDB", "show database collections", "get collection schema", "list MongoDB databases", "search records in MongoDB", or "check database indexes".