Sqlx Postgres
Executes SQL queries against PostgreSQL databases using sqlx for efficient Rust integration and 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 sqlx-postgres npx -- -y @trustedskills/sqlx-postgres
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"sqlx-postgres": {
"command": "npx",
"args": [
"-y",
"@trustedskills/sqlx-postgres"
]
}
}
}Requires Claude Code (claude CLI). Run claude --version to verify your install.
About This Skill
What it does
This skill provides access to a PostgreSQL database using sqlx. It allows AI agents to execute SQL queries, retrieve data, and interact with the database in a structured way. The agent can perform tasks like querying for specific records or executing complex joins based on provided instructions.
When to use it
- Retrieving product information from an e-commerce database based on user search terms.
- Generating reports by running aggregate queries against sales data.
- Updating inventory levels in a warehouse management system after processing orders.
- Analyzing website traffic patterns stored in a database.
Key capabilities
- PostgreSQL database interaction
- SQL query execution via
sqlx - Data retrieval and manipulation
- Structured data access
Example prompts
- "Get all customers from the 'customers' table where their city is 'New York'."
- "Execute this SQL query: SELECT * FROM products WHERE price > 100;"
- "Find the total number of orders placed in the last month."
Tips & gotchas
This skill requires a PostgreSQL database to be configured and accessible. Ensure that the connection details (host, port, username, password) are correctly provided for successful interaction.
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.