Postgresql Expert
Troubleshoot complex PostgreSQL queries, optimize performance, and design schemas with expert guidance from lammesen's AI.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add lammesen-postgresql-expert npx -- -y @trustedskills/lammesen-postgresql-expert
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"lammesen-postgresql-expert": {
"command": "npx",
"args": [
"-y",
"@trustedskills/lammesen-postgresql-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 management. It can generate complex SQL queries, optimize database performance through indexing and query analysis, and troubleshoot common PostgreSQL errors. The agent is capable of understanding intricate schema designs and providing recommendations for improvement.
When to use it
- You need help writing a complex SQL query that you're struggling with.
- Your PostgreSQL database is running slowly, and you want suggestions for optimization.
- You are encountering an error in your PostgreSQL setup and require troubleshooting assistance.
- You’re designing a new database schema and want expert feedback on best practices.
Key capabilities
- SQL query generation
- Database performance optimization (indexing)
- Query analysis
- Error troubleshooting
- Schema design advice
Example prompts
- "Write a SQL query to find all customers who placed orders over $100 in the last month."
- "My PostgreSQL database is slow. Can you analyze my queries and suggest indexes?"
- "I'm getting an error 'relation "mytable" does not exist'. What could be causing this?"
Tips & gotchas
The agent’s effectiveness depends on providing clear details about your specific PostgreSQL environment, including table schemas and data samples where possible. It assumes a working PostgreSQL installation; it cannot install or configure the database itself.
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.