Mcp Postgres Analytics
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 spotsslow_queries— top N queries by mean time / total time / call count frompg_stat_statementsindex_usage— index hit ratio, dead indexes, missing-index hintstable_bloat— bloat estimation per tablevacuum_status— last vacuum / autovacuum / analyze per table, with wraparound risk flaggedconnection_stats— active sessions, idle-in-transaction, longest-running transactionslock_waits— blocked queries with the blocker chain resolvedsize_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.
Server Config
{
"mcpServers": {
"postgres-analytics": {
"command": "mcp-postgres-analytics",
"args": [
"serve"
],
"env": {
"MCP_POSTGRES_DSN": "postgresql://reader@host:5432/db"
}
}
}
}