Postgresql

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 provides comprehensive PostgreSQL database design guidance covering data types, indexing strategies, constraints, partitioning, and schema design patterns. It includes detailed recommendations for handling JSONB, time-series data, update-heavy tables, and safe schema evolution practices.

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.

A comprehensive PostgreSQL database design guide that covers data types, indexing strategies, constraints, partitioning, JSONB usage, and performance optimization patterns. Includes AI agent definitions for database architecture and SQL expertise to help design scalable, maintainable database schemas.

This skill provides detailed PostgreSQL performance optimization guidelines and best practices from Supabase. It covers query performance, connection pooling, Row-Level Security, schema design, and more with concrete SQL examples showing incorrect vs correct patterns.

A comprehensive reference skill for Supabase development covering the CLI workflow, database migrations, Row Level Security (RLS) policies, Edge Functions, and Storage configuration. It promotes local-first development with migrations in version control and includes CI/CD templates for automated deployment.

A comprehensive reference guide for AWS Aurora database development. Covers connection strategies (RDS Proxy, Data API, direct connections), serverless v2 configuration, Prisma ORM integration, connection pooling, migrations, monitoring, and security best practices including IAM authentication.

This skill should be used when user asks to "query Supabase", "list Supabase tables", "get Supabase schema", "search Supabase records", "check Supabase database", "Supabase auth", "Supabase authentication", "RLS policy", "row level security", "Supabase foreign key", "table relationships", "Supabase join", "Supabase filter", "Supabase pagination", or needs guidance on Supabase database patterns, auth flows, RLS policies, or query best practices.