Clinpgx Database
Connects, queries, and manipulates PostgreSQL databases using advanced AI techniques for efficient data management.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add microck-clinpgx-database npx -- -y @trustedskills/microck-clinpgx-database
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"microck-clinpgx-database": {
"command": "npx",
"args": [
"-y",
"@trustedskills/microck-clinpgx-database"
]
}
}
}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 a PostgreSQL database. It facilitates retrieving clinical data, executing SQL queries, and potentially updating information within the database. The agent can use this skill to answer questions based on structured clinical records or perform analysis tasks requiring database access.
When to use it
- Clinical Data Retrieval: An agent needs to find specific patient records based on criteria like diagnosis, medication, or date of service.
- Report Generation: Generate summaries and reports from data stored in the PostgreSQL database.
- Data Analysis: Perform basic statistical analysis or identify trends within clinical datasets.
- Automated Tasks: Automate tasks that require querying or updating information in a clinical database, such as generating patient lists for outreach programs.
Key capabilities
- PostgreSQL Database Interaction
- SQL Query Execution
- Data Retrieval
- Potential Data Update (implementation dependent)
Example prompts
- "Find all patients diagnosed with diabetes and over the age of 65."
- "What is the average length of stay for patients admitted with pneumonia?"
- "List medications prescribed to patient ID 12345."
Tips & gotchas
- Requires access credentials (username, password) to connect to the PostgreSQL database.
- The agent's SQL queries should be carefully validated to prevent unintended data modifications or security vulnerabilities.
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.