Postgresql
Generates PostgreSQL queries, explains SQL concepts, and troubleshoots errors for learners of all levels.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add teachingai-postgresql npx -- -y @trustedskills/teachingai-postgresql
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"teachingai-postgresql": {
"command": "npx",
"args": [
"-y",
"@trustedskills/teachingai-postgresql"
]
}
}
}Requires Claude Code (claude CLI). Run claude --version to verify your install.
About This Skill
What it does
This skill allows AI agents to interact with and query PostgreSQL databases. It enables tasks like retrieving specific data, executing SQL commands, and managing database schemas directly through natural language prompts. The agent can be used to automate reporting, analyze data trends, or perform complex database operations.
When to use it
- Data Extraction: Retrieve customer information from a CRM database based on specific criteria (e.g., "Find all customers in California with orders over $100").
- Report Generation: Automatically generate reports by querying sales data and formatting the results into a readable table ("Create a report showing monthly sales for each product category").
- Database Administration: Perform basic database administration tasks like creating tables or updating records (e.g., "Add a new user to the 'employees' table with these details.").
Key capabilities
- SQL Query Execution
- Data Retrieval
- Schema Management
- Natural Language Interface for Database Interaction
Example prompts
- "Show me all orders placed in the last week."
- "What is the average price of products in the 'electronics' category?"
- "Create a table named 'customers' with columns for name, email, and address."
Tips & gotchas
- Requires access to a PostgreSQL database. Ensure the agent has appropriate credentials and permissions before use.
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.