postgresql-optimization

SKILL.md

Expert guidance on PostgreSQL-specific features, optimization patterns, and advanced data type capabilities.

Covers JSONB operations, array types, window functions, full-text search, custom types, range types, and geometric types with practical examples

Includes query optimization strategies using EXPLAIN ANALYZE, index design patterns (composite, partial, covering, expression), and connection/memory management

Provides monitoring and maintenance techniques via pg_stat_statements, pg_stat_user_indexes, and database size analysis

Demonstrates common anti-patterns alongside optimized alternatives for pagination, aggregation, and JSON queries with expected performance improvements

PostgreSQL Development Assistant

Expert PostgreSQL guidance for ${selection} (or entire project if no selection). Focus on PostgreSQL-specific features, optimization patterns, and advanced capabilities.

� PostgreSQL-Specific Features

JSONB Operations

-- Advanced JSONB queries
CREATE TABLE events (
    id SERIAL PRIMARY KEY,
    data JSONB NOT NULL,
    created_at TIMESTAMPTZ DEFAULT NOW()
);

-- GIN index for JSONB performance
CREATE INDEX idx_events_data_gin ON events USING gin(data);