skills.rest
vm-wylbur
vm-wylburCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

postgres-optimization

Analyze PostgreSQL databases with postgres-mcp tools to recommend indexes.

1|Updated Dec 17, 2016
Search Tags:#performance#indexing#database#postgresql#optimization#data management#query tuning
One-click install
npx skills add https://github.com/vm-wylbur/pb-dotfiles --skill postgres-optimization
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgres-optimization
Source: https://github.com/vm-wylbur/pb-dotfiles/tree/main/ai/claude-code/skills/postgres-optimization
Command: npx skills add https://github.com/vm-wylbur/pb-dotfiles --skill postgres-optimization

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Manually optimizing PostgreSQL databases is complex, time-consuming, and often requires deep expertise. Slow queries and inefficient indexing can severely impact application performance and user experience. This skill automates the process, combining past learnings with live analysis.

Core Features & Use Cases

  • Memory-Augmented Research: Leverages past optimization successes and failures from institutional memory to inform current strategies, preventing repeated mistakes.
  • Live Database Analysis: Uses postgres-mcp tools to perform comprehensive health checks, identify slow queries, analyze execution plans, and recommend optimal indexes.
  • Intelligent Synthesis & Recommendation: Combines historical knowledge with real-time database data to propose actionable, verified optimization strategies, complete with expected performance impacts.
  • Use Case: When a user reports "My query to find users by email is very slow", the skill will search past optimizations, analyze the current database health and query plan, recommend a specific index, test its impact hypothetically, and, upon approval, execute and document the change.

Quick Start

Optimize my PostgreSQL database for slow queries. The skill will analyze your database, suggest improvements, and ask for approval before making changes.

Frequently Asked Questions about postgres-optimization

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I optimize slow PostgreSQL queries?▼

Query optimization involves analyzing execution plans, identifying missing indexes, and restructuring queries for efficiency. This skill analyzes your database health, recommends specific indexes based on past optimization patterns, and tests changes before applying them to measurably improve query performance.

What's the best way to identify and fix PostgreSQL performance bottlenecks?▼

Performance bottlenecks stem from slow queries and inefficient indexing. This skill performs live database analysis to detect slow queries, examines execution plans, suggests optimal indexes informed by historical optimization successes, and documents changes with expected performance impact.

Can I automate PostgreSQL database indexing and tuning?▼

Yes. This skill automates indexing and query tuning by combining institutional memory of past optimizations with real-time database analysis, eliminating manual expertise requirements and preventing repeated mistakes across similar performance problems.

Do I need deep PostgreSQL expertise to optimize my database?▼

No. This skill handles the technical complexity by synthesizing historical optimization knowledge with live database data to propose verified strategies, requiring only approval before execution rather than expert-level database administration.

What limitations should I know about database query optimization?▼

Optimization depends on accurate problem diagnosis and realistic performance expectations. This skill mitigates risks by testing recommendations before application and documenting changes, but results vary based on schema design, data volume, and workload patterns.

Related Skills

Explore More Data & Analytics Skills→
DexploarerDexploarer
6

database-query-optimizer

Analyze EXPLAIN plans and recommend indexes for PostgreSQL, MySQL, and MongoDB.

Community
Advanced
sunchenddsunchendd
3

supabase-postgres-best-practices

Apply PostgreSQL best practices to optimize queries, schemas, and configuration.

Community
Advanced
adiytharpansaadiytharpansa

database-operator

Manage queries, schemas, and performance across SQL and NoSQL databases.

Community
Intermediate
UdaradgUdaradg

sql-optimization

Optimize slow SQL queries across MySQL, PostgreSQL, SQL Server, and Oracle.

Community
Intermediate