How does this skill help with slow SQL queries?

It provides a framework for running EXPLAIN (ANALYZE, BUFFERS) to find the exact bottleneck, such as high disk I/O or incorrect row estimations, and suggests specific code or index fixes.

Is the advice safe for existing production systems?

The skill follows a safety-first methodology, emphasizing profiling before changing, respecting existing configuration patterns, and validating improvements on staging first.

Does it support advanced PostgreSQL index types?

Yes, it covers B-tree, GIN for JSONB/arrays, GiST for spatial data, and BRIN for large time-series datasets, ensuring you use the most efficient structure for your data.

Can I use this for server configuration tuning?

Absolutely. It includes best practices for configuring shared_buffers, work_mem, and vacuum settings based on your specific workload and hardware.

PostgreSQL Performance Tuning

Name: PostgreSQL Performance Tuning
Author: jsamuelsen11

byjsamuelsen11

0•

Database Management

Analyzes and optimizes PostgreSQL query execution and database configuration using a systematic, data-driven approach.

The PostgreSQL Performance Tuning skill enables Claude to perform deep database audits and systematic query optimization. It guides the analysis of execution plans using EXPLAIN ANALYZE, identifies common bottlenecks like disk-based sorts or sequential scans, and recommends targeted indexing strategies—including GIN, GiST, and BRIN. By prioritizing measurement and baseline comparison, it helps developers safely tune production configurations and rewrite queries for maximum efficiency while respecting existing database constraints.

Key Features

01Guidance on tuning memory parameters like shared_buffers and work_mem

020 GitHub stars

03Strategic index recommendations for B-tree, GIN, GiST, and BRIN types

04Workflows for safe production configuration changes and rollbacks

05Identification of performance 'red flags' like stale statistics and heap access

06Deep interpretation of EXPLAIN ANALYZE and BUFFERS output

Use Cases

01Designing high-performance indexing for specialized data like JSONB and spatial coordinates

02Optimizing slow-running queries by identifying missing indexes or inefficient joins

03Benchmarking database performance changes between staging and production environments

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jsamuelsen11/claude-config performance-tuning

For use in Claude.ai and ChatGPT

Download Skill