Advertise
MCP.so
Sign In

MCP Postgres Analytics

@archimedes-market

Repository

Basic information

Category

Data & Analytics

Transports

stdio

Author

archimedes-market

Submitted by

Emmanuel “CUBE” Kubikus

About MCP Postgres Analytics

Curated by Archimedes Market with a verified Trust Report (security, quality, license, complexity).

#mcp#postgres#analytics#database#observability#read-only#mcp-server

MCP Postgres Analytics config

Add this server to your MCP-compatible client using the configuration below.

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

MCP Postgres Analytics tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is Mcp Postgres Analytics?

Mcp Postgres Analytics is a read-only PostgreSQL analytics agent exposed as an MCP server. It connects to a production database safely—never performing any writes, DDL, or DML—and provides tools for query planning, performance diagnostics, and database statistics.

How to use Mcp Postgres Analytics?

Install via pip install git+https://github.com/archimedes-market/mcp-postgres-analytics, set the environment variable MCP_POSTGRES_DSN to a postgresql:// connection string, then run mcp-postgres-analytics serve.

Key features of Mcp Postgres Analytics

  • Reads-only: no DDL, DML, or writes ever
  • Startup refuses roles with write privileges (CREATE, INSERT, etc.)
  • query_plan runs only EXPLAIN (ANALYZE, BUFFERS, VERBOSE)—never the query itself
  • Provides tools for slow queries, index usage, table bloat, vacuum status, connections, lock waits, and size summaries
  • Connects as a role with minimal pg_read_all_stats and CONNECT privileges

Use cases of Mcp Postgres Analytics

  • Monitor slow queries via pg_stat_statements
  • Analyze query execution plans without running the actual query
  • Detect index bloat and missing-index hints
  • Identify lock contention and blocking transaction chains
  • Track vacuum/autovacuum progress and wraparound risk

Frequently asked questions

1

Is Mcp Postgres Analytics really read-only?

Yes. The server validates at startup that the role in `MCP_POSTGRES_DSN` has no `CREATE`, `INSERT`, `UPDATE`, `DELETE`, `TRUNCATE`, `ALTER`, or `DROP` privileges. If it does, the server exits with a clear error. Additionally, the `query_plan` tool never executes the submitted query—it runs only `EXPLAIN (...)`.

2

What database permissions are required?

The role needs only `pg_read_all_stats` and `CONNECT` privileges. No write permissions are allowed.

3

Which tools are available?

Seven tools: `query_plan`, `slow_queries`, `index_usage`, `table_bloat`, `vacuum_status`, `connection_stats`, `lock_waits`, and `size_summary`. Each provides production-safe diagnostic information.

4

How do I install Mcp Postgres Analytics?

Run `pip install git+https://github.com/archimedes-market/mcp-postgres-analytics`. Then set the `MCP_POSTGRES_DSN` environment variable to your PostgreSQL connection string and start the server with `mcp-postgres-analytics serve`.

5

Does Mcp Postgres Analytics modify the database?

No. It is designed to be a read-only agent. All tools only query system statistics and views; no data is written to the database.

Comments

More Data & Analytics MCP servers

Sugra API MCP

Sugra Systems, Inc.

Official MCP server for the Sugra API, giving AI agents source-attributed access to 1,500+ endpoints across 36 data domains from 160+ primary sources. Covers markets, economics, company fundamentals, government, news, cl

1

SportsTrackLive

STL Solutions

SportsTrackLive is a remote MCP server available at https://mcp.sportstracklive.com. SportsTrackLive is a Live Tracking solution and let you record, share and relive your Tracks! SportsTrackLive provide a real-time tra

SocialAPIs — Facebook & Instagram Data

SocialAPIsHub

Facebook & Instagram data for AI agents — pages, posts, groups, Ads Library, Marketplace, profiles and reels. 47 read-only tools with structured output.

1

Tracetify — Competitor Ads, Growth Traces & Search Console

tracetify

17 tools for marketing and SEO research inside Claude Code, Cursor, Codex or ChatGPT: the ads any domain runs on Meta and Google, how a product grew from 12 public sources with every claim linked, your own Search Console

1

World Monitor

Elie Habib

Live global-intelligence MCP server covering news, markets, conflicts, aviation, maritime activity, energy, climate, cyber threats, supply chains, and source-grounded regional briefs.

Advertise