Postgres Wizard
Generates complex PostgreSQL queries, optimizes existing ones, and troubleshoots errors with expert precision.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add postgres-wizard npx -- -y @trustedskills/postgres-wizard
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"postgres-wizard": {
"command": "npx",
"args": [
"-y",
"@trustedskills/postgres-wizard"
]
}
}
}Requires Claude Code (claude CLI). Run claude --version to verify your install.
About This Skill
What it does
The postgres-wizard skill allows AI agents to interact with and manipulate PostgreSQL databases. It can execute SQL queries, retrieve data, and perform database administration tasks like creating tables or updating schemas. This skill is designed for scenarios requiring programmatic access and management of PostgreSQL data stores.
When to use it
- Data Extraction: Retrieve specific information from a PostgreSQL database based on complex criteria (e.g., "Get all customers who placed an order in the last month").
- Database Schema Modification: Automatically create or alter tables, indexes, and other schema elements based on requirements (e.g., "Add a new column 'email' to the 'users' table").
- Data Analysis & Reporting: Generate reports by querying data from PostgreSQL databases and presenting it in a structured format.
- Automated Database Maintenance: Execute routine tasks like backups or index optimization scripts within a PostgreSQL environment.
Key capabilities
- SQL query execution
- Database schema modification (create/alter tables)
- Data retrieval
- Database administration tasks
Example prompts
- "Run the following SQL query:
SELECT * FROM products WHERE price > 100" - "Create a table named 'orders' with columns for order_id, customer_id, and order_date."
- “What is the total number of users in the ‘users’ table?”
Tips & gotchas
The agent needs access to a PostgreSQL database instance. Ensure proper credentials (host, port, username, password) are provided for successful interaction with the database.
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.