Postgres
Connects to and queries PostgreSQL databases using SQL, retrieving data based on provided instructions.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add wcygan-postgres npx -- -y @trustedskills/wcygan-postgres
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"wcygan-postgres": {
"command": "npx",
"args": [
"-y",
"@trustedskills/wcygan-postgres"
]
}
}
}Requires Claude Code (claude CLI). Run claude --version to verify your install.
About This Skill
What it does
This skill enables AI agents to interact with and manage PostgreSQL databases. It allows querying data, executing SQL commands, and performing database administration tasks directly through natural language prompts. The agent can retrieve specific information from tables or even modify the database schema based on user instructions.
When to use it
- Data Analysis: Quickly extract insights from a PostgreSQL database without needing to write complex SQL queries manually.
- Database Administration: Perform routine maintenance tasks like creating users, granting permissions, or backing up data through conversational commands.
- Application Development: Generate SQL statements for interacting with the database during application development and testing phases.
- Report Generation: Create reports by querying specific tables and formatting the results based on user requests.
Key capabilities
- SQL Query Execution
- Database Schema Management
- Data Retrieval
- Database Administration Tasks
Example prompts
- "Show me all customers from California."
- "Create a backup of my database named 'production_backup'."
- "What is the average order value?"
- “Grant read-only access to user ‘analyst’ on table ‘orders’.”
Tips & gotchas
The agent requires proper authentication credentials for accessing the PostgreSQL database. Ensure that these credentials are securely provided and managed to prevent unauthorized access.
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.