Postgres Expert
Expertly queries, optimizes, and troubleshoots PostgreSQL databases using advanced SQL and best practices.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add duck4nh-postgres-expert npx -- -y @trustedskills/duck4nh-postgres-expert
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"duck4nh-postgres-expert": {
"command": "npx",
"args": [
"-y",
"@trustedskills/duck4nh-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 assistance with PostgreSQL database tasks. It can generate SQL queries, analyze query performance, and troubleshoot common database issues. The agent can also help design schemas and optimize existing databases for improved efficiency.
When to use it
- You need help writing complex SQL queries that you're struggling with.
- Your PostgreSQL database is running slowly, and you want suggestions for optimization.
- You are designing a new database schema and need guidance on best practices.
- You’re encountering errors in your PostgreSQL environment and require troubleshooting assistance.
Key capabilities
- SQL query generation
- Query performance analysis
- Database schema design
- Troubleshooting PostgreSQL issues
Example prompts
- "Write a SQL query to find all customers who placed an order over $100."
- "Analyze the execution plan for this query: [paste query here]."
- "I need to design a database table for storing product information. What fields should I include?"
- “Explain why my PostgreSQL server is experiencing high latency.”
Tips & gotchas
The agent requires access to relevant database schemas or sample data to provide accurate and helpful responses. Providing context about the specific PostgreSQL version being used can also improve results.
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.