Mcp Postgres Analytics

@archimedes-market

サーバーを訪問

16 days ago

Curated by Archimedes Market with a verified Trust Report (security, quality, license, complexity). Read-only PostgreSQL analytics agent exposed as an MCP server. Inspect query plans, surface slow queries, audit index usage, detect table bloat, and report vacuum status — without any DDL, DML, or write access. Designed to drop into a production database safely. → Full Trust Report: archimedes.market/assets/aa632521-f830-4adf-9828-7c6079e06a83

概要ツールコメント

概要

![Archimedes Trust Report — VERIFIED 92/100](https://img.shields.io/badge/Archimedes_Trust-VERIFIED_92%2F100-1 0B981?style=flat-square)

Verified asset on Archimedes
Market — view the full 4-dimension Trust Report (security · quality · license · complexity) and the curated catalog on the asset page.

Read-only PostgreSQL analytics agent exposed as an MCP server. Designed to drop into a production database safely — no DDL, no DML, no writes ever.

Tools

query_plan — EXPLAIN (ANALYZE, BUFFERS, VERBOSE) against a query string, with annotated cost hot spots
slow_queries — top N queries by mean time / total time / call count from pg_stat_statements
index_usage — index hit ratio, dead indexes, missing-index hints
table_bloat — bloat estimation per table
vacuum_status — last vacuum / autovacuum / analyze per table, with wraparound risk flagged
connection_stats — active sessions, idle-in-transaction, longest-running transactions
lock_waits — blocked queries with the blocker chain resolved
size_summary — database/schema/table/index size, sorted

Safety guarantees

The MCP server connects as a role with pg_read_all_stats and CONNECT only. The connection string in
MCP_POSTGRES_DSN is validated at startup to refuse any role that has CREATE, INSERT, UPDATE, DELETE, TRUNCATE, ALTER, or DROP privileges. Refusal exits with a clear error rather than running with elevated
rights.

query_plan accepts a query string but executes it inside EXPLAIN (...) only — the query itself is never
run. MCP_POSTGRES_DSN is validated at startup to refuse any role that has CREATE, INSERT, UPDATE, DELETE, TRUNCATE, ALTER, or DROP privileges. Refusal exits with a clear error rather than running with elevated rights.

query_plan accepts a query string but executes it inside EXPLAIN (...) only — the query itself is never run.

Quick start

pip install git+https://github.com/archimedes-market/mcp-postgres-analytics
export MCP_POSTGRES_DSN="postgresql://reader@host:5432/db"
mcp-postgres-analytics serve

More verified MCP servers

Browse the full Archimedes Market catalog at archimedes.market/assets — 97 free engineering assets with Trust
Reports across MCP servers, CAD libraries, EDA reference designs, and synthetic datasets.

License

MIT.

Playgroundで試す

サーバー設定

{
  "mcpServers": {
    "postgres-analytics": {
      "command": "mcp-postgres-analytics",
      "args": [
        "serve"
      ],
      "env": {
        "MCP_POSTGRES_DSN": "postgresql://reader@host:5432/db"
      }
    }
  }
}

Build with ShipAny.