广告合作
MCP.so
登录

MCP Postgres Analytics

@archimedes-market

代码仓库

基本信息

分类

数据与分析

传输方式

stdio

作者

archimedes-market

提交者

Emmanuel “CUBE” Kubikus

关于 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 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

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

MCP Postgres Analytics 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

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

常见问题

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.

评论

数据与分析 分类下的更多 MCP 服务器

Trendos

Gintare Rimolaityte

Trendos is a remote MCP server for AI search visibility data and opportunities available at https://api.trendos.com.

CoinLobster

CoinLobster

The only MCP server with live whale trades across 15 exchanges plus on-chain DEX flow. Smart Money Radar, real liquidations and outcome-scored signals. No API key required.

3

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

Social Growth Engineers

Top In It

The research behind short-form growth for your AI assistant: viral TikTok and Reels videos, the hooks that made them work, app growth playbooks, articles and reports.

AwardTape

Datil Technologies, Inc

US defense and homeland security contract awards (DoD and DHS since FY2024) plus daily Pentagon contract announcements. Includes a free sample tool, award search ($0.02/call), company profiles ($0.02/call), daily top 200

广告合作