Sql

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.

A comprehensive reference guide for ClickHouse database development. Provides SQL patterns for table design (MergeTree engines), query optimization techniques, data insertion patterns, materialized views, and common analytics queries including time series analysis, funnel analysis, and cohort analysis.

A comprehensive reference guide for dbt (data build tool) analytics engineering. It covers model organization using the medallion architecture (staging, intermediate, marts layers), testing strategies, documentation practices, incremental model patterns, and common dbt commands. Ideal for data engineers building transformation pipelines.

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.