Postgresql
Connects to and executes SQL queries against PostgreSQL databases using secure credentials and efficient data retrieval.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add jgamaraalv-postgresql npx -- -y @trustedskills/jgamaraalv-postgresql
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"jgamaraalv-postgresql": {
"command": "npx",
"args": [
"-y",
"@trustedskills/jgamaraalv-postgresql"
]
}
}
}Requires Claude Code (claude CLI). Run claude --version to verify your install.
About This Skill
What it does
This skill provides access to PostgreSQL, a powerful open-source relational database system. It allows AI agents to execute SQL queries, manage databases and tables, and retrieve structured data for analysis or application use. The agent can interact with existing PostgreSQL instances or potentially create new ones depending on the underlying infrastructure.
When to use it
- Data Extraction: Retrieve specific information from a PostgreSQL database based on natural language requests (e.g., "Get all customers in California").
- Report Generation: Generate reports by querying and aggregating data stored within PostgreSQL tables.
- Database Management: Perform administrative tasks like creating new tables or updating existing records, if appropriate permissions are granted.
- Application Integration: Connect to a PostgreSQL database as part of a larger application workflow, such as processing orders or managing inventory.
Key capabilities
- SQL query execution
- Data retrieval from PostgreSQL databases
- Database table management (potentially)
- Integration with existing PostgreSQL instances
Example prompts
- "Show me the names and email addresses of all users."
- "Create a new table called 'products' with columns for name, price, and description."
- "What is the average order value from the last month?"
Tips & gotchas
- Requires access to a PostgreSQL database instance. Ensure the AI agent has appropriate credentials and permissions before use.
- The specific actions available (e.g., table creation) depend on the underlying infrastructure and security configurations.
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.