Postgres Expert
Troubleshoot complex Postgres queries, optimize performance, and design schemas with expert guidance from cin12211's Postgres-Expert.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add postgres-expert npx -- -y @trustedskills/postgres-expert
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"postgres-expert": {
"command": "npx",
"args": [
"-y",
"@trustedskills/postgres-expert"
]
}
}
}Requires Claude Code (claude CLI). Run claude --version to verify your install.
About This Skill
What it does
This skill provides expert-level capabilities for interacting with and managing PostgreSQL databases. It can generate complex SQL queries, analyze database schemas, optimize query performance, and troubleshoot common database issues. The agent leverages its knowledge to provide accurate and efficient solutions related to PostgreSQL administration and development.
When to use it
- You need to write a complex SQL query that joins multiple tables with specific filtering conditions.
- You want to understand the optimal indexing strategy for a particular table in your database.
- You're experiencing slow query performance and require assistance identifying bottlenecks.
- You need help diagnosing an error message or unexpected behavior within your PostgreSQL environment.
Key capabilities
- SQL Query Generation
- Database Schema Analysis
- Query Performance Optimization
- PostgreSQL Troubleshooting
Example prompts
- "Write a SQL query to find all customers who placed orders over $100 in the last month."
- "Analyze this database schema and suggest appropriate indexes for faster querying."
- "This query is taking too long. Can you help me optimize it?"
- "I'm getting an error 'relation does not exist'. What could be causing this?"
Tips & gotchas
To get the best results, provide clear details about your database schema and the specific problem you are trying to solve. The skill assumes a working PostgreSQL environment is accessible for analysis and query execution.
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.