Can this skill assist with database scaling?

Absolutely. It covers range-based table partitioning for datasets over 10 million rows and provides configuration templates for connection poolers like PgBouncer.

How does this skill help with slow SQL queries?

It provides specialized guidance on using EXPLAIN ANALYZE to identify sequential scans, missing indexes, and memory-intensive sorts, offering specific SQL remedies for each bottleneck.

Does it provide advice on avoiding production downtime?

Yes, it emphasizes the use of CONCURRENTLY for index creation and identifies anti-patterns like running VACUUM FULL during peak hours to prevent table locking.

Does it support advanced indexing for JSONB?

Yes, the skill includes patterns for GIN indexing on JSONB columns to accelerate containment queries and nested field lookups.

PostgreSQL Optimization

Name: PostgreSQL Optimization
Author: rohitg00

byrohitg00

•

604

•

Database Management

Optimizes PostgreSQL database performance through advanced indexing, query plan analysis, partitioning, and connection pooling strategies.

This Claude Code skill provides developers with a comprehensive framework for fine-tuning PostgreSQL databases to achieve high performance and scalability. It offers expert guidance on implementing sophisticated indexing strategies—including GIN, GiST, and partial indexes—alongside deep-dive query plan analysis using EXPLAIN ANALYZE. Whether you are managing multi-million row tables through partitioning, optimizing JSONB operations for semi-structured data, or configuring PgBouncer for efficient connection pooling, this skill helps identify bottlenecks and implement production-ready database architectural patterns.

Key Features

01JSONB performance tuning and efficient nested field operations

02Deep Query Plan Analysis with EXPLAIN ANALYZE and buffer monitoring

03604 GitHub stars

04Table Partitioning strategies for datasets exceeding 10M rows

05Connection pooling configuration for high-concurrency environments

06Advanced Indexing (B-tree, Composite, Partial, Covering, GIN, and GiST)

Use Cases

01Diagnosing and resolving slow-running SQL queries in production environments

02Optimizing semi-structured data storage and retrieval using JSONB best practices

03Scaling database architecture for high-growth applications through partitioning

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add rohitg00/awesome-claude-code-toolkit postgres-optimization

For use in Claude.ai and ChatGPT

Download Skill