Skip to content
Agentmart
Submit a tool

pgtriage

Read-only MCP server for evidence-based PostgreSQL performance auditing.

Connector by pgtriage · GitHub account verified by the MCP Registry

IndexedMITLocal (stdio)
Write a review

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.

We use your email only for this newsletter. Privacy

About

Read-only MCP server for evidence-based PostgreSQL performance auditing.

Use cases: database-access, monitoring-observability

No 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_queries
  • check_config
  • check_index_health
  • check_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_queries

    Find 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_config

    Review PostgreSQL configuration settings and flag suboptimal values for shared_buffers, work_mem, max_connections, and autovacuum parameters.

  • check_index_health

    Find unused indexes, duplicate indexes, and missing index opportunities based on sequential scan patterns.

  • check_table_health

    Check table health: dead tuples, bloat, vacuum stats, scan ratios. Optionally filter to a specific user schema and/or table by name.

  • full_audit

    Run 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
    Cite this page

    pgtriage MCP server. Agent Mart. https://agentmart.dev/connectors/pgtriage-pgtriage (last updated 2026-10-24)