postgresql-optimization
Installation
Summary
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
SKILL.md
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);