pgtriage
Read-only MCP server for evidence-based PostgreSQL performance auditing.
Connector by pgtriage · GitHub account verified by the MCP Registry
Install
Works with Claude Code, Codex, VS Code, Cursor, Windsurf, Claude Desktop. Read the repository before you give any tool access to your data.
npx agentmarket install connector/pgtriage-pgtriage
Asks which of your tools to add it to (Claude Code, Codex, Cursor, VS Code, Windsurf, Gemini CLI, Claude Desktop) and shows the change first. See https://agentmart.dev/cli.
Get the weekly diff
The weekly diff: one email a week with new agent tools, notable updates and grade changes, plus security alerts for tools you follow. Double opt-in, one-click unsubscribe.
About
Use cases: database-access, monitoring-observability
Reviews
Write a reviewNo reviews yet. Installed it? Reviews come from verified installers only. How reviews work
Permissions
What this server can do and what it asks for, from its tool list, install config and code. Checked Oct 25, 2026.
- Tools
- 4 read · 0 write · 0 delete · 1 not yet classified
- Secrets
- None asked for
- Install scripts
- None found
- Runs as
- Python package
Tools by what they do 5
Read from the source code; the running server may list different tools.
Read 4 · Look things up without changing anything.
analyze_slow_queriescheck_configcheck_index_healthcheck_table_health
Not yet classified 1 · We could not tell from the name and description.
full_audit
Tools (5)
Read from the source code; the running server may differ. Descriptions are the server’s own words; hidden characters are shown as [U+…].
analyze_slow_queriesFind and analyze slow queries from pg_stat_statements. Runs EXPLAIN ANALYZE on top slow SELECT queries and detects performance patterns like sequential scans and missing indexes.
check_configReview PostgreSQL configuration settings and flag suboptimal values for shared_buffers, work_mem, max_connections, and autovacuum parameters.
check_index_healthFind unused indexes, duplicate indexes, and missing index opportunities based on sequential scan patterns.
check_table_healthCheck table health: dead tuples, bloat, vacuum stats, scan ratios. Optionally filter to a specific user schema and/or table by name.
full_auditRun a comprehensive performance audit: table health, slow queries, index health, and configuration review. Returns a unified report with all findings sorted by severity. Optionally scope table, slow-query, and index findings to one user schema. Configuration findings remain database-wide. Omitting schema_name audits all non-system schemas.
Compare and alternatives
Featured in
Signals
- Weekly downloads
- 202
- Last release
- Oct 23, 2026 (5 days ago)
- Last package publish
- Oct 23, 2026 (5 days ago)
From the package registry.
Details
- Registry name
io.github.pgtriage/pgtriage- Version
- 0.2.1
- Auth
- No auth
- Packages
- pypi pgtriage
- License
- MIT
- First seen
- Oct 24, 2026
- Last checked
- Oct 24, 2026
- Source
- Official MCP Registry
Cite this page
pgtriage MCP server. Agent Mart. https://agentmart.dev/connectors/pgtriage-pgtriage (last updated 2026-10-24)