Postgresql Psql
Executes PostgreSQL queries via psql, enabling data retrieval, modification, and schema management for akornmeier's database workflows.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add akornmeier-postgresql-psql npx -- -y @trustedskills/akornmeier-postgresql-psql
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"akornmeier-postgresql-psql": {
"command": "npx",
"args": [
"-y",
"@trustedskills/akornmeier-postgresql-psql"
]
}
}
}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 PostgreSQL databases using psql, a command-line tool. It can execute SQL queries, retrieve data, and manage database objects directly from within the agent's workflow. This enables automated tasks like data extraction, reporting, and schema modifications.
When to use it
- Automated Reporting: Generate regular reports based on data stored in a PostgreSQL database.
- Data Migration: Script and execute SQL commands for migrating data between databases or environments.
- Database Troubleshooting: Run diagnostic queries and analyze database performance issues.
- Schema Updates: Automate changes to the database schema, such as adding tables or columns.
Key capabilities
- Execute SQL Queries
- Retrieve Data from PostgreSQL Databases
- Manage Database Objects (tables, views, etc.)
- Utilize
psqlcommand-line tool
Example prompts
- "Run the query 'SELECT * FROM customers WHERE city = 'New York'' and show me the results."
- "Create a table named 'orders' with columns for order_id, customer_id, and order_date."
- "What is the total number of products in the 'inventory' table?"
Tips & gotchas
- Requires access to a PostgreSQL database and appropriate credentials.
- The agent needs to understand SQL syntax to effectively use this skill.
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.