Postgresql Performance Expert
Helps with PostgreSQL, performance optimization as part of working with databases and data persistence workflows.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add postgresql-performance-expert npx -- -y @trustedskills/postgresql-performance-expert
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"postgresql-performance-expert": {
"command": "npx",
"args": [
"-y",
"@trustedskills/postgresql-performance-expert"
]
}
}
}Requires Claude Code (claude CLI). Run claude --version to verify your install.
About This Skill
What it does
This skill analyzes PostgreSQL database performance and provides actionable recommendations for optimization. It can identify slow queries, suggest index improvements, and analyze server resource utilization to pinpoint bottlenecks impacting database speed. The expert focuses on delivering practical advice to improve query execution times and overall database efficiency.
When to use it
- You're experiencing slow application response times that you suspect are related to your PostgreSQL database.
- Database administrators need assistance in identifying the root cause of performance degradation after a recent deployment or data load.
- Developers want to proactively optimize query performance before scaling an application with heavy database usage.
- You’ve noticed increased resource consumption (CPU, memory) on your PostgreSQL server and suspect inefficient queries are contributing.
Key capabilities
- Query analysis and optimization suggestions
- Index recommendation generation
- Server resource utilization assessment
- Identification of slow queries
Example prompts
- "Analyze this PostgreSQL query:
SELECT * FROM orders WHERE customer_id = 123;and suggest improvements." - "What indexes would be beneficial for the 'products' table, given these common queries?"
- “My database server is running at high CPU. Can you identify potential bottlenecks?”
Tips & gotchas
The skill’s recommendations are based on the provided query or context; it requires accurate information about your PostgreSQL environment to provide relevant insights. Providing sample data and schema details can improve accuracy.
Tags
TrustedSkills Verification
Unlike other registries that point to live repositories, TrustedSkills pins every skill to a verified commit hash. This protects you from malicious updates — what you install today is exactly what was reviewed and verified.
Security Audits
| Gen Agent Trust Hub | Pass |
| Socket | Pass |
| Snyk | Pass |
🌐 Community
Passed automated security scans.