Postgresql
Connects to and queries PostgreSQL databases using SQL, enabling data retrieval and manipulation via g1joshi's AI agent.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add g1joshi-postgresql npx -- -y @trustedskills/g1joshi-postgresql
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"g1joshi-postgresql": {
"command": "npx",
"args": [
"-y",
"@trustedskills/g1joshi-postgresql"
]
}
}
}Requires Claude Code (claude CLI). Run claude --version to verify your install.
About This Skill
What it does
This skill allows an AI agent to interact with and query PostgreSQL databases. It enables agents to execute SQL queries, retrieve data, and potentially modify database contents based on user instructions or predefined logic. The skill facilitates integration of database operations into automated workflows and conversational applications.
When to use it
- Data Extraction: Retrieve specific information from a PostgreSQL database for reporting or analysis.
- Automated Tasks: Automate tasks that require interacting with a PostgreSQL database, such as updating records or creating new entries.
- Conversational Applications: Build chatbots or virtual assistants that can answer questions based on data stored in a PostgreSQL database.
- Data Validation: Verify the integrity of data within a PostgreSQL database by executing validation queries.
Key capabilities
- SQL Query Execution
- Data Retrieval
- Database Interaction
Example prompts
- "Get me all customers from California."
- "Update the price of product ID 123 to $19.99."
- "What is the total number of orders placed this month?"
Tips & gotchas
The agent requires access credentials (username and password) for the PostgreSQL database to function correctly. Ensure that the user has appropriate permissions within the database to perform the requested actions.
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.