postgres-tuning

Official

Optimize PostgreSQL 17/18+ performance.

Authoroakoss
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill addresses slow query performance and inefficient database operations in PostgreSQL, helping you diagnose and resolve bottlenecks related to I/O, indexing, and configuration.

Core Features & Use Cases

  • Performance Tuning: Optimizes PostgreSQL 17/18+ performance across I/O, query execution, indexing, and maintenance.
  • Diagnostic Tools: Leverages advanced monitoring views like pg_stat_io and pg_stat_statements for in-depth analysis.
  • Use Case: When users report slow response times for critical application features, this Skill can analyze query plans, identify missing indexes, and suggest configuration adjustments to improve database throughput and reduce latency.

Quick Start

Use the postgres-tuning skill to analyze slow queries and suggest index optimizations.

Dependency Matrix

Required Modules

None required

Components

references

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: postgres-tuning
Download link: https://github.com/oakoss/agent-skills/archive/main.zip#postgres-tuning

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.