Postgresql Code Review
Official github skill covering PostgreSQL, code review for working with databases and data persistence.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add postgresql-code-review npx -- -y @trustedskills/postgresql-code-review
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"postgresql-code-review": {
"command": "npx",
"args": [
"-y",
"@trustedskills/postgresql-code-review"
]
}
}
}Requires Claude Code (claude CLI). Run claude --version to verify your install.
About This Skill
What it does
The postgresql-code-review skill enables AI agents to analyze PostgreSQL code for best practices, security vulnerabilities, and performance improvements. It identifies issues like inefficient queries, improper indexing, or insecure configurations in SQL scripts and provides actionable feedback.
When to use it
- Reviewing SQL scripts before deployment to ensure they follow PostgreSQL best practices.
- Auditing legacy databases for potential optimization opportunities.
- Ensuring compliance with security standards when writing new database schemas or queries.
- Helping developers understand why a particular query is slow or causing errors.
Key capabilities
- Detects inefficient or insecure SQL queries
- Suggests performance improvements and best practices
- Identifies missing indexes or improper schema design
- Highlights potential security risks in PostgreSQL configurations
Example prompts
- "Review this PostgreSQL query for performance issues."
- "Check if this SQL script follows secure coding practices."
- "Analyze the schema design of this database for optimization opportunities."
Tips & gotchas
- Ensure your code is formatted correctly and includes full context for accurate analysis.
- This skill works best with well-documented queries; ambiguous or incomplete scripts may yield less useful 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 |
🏢 Official
Published by the company or team that built the technology.