How does this skill help with slow PostgreSQL queries?

The skill performs deep diagnostics using EXPLAIN (ANALYZE, BUFFERS), looking at cost model internals and buffer usage to suggest specific indexing or configuration changes based on real workload data.

Does it handle high-scale JSONB data?

Yes, it provides specialized guidance on JSONB at scale, including TOAST storage implications, update semantics, and GIN index tuning to prevent performance degradation.

Can I use this for production maintenance emergencies?

Absolutely. It includes workflows for transaction wraparound prevention, bloat remediation, and autovacuum tuning, always including the trade-offs and risks involved in each operation.

What PostgreSQL versions are supported?

The skill explicitly provides version requirements for every feature recommendation (e.g., PG 12+, PG 14+) to ensure compatibility and leverage modern features like parallel query or declarative partitioning.

PostgreSQL Expert

Name: PostgreSQL Expert
Author: tundraray

bytundraray

•

Database Management

Optimizes PostgreSQL performance, designs scalable architectures, and troubleshoots complex database internals with production-grade precision.

The PostgreSQL Expert skill transforms Claude into a principal database engineer specialized in managing high-stakes PostgreSQL clusters ranging from 100GB to 50TB+. It provides high-fidelity guidance on deep query plan analysis, JSONB scaling, partitioning strategies, and high-availability replication. Every recommendation is built for production stability, providing specific version requirements, failure modes, and concrete trade-offs to ensure that database optimizations improve performance without introducing regression or downtime.

Key Features

01Advanced partitioning strategies using declarative methods and pg_partman

02Deep query plan analysis using EXPLAIN (ANALYZE, BUFFERS, SETTINGS)

03Scalable JSONB implementation including TOAST and GIN index tuning

04Database maintenance tuning for VACUUM, bloat remediation, and transaction isolation

051 GitHub stars

06Architecture design for streaming and logical replication failover

Use Cases

01Hardening database security through Row-Level Security (RLS) and SCRAM-SHA-256

02Designing and implementing multi-terabyte partitioning schemes for historical data

03Optimizing slow queries and resolving lock contention in high-traffic production databases

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add tundraray/overture postgres-expert

For use in Claude.ai and ChatGPT

Download Skill