AnythingMCP Cloud 已上线 — 7 天免费试用
AnythingMCP
Connector guide1-minute read8 MCP toolsEN · DE · IT

Postgres 接入 MCP — 从任意 AI 代理驱动 Postgres

Direct Postgres connection over libpq — execute SELECT/EXPLAIN queries, list schemas/tables/indexes, sample rows, fetch column stats. Read-only role recommended for AI use.

HCBy HelpCode teamUpdated 1 min read Open source on GitHub
Install Postgres on Cloud — free trialRead the step-by-step guide

No credit card · 7-day trial · Self-host alternative available

Postgres

MCP connector

Postgres

Direct Postgres connection over libpq — execute SELECT/EXPLAIN queries, list schemas/tables/indexes, sample rows, fetch column stats. Read-only role recommended for AI use.

Tools

8

Region

SELF-HOST

Category

Data & Analytics

Authentication

Basic Auth

Required env vars

POSTGRES_URL
Install in one click on Cloud

7-day free trial · No credit card

  • 7-day free trial
    No credit card required
  • GDPR & SOC 2 ready
    EU data residency, audit logs
  • Open-source on GitHub
    Source-available BSL-1.1
  • Works with ChatGPT, Claude, Gemini
    Any MCP-compatible client

Skip the install. Get this working in under 2 minutes.

Start a free trial on cloud.anythingmcp.com, add the Postgres in one click, then point your AI client (Claude, ChatGPT, Copilot or Cursor) at the generated MCP endpoint. No Docker, no git clone, zero engineering experience required.

Start free trial

Summary

Direct Postgres connection over libpq — execute SELECT/EXPLAIN queries, list schemas/tables/indexes, sample rows, fetch column stats. Read-only role recommended for AI use.

试试这样问

Postgres 的示例提示

点击任意提示即可复制，然后粘贴到 Claude、ChatGPT、Cursor、Gemini、Copilot 或 OpenClaw 中，在该连接器上运行。

Postgres · 通过 MCP 实时
分享
Opus 4.7

Claude 是 AI，可能会出错。请核对回答。

💡 无需安装? 直接使用 cloud.anythingmcp.com。 登录、点击 Connectors → Postgres、粘贴凭证、生成 MCP API key — 完成。无 Docker、无 git clone、无本地服务器。

Postgres

Direct Postgres connection over libpq — execute SELECT/EXPLAIN queries, list schemas/tables/indexes, sample rows, fetch column stats. Read-only role recommended for AI use.

设置

前提条件: POSTGRES_URL

本地安装连接器

git clone https://github.com/HelpCode-ai/anythingmcp.git
cd anythingmcp && docker compose up -d

打开 http://localhost:3000/connectors/store，选择 Postgres 并填入前提条件中列出的环境变量。

可用工具

下一步

这份指南对你有帮助吗?

Ready to ship

Your Postgres agent is one click away.

Install the connector, paste the key, prompt any MCP client. Free for 7 days, no credit card.

Start free on CloudSelf-host with DockerTalk to sales

相关指南

connectors

如何将 Postgres 连接到 ChatGPT — 通过 MCP

Direct Postgres connection over libpq — execute SELECT/EXPLAIN queries, list schemas/tables/indexes, sample rows, fetch column stats. Read-only role recommended for AI use.

connectors

如何将 Postgres 连接到 Claude — 通过 MCP

Direct Postgres connection over libpq — execute SELECT/EXPLAIN queries, list schemas/tables/indexes, sample rows, fetch column stats. Read-only role recommended for AI use.

connectors

如何将 Postgres 连接到 Cursor — 通过 MCP

Direct Postgres connection over libpq — execute SELECT/EXPLAIN queries, list schemas/tables/indexes, sample rows, fetch column stats. Read-only role recommended for AI use.

connectors

如何将 Postgres 连接到 Gemini — 通过 MCP

Direct Postgres connection over libpq — execute SELECT/EXPLAIN queries, list schemas/tables/indexes, sample rows, fetch column stats. Read-only role recommended for AI use.

connectors

Asana 接入 MCP — 从任意 AI 代理驱动 Asana

Asana REST API — tasks, projects, sections, milestones, users, teams. Triage assignment, change due dates, query workload, scan project status updates. PAT auth.

connectors

GitHub 接入 MCP — 从任意 AI 代理驱动 GitHub

GitHub REST + GraphQL — repos, issues, PRs, actions, search, code review, security advisories. Read/write across the user, org, and enterprise scopes via a fine-grained PAT.