MCP.so
Sign In

Mcp Postgres Analytics

@archimedes-market

Repository

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

Basic information

Category

Data & Analytics

Transports

stdio

Publisher

archimedes-market

Submitted by

Emmanuel “CUBE” Kubikus

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"
      }
    }
  }
}

Tools

No tools detected

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

FAQ from Mcp Postgres Analytics

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 (...).

What database permissions are required?

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

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.

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.

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

Federal Reserve Economic Data MCP Server

stefanoamorelli

Open-source FRED MCP Server (Federal Reserve Economic Data)

104

PubMed Analysis MCP Server

Darkroaster

A PubMed MCP server.

150

Google Analytics MCP Server

surendranb

Google Analytics 4 data to AI agents, agentic workflows, and MCP clients. Give agents analysis-ready access to website traffic, user behavior, and performance data with schema discovery, server-side aggregation, and safe defaults that reduce data wrangling.

225

Bright Data MCP

brightdata

A powerful Model Context Protocol (MCP) server that provides an all-in-one solution for public web access.

2.5K

🎓 Semantic Scholar MCP Server

JackKuo666

🔍 This project implements a Model Context Protocol (MCP) server for interacting with the Semantic Scholar API. It provides tools for searching papers, retrieving paper and author details, and fetching citations and references.

75