Can it help with database maintenance?

Absolutely. It provides commands for managing table bloat, scheduling VACUUM and ANALYZE operations, and monitoring autovacuum health.

What configuration settings does it optimize?

It covers critical PostgreSQL settings including shared_buffers, effective_cache_size, work_mem, and parallel worker settings tailored to your server's RAM.

Does it support connection pooling configuration?

Yes, it includes ready-to-use patterns for PgBouncer (transaction mode) and application-level pooling using libraries like pg-pool for Node.js.

How does this skill help identify slow queries?

The skill provides Claude with specific templates for EXPLAIN ANALYZE and pg_stat_statements to find long-running queries and interpret execution plans for bottlenecks like Seq Scans.

Postgres Performance Optimizer

Name: Postgres Performance Optimizer
Author: bradtaylorsf

bybradtaylorsf

•

Database Management

Optimizes PostgreSQL database performance through deep query analysis, indexing strategies, and expert server configuration tuning.

The Postgres Performance skill empowers Claude with specialized knowledge to diagnose and resolve PostgreSQL bottlenecks. It provides standardized patterns for interpreting EXPLAIN ANALYZE plans, implementing high-efficiency pagination, managing connection pooling with PgBouncer, and fine-tuning critical server parameters like shared buffers and work memory. This skill is essential for developers looking to eliminate slow queries, manage table bloat, and scale database infrastructure effectively by applying proven industry best practices directly within their workflow.

Key Features

01Automated maintenance workflows for VACUUM, ANALYZE, and bloat management

02Connection pooling configurations for PgBouncer and pg-pool

036 GitHub stars

04Advanced query plan analysis using EXPLAIN ANALYZE patterns

05High-performance keyset and cursor-based pagination strategies

06System-level tuning for memory, checkpoints, and parallel query execution

Use Cases

01Optimizing large-scale data inserts using batch operations and COPY commands

02Identifying and refactoring slow-running SQL queries using execution plans

03Configuring database memory and worker settings for specific hardware profiles

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add bradtaylorsf/alphaagent-team postgres-performance

For use in Claude.ai and ChatGPT

Download Skill