pgtriage MCP server

by pgtriage·io.github.pgtriage/pgtriage·v0.1.3

MCP server for PostgreSQL performance auditing with actionable SQL fixes.

C65/100grade C

What users say

No reviews yet

Safety scan

C65/100

Adoption

Not measured yet

Usage numbers are collected on the next scan

Reviews

Nobody has reviewed pgtriage yet.

If you have run it, two minutes of your experience saves the next person an afternoon.

write = sends, deletes, buys or posts

Read from the package source without running it. The installed server may list more.

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_auditwrite action
Run a comprehensive performance audit: table health, slow queries, index health, and configuration review. Returns a unified report with all findings sorted by severity.

scanner v0.1.9 · 2026-09-20 · same rubric, same numbers if you re-run it

1 low

Code scan17 source files scanned25/25
–Live reliabilityno gateway calls yet and no remote to proben/a
–Tool poisoningtools not inspected (local package is not executed); not countedn/a
Auth qualitylocal package, no credentials required12/15
Maintenanceno repository listed3/15
Maintainer identityno repository or website to verify2/10

Overall 65/100. Components that don't apply are left out of the denominator. Any critical finding is an F.Rubric Appeal a finding JSON

claude mcp add pgtriage -- uvx pgtriage

Is pgtriage MCP server safe?: With care: it is graded C, so read the findings first (65/100). Read the pgtriage safety report
How do I install pgtriage?: It runs on your machine. Copy the Claude Code, Claude Desktop or Cursor config from the install section.
Does pgtriage need an API key?: Not as far as the registry entry and our scan can tell: no credentials are declared or required.
Is pgtriage maintained?: The latest release is v0.1.3.
What can I use instead of pgtriage?: Servers from other publishers that do the same job: DBHub MCP server, PostgreSQL (hardened, read-only) MCP server and DBConvert Streams (Federated SQL) MCP server. Compare all pgtriage alternatives.

Same job from other publishers: the closest match first, then the best rated.

DBHub
Token-efficient database MCP server for PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLite
not reviewed
Widely used
A
PostgreSQL (hardened, read-only)
Read-only PostgreSQL over MCP. Writes refused at the parsed SQL, plus a READ ONLY transaction.
not reviewed
Growing
C
DBConvert Streams (Federated SQL)
Read-only SQL across your PostgreSQL, MySQL, S3 buckets and local data files, in one query.
not reviewed
Growing
A
GeoLens
Read-only access to a self-hosted GeoLens spatial catalog: datasets, features, maps, sandboxed SQL.
not reviewed
Established
B
LINQ to DB
Inspect database schemas and execute SQL queries across multiple database providers with LINQ to DB.
not reviewed
Established
A