Agent skill · data analytics · erichowens
postgresql-optimization
Expert in PostgreSQL performance tuning, query optimization, and database administration. Specializes in EXPLAIN analysis, indexing strategies, connection pooling, partitioning, and production-grade
Why this skill is useful
Provides advanced PostgreSQL optimization techniques and specific query tuning strategies that the AI wouldn't reliably generate on its own.
What it needs
About 5k tokens when loaded. Last updated 2026-07-14. 180 stars on the source repository.
What this skill does
PostgreSQL Optimization Overview Expert in PostgreSQL performance tuning, query optimization, and database administration. Specializes in EXPLAIN analysis, indexing strategies, connection pooling, partitioning, and production-grade PostgreSQL operations. When to Use Diagnosing slow queries with EXPLAIN ANALYZE Creating optimal indexes for query patterns Designing database schemas for performance Configuring PostgreSQL for production workloads Implementing connection pooling (PgBouncer, Supavisor) Setting up partitioning for large tables Analyzing and reducing lock contention Migrating or upgrading PostgreSQL versions Capabilities Query Optimization EXPLAIN / EXPLAIN ANALYZE interpretation Query plan analysis and optimization Identifying sequential scans vs index scans Join optimization and query rewriting CTE vs subquery performance trade-offs Window function optimization Indexing Strategies B-tree, GIN, GiST, BRIN index selection Partial indexes for filtered queries Expression indexes for computed values Covering indexes (INCLUDE clause) Index-only scans optimization Concurrent index creation Schema Design Normalization vs denormalization trade-offs JSONB column design and indexing Array columns and operations Enum types vs lookup tables Foreign key cascade strategies Table inheritance and partitioning Configuration Tuning Memory settings (sharedbuffers, workmem, effectivecachesize) Connection limits and pooling WAL and checkpoint tuning Autovacuum configuration Statistics collection settings Advanced Features Partitioning (range, list, hash) Materialized views with refresh strategies Full-text search with tsvector/tsquery PostGIS geospatial queries Logical replication setup pgstatstatements analysis Dependencies Works well with: database-modeler - Schema design and ERD creation data-pipeline-engineer - ETL and data processing site-reliability-engineer - Database monitoring and alerting nextjs-app-router-expert - Full-stack data fetching Examples Reading EXPLAIN AN …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills erichowens/postgresql-optimization