Which PostgreSQL versions are supported by this skill?

This skill is specifically optimized for PostgreSQL 16 and above to leverage modern performance features.

How does it handle sequential scans?

It identifies high-cost sequential scans through EXPLAIN analysis and recommends specific index types or query rewrites to resolve them.

Does it provide advice on server configuration?

Yes, the skill can suggest tuning parameters like shared_buffers and work_mem based on your specific performance metrics and hardware.

Are there any required extensions for this skill to work?

Yes, for full diagnostic capabilities including query history and statistics, the pg_stat_statements extension should be enabled.

Can this skill help with specialized data types like JSONB?

Yes, it includes patterns for advanced indexing such as GIN indexes with jsonb_path_ops for optimizing document-based queries.

PostgreSQL Performance Optimizer

Name: PostgreSQL Performance Optimizer
Author: pluginagentmarketplace

bypluginagentmarketplace

•

データベース管理

Optimizes PostgreSQL database performance through automated query analysis, advanced indexing strategies, and database configuration tuning.

概要

The PostgreSQL Performance skill equips Claude with specialized expertise to diagnose and resolve complex database bottlenecks. It provides a systematic approach to interpreting EXPLAIN ANALYZE outputs, implementing high-performance indexing patterns like GIN and BRIN, and identifying system-level issues such as table bloat and cold caches. By leveraging diagnostic queries and industry-standard metrics, this skill helps developers reduce query latency and ensure production environments are running at peak efficiency.

主な機能

Real-time diagnostic queries for slow logs and unused indexes
Strategic index selection for B-tree, GIN, and BRIN types
Automated table bloat detection and maintenance planning
Deep query plan analysis using EXPLAIN (ANALYZE, BUFFERS)
Database configuration tuning based on buffer hit and planning metrics
1 GitHub stars

ユースケース

Troubleshooting slow-running production queries to reduce execution time
Optimizing storage and search for JSONB and time-series data sets
Implementing proactive database maintenance and index cleanup

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add pluginagentmarketplace/custom-plugin-postgresql postgresql-performance

For use in Claude.ai and ChatGPT

Download Skill

GitHub

概要