原型 · 预览版:收录官方注册中心里的全部服务器,每 30 分钟同步一次。使用 Google 登录即可撰写评价。原型 · 每 30 分钟更新
PopNx MCP为使用 AI 的人准备的 MCP 服务器 · 用大白话讲清楚

Multigres

作者:JoongHyuk-Shin版本 0.1.13i★ 1i在你的电脑上运行代码仓库 ↗
注册名称io.github.JoongHyuk-Shin/multigres-mcp

安装方法

What it does

Postgres diagnostics and cluster operations for Multigres clusters.

  • Connects 在你的电脑上运行
  • Account or key Needs DATABASE_URI, MULTIGRES_ADMIN_TOKEN
  • Category 数据库与数据集

可搭配使用

教 AI 做这类工作的 Skill,可与本项一起使用

timesfm

TimesFM (Time Series Foundation Model) is a pretrained time-series foundation model developed by Google Research for time-series forecasting.

作者:google-research★ 35,6291 个 skill

Skill · 操作手册

Shadowbroker

Open-source intelligence for the global theater. Track everything from the corporate/private jets of the wealthy, and spy satellites, to seismic events in one unified interface. Hook an AI agent up to have it parse through data and find previously unseen correlations. The knowledge is available to…

作者:BigBodyCobain★ 11,6021 个 skill

Skill · 操作手册

google-maps-scraper

scrape data from Google Maps. Extracts data such as the name, address, phone number, website URL, rating, reviews number, latitude and longitude, reviews,email and more for each place

作者:gosom★ 8,2091 个 skill

Skill · 操作手册

为什么排在这里

列表按使用分(满分 100)排序,由以下部分组成

热度4/80GitHub 星标或每周下载量:较大的计 60,较小的计 20
新鲜度12/1230 天内有发布或代码更新得满分
仍在响应0/8上次检查时云端端点有响应
使用分16/100

质量: 基础检查通过 3/3 项(仅展示,不用于排序) · 上升势头: 暂无数据 (只用于“上升中”标签)

安装

选择你使用的 AI 应用,然后复制设置。

通过 3/3 项检查 · 在你的电脑上运行

第一步:你用哪个 AI?

选择你用的应用,步骤会显示在下方。

可连接 Claude,但需要先准备

不需要密钥,不用安装程序 · 仅限电脑上的 Claude 应用(Windows 或 Mac),网页和手机不可用

  1. 下载开发者的安装文件

    下载作者的 .mcpb 文件

    .mcpb 文件直接来自开发者,我们没有修改

  2. 双击文件,然后在电脑版 Claude 应用中点击 Install

  3. 试一试

    用 Multigres 告诉我你能帮我做什么,然后做一件给我看

    ✓ 如果 Claude 说正在使用 Multigres,或回答中出现 Multigres 的工具名称,就表示连接成功

菜单名称已于 2026年11月11日 对照 Anthropic 帮助页面核实 · 你的界面可能因版本略有不同

ChatGPT 暂时无法连接 Multigres

Multigres 需要安装在你的电脑上,而 ChatGPT 只能连接在网上运行的服务器

你可以改用这些方式

A · 使用能连接 Multigres 的应用

  • 不需要密钥,不用安装程序 · 仅限电脑上的 Claude 应用(Windows 或 Mac),网页和手机不可用

B · 数据库与数据集 类中能连接 ChatGPT 的其他服务器

从同类中使用较多的里挑选,仅限用地址即可连接、无需密钥的

Claude Code 暂时无法连接 Multigres

开发者只提供了电脑版 Claude 应用的安装文件

你可以改用这些方式

A · 使用能连接 Multigres 的应用

  • 不需要密钥,不用安装程序 · 仅限电脑上的 Claude 应用(Windows 或 Mac),网页和手机不可用

Cursor 暂时无法连接 Multigres

开发者只提供了电脑版 Claude 应用的安装文件

你可以改用这些方式

A · 使用能连接 Multigres 的应用

  • 不需要密钥,不用安装程序 · 仅限电脑上的 Claude 应用(Windows 或 Mac),网页和手机不可用

VS Code 暂时无法连接 Multigres

开发者只提供了电脑版 Claude 应用的安装文件

你可以改用这些方式

A · 使用能连接 Multigres 的应用

  • 不需要密钥,不用安装程序 · 仅限电脑上的 Claude 应用(Windows 或 Mac),网页和手机不可用

其他支持 MCP 的应用(如 Windsurf、Zed、Gemini CLI)添加方式各不相同,请在应用列表中查看

查看所有支持 MCP 的应用 →

JSON 设置在下方“开发者专用”中

卡住了?问问正在用 Multigres 的人💬 讨论 →
开发者专用:终端命令和 JSON 设置

需要你填写的值

  • DATABASE_URI 机密 必填 env
    Multigres 网关的 Postgres 连接字符串。
    查看英文原文Postgres connection string of the Multigres gateway.
  • MULTIGRES_ADMIN_URL env
    multiadmin HTTP 地址。仅当设置该值时才会注册集群工具。
    查看英文原文multiadmin HTTP address. The cluster tools are registered only when it is set.
  • MULTIGRES_ADMIN_TOKEN 机密 必填 env
    用于以 --enable-auth 启动的 multiadmin 的 Bearer 令牌。
    查看英文原文Bearer token for multiadmin started with --enable-auth.
  • MULTIGRES_NODE_HOST_MAP env
    reported=可访问的主机对,以逗号分隔,用于直接的节点连接。
    查看英文原文reported=reachable host pairs, comma separated, for direct node connections.
  • MULTIGRES_MCP_ACCESS_MODE env
    restricted(只读)或 unrestricted(添加写入工具)。
    查看英文原文restricted (read-only) or unrestricted (adds the write tools).
  • MULTIGRES_MCP_SQL_TIMEOUT env
    每个工具发送的 SQL 语句超时时间,格式为 Go duration
    查看英文原文Statement timeout for the SQL every tool sends, as a Go duration.

说明为自动翻译,变量名保持原样;不确定时请查看原文。

这些设置是根据作者在注册中心的条目生成的。如果 README 的写法不同,请以 README 为准。

一览

每周下载量i
不在 npm/PyPI 上
许可证i
Apache-2.0
连接方式
在你的电脑上运行
最新版本i
0.1.13
发布到注册中心i
2026年11月18日
代码最后更新i
2026年11月18日
作者
JoongHyuk-Shin
软件包
mcpb: …/multigres-mcp-0.1.13.mcpb
注册状态
活跃

哪些应用可以使用它

依据这个服务器的连接方式和各应用自己的文档,检查于 2026年11月10日。

在你的电脑上运行,适用于

ClaudeGooseLM StudioMsty StudioCherry StudioVisual StudioWindsurf (Devin Desktop)ZedKiroClineContinueJetBrains AI AssistantCodex CLIGemini CLIOpenCodenodecodeWarpLibreChatRaycast

全部应用及其优缺点 →

它能做什么

它在你的电脑上运行;安装后,工具列表会显示在你的 AI 应用中。

基础检查i

我们检查的是任何人都能看到的信息;我们没有阅读代码。不适用的检查项不计入总数。 · 检查于 2026年11月19日

  • ✓ 通过

    作者与仓库一致

    注册名称已通过 GitHub 账户 JoongHyuk-Shin 验证,该账户拥有此仓库

  • ✓ 通过

    仍在维护

    代码最后更新于昨天

  • ✓ 通过

    有许可证

    使用 Apache-2.0

  • – 不适用

    端点有响应

    它在你的电脑上运行,没有互联网端点

  • – 不适用

    使用 OAuth 登录

    在你的电脑上运行,改用本地设置

  • … 尚未检查

    工具描述中没有隐藏指令

    它在你的电脑上运行;我们只能读取互联网端点的工具列表

已公开的漏洞(OSV.dev)

未检查:只能检查标明版本的 npm 和 PyPI 包

我们检查什么 → · JSON

作者:申请重新检查或报告信息错误
给作者:在 README 中加徽章

如果你是作者,可把这段代码贴到 README。徽章会链接回本页。

[![Featured on PopNx MCP](https://mcp.popnx.com/badge/joonghyuk-shin-multigres-mcp.svg)](https://mcp.popnx.com/en/servers/joonghyuk-shin-multigres-mcp)

讨论

提问、分享技巧或报告无法使用。按“有帮助”数量排序。

还没有帖子,欢迎第一个提问或分享。

此处内容由用户撰写,不代表 PopNx 团队。

登录后发帖

用户评价

还没有评价

登录后写评价

与“数据库与数据集”中的其他服务器比较i

  • 星标数多于此分类中其他 1235 个服务器的 78%
  • 发布到注册中心的时间比此分类中其他 1235 个服务器的 98% 更新
  • 基础检查结果等于或优于此分类中其他 1235 个服务器的 99%

与注册中心里这个分类中所有活跃的服务器比较。只有当发布者拥有该仓库时,星标数才计入。

常见问题

Multigres 安全吗?

它在 3 项适用的基础检查中通过了 3 项。我们没有阅读代码。在添加密钥或令牌之前,请先看看这个服务器要求哪些权限,并使用只具备所需权限的密钥。

它需要哪些密钥或代码?

你需要填写:DATABASE_URI, MULTIGRES_ADMIN_TOKEN

它在我的电脑上运行还是在云端?

它在你的电脑上运行。你的 AI 应用会在需要时启动它,数据不会经过作者的服务器(除非它自己调用在线服务)。

它还在维护吗?

GitHub 仓库最后更新于昨天,最新版本(0.1.13)于昨天进入注册中心。

哪些应用可以使用它?

支持 MCP 的应用,例如 Claude Desktop、Claude Code、Cursor 和 VS Code。你的电脑上还需要有 MCPB。

有什么可以替代它?

同一分类中有:QueryWeaver, Supabase, Neon, DBCode, Keboola MCP

功能相近的其他选择

同一分类、其他作者、命令已通过检查。官方的排在前面,再按星标排序。

如何看卡片:↓ 每周下载量i★ GitHub 星标i三大支柱:评价 · 检查 · 使用情况i更新 = 最新版本发布到注册中心的时间i

QueryWeaver

An MCP server for Text2SQL: transforms natural language into SQL using graph schema understanding.

作者:FalkorDB正在增长★ 109614个月前更新

在你的电脑上运行✓ falkordb.com

Supabase

MCP server for interacting with the Supabase platform

作者:supabase广泛使用↓ 24.6万/周★ 3018 整个仓库的星标昨天更新

电脑或云端✓ 服务方 · supabase.com

Neon

Official Neon MCP server for managing Neon projects and Lakebase Postgres databases.

作者:neondatabase正在增长★ 66613天前更新

在云端运行✓ 服务方 · neon.com

DBCode

Query and explore 100+ databases through your DBCode connections.

作者:dbcodeio起步阶段↓ 118/周★ 368 整个仓库的星标2个月前更新

在你的电脑上运行✓ 服务方 · dbcode.io

Keboola MCP

Connect your AI assistants to Keboola and expose your data, transformations, SQL queries, ...

作者:keboola正在增长↓ 1421/周★ 843天前更新

电脑或云端✓ 服务方 · keboola.com
与相似项目对比
本项
Multigres
QueryWeaverSupabaseNeonDBCodeKeboola MCP
运行位置需要安装在电脑上需要安装在电脑上云端或安装在电脑上都可以在云端运行,无需安装需要安装在电脑上云端或安装在电脑上都可以
需要密钥是否是否否否
可在 Claude 中按 + 添加否否是是否否
基础检查3/33/35/55/52/35/5
许可证Apache-2.0AGPL-3.0Apache-2.0MITNOASSERTIONMIT
价格登记中未列出费用登记中未列出费用登记中未列出费用登记中未列出费用登记中未列出费用登记中未列出费用

作者的 README

打开 README

按原文从作者的仓库复制。PopNx MCP 没有审查或背书其内容。HTML、图片和脚本已被移除。链接会离开本站。

multigres-mcp

An MCP server for Multigres clusters. It gives an MCP client two groups of tools:

  • Postgres diagnostics through the Multigres gateway: schemas and objects, read-only SQL, query plans with hypothetical indexes, top queries, index advice and a health check. These follow the tools of postgres-mcp.
  • Cluster tools through multiadmin: cluster status, backups, node logs, and in the unrestricted mode switching the primary and starting or expiring backups.

The server is read-only by default. Write tools are registered only in the unrestricted mode.

It has been tested against a local Multigres Docker cluster built from commit 5fa0f2955ede (2026-11-10, PostgreSQL 17.7, two cells) on Linux with Docker Engine. Other setups have not been tested.

Install

Each release has a multigres-mcp- .mcpb file. It is an MCP Bundle: clients that install bundles ask for the settings under "Configuration" and run the server. It is also a zip file whose server/ directory holds binaries for Linux and macOS on amd64 and arm64 and for Windows on amd64, which any other client can run directly.

Build

Requires Go 1.26 or later.

git clone https://github.com/JoongHyuk-Shin/multigres-mcp

cd multigres-mcp go build -o multigres-mcp ./cmd/multigres-mcp

The server talks MCP over standard input and output. ./multigres-mcp --help prints the options.

packaging/build-mcpb.sh builds the release bundle into dist/. It also needs jq, Node.js and openssl.

Configuration

Every option can be given as a flag or as an environment variable. A flag wins over the variable.

FlagVariableDefaultMeaning
--database-urlDATABASE_URInone, requiredConnection string of the Multigres gateway.
--admin-urlMULTIGRES_ADMIN_URLnonemultiadmin HTTP address. The cluster tools are registered only when it is set.
--admin-tokenMULTIGRES_ADMIN_TOKENnoneBearer token for multiadmin started with --enable-auth.
--node-host-mapMULTIGRES_NODE_HOST_MAPnonereported=reachable host pairs, comma separated, for the direct node connections of read_node_log and of the node option of diagnose and get_top_queries. multiadmin reports each node's host as the cluster sees it; this replaces a host that the server cannot reach. Ports are not changed.
--access-modeMULTIGRES_MCP_ACCESS_MODErestrictedrestricted (read-only) or unrestricted (adds the write tools).
--sql-timeoutMULTIGRES_MCP_SQL_TIMEOUT25sStatement timeout for the SQL every tool sends. See "Things to know".

Direct node connections reuse the user, password and database of --database-url and take the host and port from multiadmin.

In the local Docker cluster both nodes report the host localhost, while their Postgres ports are reachable only at the container's address. Find that address in the Multigres checkout with:

docker inspect -f '{{range .NetworkSettings.Networks}}{{.IPAddress}}{{end}}' "$(docker compose ps -q multigres)"

and pass it as --node-host-map localhost= .

Adding it to an MCP client

With Claude Code, for the local Docker cluster (replace 172.18.0.2 with the address found above):

claude mcp add multigres -e DATABASE_URI=postgres://postgres:postgres@localhost:15432/postgres -- /path/to/multigres-mcp --admin-url http://localhost:15000 --node-host-map localhost=172.18.0.2

Other clients take the same command, arguments and environment in their server configuration, for example:

{

"mcpServers": { "multigres": { "type": "stdio", "command": "/path/to/multigres-mcp", "args": ["--admin-url", "http://localhost:15000", "--node-host-map", "localhost=172.18.0.2"], "env": { "DATABASE_URI": "postgres://postgres:postgres@localhost:15432/postgres" } } } }

Tools

ToolModeWhat it does
list_schemasbothList the schemas. The multigres schema is internal to Multigres.
list_objectsbothList the tables, views or sequences of a schema, or every extension in the database.
get_object_detailsbothColumns, constraints and indexes of a table or view, or details of a sequence or extension.
execute_sqlbothRun one read-only statement (SELECT, EXPLAIN of a SELECT, or SHOW). In both modes it only reads.
explain_querybothThe plan of a query, optionally with ANALYZE or with hypothetical indexes. A query with $1 placeholders, as stored in query statistics, gets a generic plan.
get_top_queriesbothThe slowest or most expensive queries, from pg_stat_statements and from the query statistics each gateway keeps, shown separately.
analyze_workload_indexesbothIndex advice for the workload in pg_stat_statements, by comparing planner costs with hypothetical indexes. Nothing is created.
analyze_query_indexesbothThe same for up to 10 given queries.
diagnosebothHealth checks: bloat, vacuum, locks, activity, waits, slow queries, missing indexes, cache, log, index health, sequences, replication and constraints. It starts with the statistics period of the node that answered.
cluster_statusboth, needs --admin-urlCells, databases, the primary and replicas of each shard with LSN and lag, gateways, orchestrators, recent primary changes, and whether the connected user is a superuser.
list_backupsboth, needs --admin-urlBackups of a shard.
verify_backupsboth, needs --admin-urlRun pgBackRest verify on a shard's backups, which checks that the backups and archived WAL in the repository are valid. It does not run a restore.
get_backup_job_statusboth, needs --admin-urlStatus of a backup job.
read_node_logboth, needs --admin-urlThe end of a node's Postgres log, read over a direct connection to that node.
execute_write_sqlunrestrictedRun one statement that may change data or schema, committed if it succeeds.
switch_primaryunrestricted, needs --admin-urlAsk Multigres to switch a shard's primary, then report the old and new primary and terms. Multigres may elect the same node again; the tool says so and does not retry.
create_backupunrestricted, needs --admin-urlStart a backup and return its job id.
expire_backupsunrestricted, needs --admin-urlExpire backups with the retention rules configured in the cluster.
set_postgres_restartsunrestricted, needs --admin-urlTurn automatic Postgres restarts on a node on or off.

That is 14 tools in the restricted mode and 19 in the unrestricted mode, or 9 and 10 without --admin-url. diagnose and get_top_queries take an optional node to read one node directly instead of through the gateway, for example the old primary after a failover.

Safety

The restricted mode does not register any tool that can write. Writing SQL is a tool of its own, execute_write_sql, so a client permission given to execute_sql never covers a write, even after the server is restarted in the unrestricted mode.

Every statement that execute_sql, explain_query and analyze_query_indexes receive passes these checks. They do not rely on each other: checks 1, 3 and 4 each stop a write on their own.

  1. It is parsed with the Multigres parser. It must be exactly one statement, the top statement must be SELECT, EXPLAIN of a SELECT, or SHOW, and the tree must not contain data-changing statements, SELECT INTO or locking clauses. Functions must be on an allow list (the postgres-mcp list with functions that have side effects removed), and a schema-qualified function must be in pg_catalog. The Multigres gateway can send the statement rewritten from its parse tree instead of the text it received, so the rewritten statement must pass this check as well.
  2. It is sent with the extended query protocol, which carries one statement only.
  3. The read-only connection is opened with default_transaction_read_only=on.
  4. It runs in BEGIN TRANSACTION READ ONLY, which is always rolled back.
  5. search_path is pinned, and a statement is not sent if it or its rewritten form calls a function that PostgreSQL resolves through search_path and whose name also exists outside pg_catalog. The rewritten form calls some built-ins without the prefix, such as btrim for TRIM(...) and even for a written pg_catalog.btrim(...). PostgreSQL also resolves the plain call forms overlay(a, b, c) and substring(a, b, c) through search_path, though the Multigres parser reads them as pg_catalog calls.
  6. A statement timeout is set.

This covers the statements the model sends and the functions they call directly. The bodies of objects already in the database (views, functions, operators, policies) are trusted and not checked. Against a production database, connect as a read-only role as well. cluster_status shows whether the connected user is a superuser.

Multigres hands pooled Postgres connections from one client to the next. Within the same transaction, the server removes the hypothetical indexes and session advisory locks a tool call may have left on its connection. If that cleanup fails, it ends its own Postgres session rather than hand the state on. execute_write_sql rejects transaction control, session-level SET and RESET, multigres.* settings, hypopg functions, and statements that leave session state behind (temporary objects, PREPARE, LISTEN, DECLARE ... WITH HOLD, LOAD, DISCARD, DO). Session settings (set_config(..., false)) and the random seed (setseed) changed inside the body of a function or trigger are not removed and can reach the next client of that connection; like the other object bodies, they are trusted.

Direct node connections run fixed queries only, never SQL from the model.

The multiadmin address (in full and as host:port), the admin token and the database password are removed from tool results and error messages. The removal replaces text, so a password that is a common word is masked wherever that word appears. A password equal to the user or database name is not masked, because results show those names; the server prints a warning when it starts.

Things to know

  • --sql-timeout defaults to 25s because the multipooler ends a transaction's connection when one statement runs past --connpool-user-reserved-inactivity-timeout (default 30s). To use a longer timeout, raise that pooler setting too.
  • The results of execute_sql and execute_write_sql end with a line naming the settings the server set for that call only (statement_timeout, lock_timeout, and for reads search_path), and the statement_timeout its own session had before. The gateway enforces statement_timeout itself without setting it on the node, so the node's pg_settings shows 0 for it while SHOW through the gateway answers with the gateway's value.
  • Cumulative statistics are kept per node. After a failover the new primary's statistics do not include what happened on the old primary. The tools that use statistics start with the period they cover; the node option of diagnose and get_top_queries reads another node.
  • Index sizes in the advice are hypopg estimates and ignore btree deduplication. On a column with many repeated values the estimate can be several times the real size (on 200,000 rows with 1,000 distinct values: 4,644,864 bytes estimated, 1,384,448 bytes real).
  • The gateway truncates the query text it keeps to --query-metrics-sql-max-bytes (default 4096) without a marker. Plans and index advice use the full pg_stat_statements text or the full statement you give.
  • get_top_queries shows the first 2,000

只显示了开头部分;其余内容请在仓库中阅读