PostgreSQL MCP by InsightfulPipe

com.insightfulpipe由 insightfulpipe.com 发布v1.0.0更新于 Nov 4, 2026

Hosted PostgreSQL MCP server for Claude, ChatGPT and Cursor, with each action switched per account.

已验证Streamable HTTP可网页运行数据库数据与分析

概览

AI 生成的概览

托管式 PostgreSQL MCP 服务器，让 AI 助手浏览模式与表、查看元数据、执行 SQL 并检查自有数据库的健康状况。

可以做什么
  • 列出所连数据库中的模式、表、视图、序列和扩展
  • 查看表与视图的结构：列、约束、索引、行数估算和大小
  • 执行 SQL 语句，并获取查询的 EXPLAIN 执行计划
  • 查看数据库健康状况（连接数、vacuum 时长、复制槽、缓存命中率）以及 pg_stat_statements 中最慢的查询
适用场景
适合希望无需本地安装即可让助手探索和查询 PostgreSQL 数据库的场景，也适合需要按账号控制可用操作、包括只读连接的团队。
运行要求
需将远程端点 postgresql.insightfulmcp.com 添加为 Claude、ChatGPT（开发者模式）、Claude Code 或 Cursor 中的自定义连接器。需要 OAuth 登录 InsightfulPipe 账号，服务器以某个 PostgreSQL 角色连接你的数据库，该角色的 GRANT/REVOKE 权限决定只读或读写。7 天试用后需付费订阅 InsightfulPipe 套餐。
安装前请注意
服务器会对你的数据库执行 SQL，读写连接可能修改或删除数据；破坏性操作默认关闭，非必要不要开启。只读或读写能力取决于连接器所用数据库角色的权限，建议使用最小权限角色。数据库通过第三方托管服务访问，使用需付费订阅。

安装

在 SourceWeft 中

  1. 打开 控制台中的 PostgreSQL MCP by InsightfulPipe，将其添加到工作区。
  2. 连接 所需的 凭据。它们会被私密存储，绝不会在公开页面上展示。
  3. 为需要使用其工具的对话启用该服务。

Web executable，通过 Streamable HTTP。 远程服务在工作区中配置后即可从网页运行时运行。

交给智能体安装

把这段提示词粘贴到 Claude Code、Codex、Cursor 等智能体，或 SourceWeft 对话中。智能体会读取该服务器的安装指南，先向你展示发布者、端点和登录方式，经你同意后再把它添加到你的客户端。密钥不会写进任何命令。

阅读 https://sourceweft.com/mcp/com.insightfulpipe%2Fpostgresql/install.md，并按其中说明把这个 MCP 服务器接入我的客户端。修改任何配置之前，先告诉我它的发布者、端点和登录方式，等我确认。不要把 API 密钥写进命令或我会提交的文件；问我密钥应从哪里获取。

查看智能体所依据的安装指南

其他 MCP 客户端

把它添加到你客户端的 mcpServers 配置中。 客户端会在首次连接时完成 OAuth 登录。

{
  "mcpServers": {
    "postgresql-by-insightfulpipe": {
      "type": "http",
      "url": "https://postgresql.insightfulmcp.com/"
    }
  }
}

README

PostgreSQL MCP Server by Insightful Pipe

[MCP Compatible] [Insightful Pipe] [License]

Connect PostgreSQL to AI assistants: schemas, tables, SQL and database health.

Part of the Insightful Pipe MCP Server Collection — use PostgreSQL from Claude, ChatGPT, Cursor, and other AI assistants through the Model Context Protocol (MCP).

[PostgreSQL MCP Server]

MCP Server URL

https://postgresql.insightfulmcp.com/

What is PostgreSQL MCP?

PostgreSQL MCP is a remote Model Context Protocol server hosted by InsightfulPipe. Browse schemas and tables, inspect columns, run SQL, and read pg_stat insights against your own PostgreSQL database. Read vs. read-write is decided by the GRANT/REVOKE privileges on the role this connector logs in as.

Installation

Claude

  1. Copy the MCP Server URL: https://postgresql.insightfulmcp.com/
  2. Open Claude Connectors Settings
  3. Scroll to the bottom and click Add custom connector
  4. Paste the URL and click Add
  5. Click Connect and sign in to InsightfulPipe if asked. Claude then lists the connector as connected.

ChatGPT

Custom MCP servers are added through ChatGPT's Developer mode. Availability depends on your ChatGPT plan, and workspace admins may need to allow it.

  1. Turn on Developer mode in ChatGPT settings
  2. Create a new app for a remote MCP server and paste the URL: https://postgresql.insightfulmcp.com/
  3. Sign in to InsightfulPipe if asked. The connection finishes as soon as you are signed in.

See OpenAI's guide: Developer mode and MCP apps in ChatGPT

Claude Code

bash
claude mcp add --transport http postgresql https://postgresql.insightfulmcp.com/

Cursor

Add the server to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (one project):

json
{  "mcpServers": {    "postgresql": {      "url": "https://postgresql.insightfulmcp.com/"    }  }}

When Cursor shows Needs authentication, click Connect and sign in to InsightfulPipe if asked.

Available Actions

8 actions: 7 read, 1 write.

Read Actions (7)

ActionDescription
analyze_db_healthReport database health (connections, vacuum age, replication slots, cache hit rates, invalid constraints)
explain_queryReturn the EXPLAIN plan for a query
get_table_metadataFull metadata for a table or view: columns, constraints, indexes, estimated row count, size
get_table_schemaReturn the column list (name, data_type, is_nullable, default) for a table or view
get_top_queriesSlowest or most resource-intensive queries from the pg_stat_statements extension
list_schemasList all schemas in the connected database
list_tablesList tables, views, sequences, or extensions in a schema

Write Actions (1)

ActionDescription
run_queryExecute a SQL statement against the connected database

Control What Your AI Can Do

You decide what AI agents can do with each connected account:

  • Turn individual actions on or off for every connected account, so agents only see the actions you allow.
  • Connect as Read-only or Read & Write. A read-only connection can only enable read actions.
  • Destructive actions stay off by default. Actions such as deletes are disabled until an admin enables them.
  • Team access per account. Restricted team members only use the accounts they are granted, with the read actions enabled on them.

Usage Examples

"List the tables in the public schema"
"Show the schema of the orders table"
"Check my database health"

Pricing

The PostgreSQL MCP server is included in every InsightfulPipe plan, together with all other MCP servers and the CLI. Plans start at $29.99/month, and you can try it for 7 days. See insightfulpipe.com/pricing for current plans.

Explore More MCP Servers by Insightful Pipe

Visit insightfulpipe.com/mcp-servers to discover our full collection of MCP servers.

View All MCP Servers →

Resources

Support

Insightful Pipe — AI-powered marketing analytics through MCP servers. Explore all integrations →

License

MIT License - see LICENSE for details.

来源：README.md，提交 4306548

工具

0
该服务器需要登录，因此 SourceWeft 无法在没有账号的情况下读取其工具，也未收录。已连接账号所能看到的内容可能因账号及其权限而异。

版本历史

1
  1. v1.0.0最新Oct 21, 2026

评分

已满足适用检查项的 85%

该评分衡量此收录条目的完整程度，依据注册中心条目、端点与公开来源计算得出。它不是对服务器本身的评价，也不表示服务器安全或当前可用：可连通性是带日期的检查结果，评分也不包含安装量或用户评价。

  • 近 30 天内可连通必需25 分
  • 已声明认证方式必需10 分
  • 已列出工具15 分

    请让服务器在无凭据时响应 tools/list，或发布可在沙箱中无凭据启动的软件包。

  • 描述必需15 分
  • 图标10 分
  • 文档15 分
  • 许可证10 分