接入你的智能体
發布者自己的指令。不是 PlugMCP 端點。
用我們的金鑰與日誌託管一份副本。
docker run -i --rm ghcr.io/pgedge/postgres-mcp:latestClaude Code 沒有本機指令的安裝連結。複製下方指令並在終端機中執行。
claude mcp add pgedge-pgedge-postgres-mcp -- docker run -i --rm ghcr.io/pgedge/postgres-mcp:latest在終端機中執行。
{ "mcpServers": { "pgedge-pgedge-postgres-mcp": { "command": "docker", "args": [ "run", "-i", "--rm", "ghcr.io/pgedge/postgres-mcp:latest" ] } }}claude_desktop_config.json
遠端 URL 還是本機指令? 兩種安裝方式的差異
The pgEdge Postgres Model Context Protocol (MCP) server enables SQL queries against PostgreSQL databases through MCP-compatible clients. The Natural Language Agent provides supporting functionality that allows you to use natural language to form SQL queries.
Supported Versions: PostgreSQL 14 and higher.
NOT FOR PUBLIC-FACING APPLICATIONS: This MCP server provides LLMs with read access to your entire database schema and data. It should only be used for internal tools, developer workflows, or environments where all users are trusted. For public-facing applications, consider the pgEdge RAG Server instead. See the Choosing the Right Solution guide for details.
The Quick Start guide covers installation and setup for all supported clients:
For a guided demo with sample data, see the Quickstart Demo with Northwind.
The project uses golangci-lint v1.x. Install it with:
go install github.com/golangci/golangci-lint/cmd/golangci-lint@latest
Note: The configuration file .golangci.yml
is compatible with golangci-lint v1.x (not v2).
git clone https://github.com/pgEdge/pgedge-postgres-mcp.git
cd pgedge-postgres-mcp
make build
# Run all tests
make test
# Run server tests with a database
export TEST_PGEDGE_POSTGRES_CONNECTION_STRING=\
"postgres://localhost/postgres?sslmode=disable"
go test ./...
# Run with coverage
go test -v -cover ./...
# Run linting
make lint
The web UI has a comprehensive test suite. See web/TEST_SUMMARY.md for details.
cd web
npm test # Run all tests
npm run test:watch # Watch mode
npm run test:coverage # With coverage
See the Security Guide for comprehensive security documentation.
Tools not visible in Claude Desktop?
Database connection errors?
pg_isreadySee the Troubleshooting Guide for detailed solutions.
To report an issue with the software, visit: GitHub Issues
For more information, visit docs.pgedge.com
This project is licensed under the PostgreSQL License.
pgEdge MCP Server. A PostgreSQL MCP server with a Natural Language Agent CLI and Web UI.
{ "mcpServers": { "pgedge-pgedge-postgres-mcp": { "command": "docker", "args": [ "run", "-i", "--rm", "ghcr.io/pgedge/postgres-mcp:latest" ] } }}工具
尚無工具清單。遠端伺服器會在首次健康檢查後取得工具清單。
常見問題
在本頁複製適用於 Cursor、Claude Desktop、Claude Code 或 VS Code 的 stdio 設定。它使用發布者的安裝方式,而不是 PlugMCP 代理伺服器。
這筆記錄未列出必要的環境變數。
Pgedge Postgres 透過 stdio 在本機執行。
上次檢查時間:2026-10-27。 pgEdge MCP Server. A PostgreSQL MCP server with a Natural Language Agent CLI and Web UI.