Postgres
Connects to and queries PostgreSQL databases using SQL, retrieving data and executing commands via the oldwinter 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 oldwinter-postgres npx -- -y @trustedskills/oldwinter-postgres
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"oldwinter-postgres": {
"command": "npx",
"args": [
"-y",
"@trustedskills/oldwinter-postgres"
]
}
}
}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 can execute SQL queries, retrieve data, and perform basic database operations. The agent can be used for tasks such as generating reports from database information or updating records based on specific criteria.
When to use it
- Data Analysis: Extracting insights and trends from stored data within a PostgreSQL database.
- Report Generation: Automatically creating reports based on queries against a database.
- Database Updates: Modifying existing data in the database based on user instructions or external triggers.
- Inventory Management: Querying a product inventory database to check stock levels and update quantities.
Key capabilities
- SQL query execution
- Data retrieval from PostgreSQL databases
- Basic database operations (e.g., updates)
Example prompts
- "Get me the total sales for last quarter from the 'orders' table."
- "Update the price of product ID 123 to $19.99 in the 'products' table."
- "List all customers who placed an order after January 1, 2024."
Tips & gotchas
The agent requires access credentials (username and password) for the PostgreSQL database. Ensure these are provided securely and 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.