Postgresql

This skill provides comprehensive guidance for designing PostgreSQL database schemas. It covers data type selection, indexing strategies, partitioning approaches, constraints, and performance patterns for various workload types including insert-heavy, update-heavy, and upsert scenarios.

A comprehensive reference guide for SQL query optimization that covers EXPLAIN plan analysis, indexing strategies, pagination optimization, and common performance anti-patterns. The skill provides practical SQL examples for PostgreSQL and MySQL to help developers identify and fix slow queries.

A comprehensive reference guide for working with Supabase databases. Provides documentation on authentication flows (signup, signin, OAuth), Row Level Security policy patterns, table relationships and foreign keys, and query patterns including filtering, pagination, and performance optimization.