Postgresql
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 schoi80-postgresql npx -- -y @trustedskills/schoi80-postgresql
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"schoi80-postgresql": {
"command": "npx",
"args": [
"-y",
"@trustedskills/schoi80-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 manage PostgreSQL databases. It can execute SQL queries, retrieve data, and perform database operations based on natural language instructions. The agent can also be used to create tables and insert data into a PostgreSQL database.
When to use it
- You need to query a PostgreSQL database for specific information (e.g., "Find all customers in California").
- You want to automate tasks like creating new database tables or inserting records.
- You're building an application that requires dynamic data retrieval and manipulation from a PostgreSQL database.
- You need to perform complex SQL operations based on natural language requests.
Key capabilities
- Execute SQL queries
- Retrieve data from PostgreSQL databases
- Create new tables
- Insert data into tables
Example prompts
- "Get me the names of all products with a price greater than $50."
- "Create a table called 'users' with columns for id, name, and email."
- "Add a new user to the users table named John Doe with the email [email protected]."
Tips & gotchas
- Ensure you have access to a PostgreSQL database and the necessary credentials before using this skill.
- The agent's SQL query generation might require refinement for complex or ambiguous requests.
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.