pgEdge MCP Server for Postgres

@pgedge

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

pgedge

提交者

Sarah Conway

关于 pgEdge MCP Server for Postgres

The pgEdge Postgres Model Context Protocol (MCP) server enables SQL queries against PostgreSQL databases through MCP-compatible clients like Claude Desktop. The Natural Language Agent provides supporting functionality that allows you to use natural language to form SQL queries.

#postgres #postgresql #database #open-source #oss

pgEdge MCP Server for Postgres 配置

暂无标准配置

该服务器的 README 中没有可解析的 MCP 配置块，请前往代码仓库查看安装说明。

代码仓库

pgEdge MCP Server for Postgres 工具

工具列表暂未提供

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

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

概览

What is pgEdge MCP Server for Postgres?

The pgEdge MCP Server for Postgres enables SQL queries against PostgreSQL databases through MCP‑compatible clients such as Claude Desktop. Its Natural Language Agent lets you describe queries in plain English, which the server translates into SQL.

How to use pgEdge MCP Server for Postgres?

Clone the repository, run make build, then configure your MCP client (e.g., Claude Desktop) with the path to the binary. Provide database connection details via environment variables (PGHOST, PGPORT, PGDATABASE, PGUSER, PGPASSWORD) or a .pgpass file. The server can also be run as a standalone HTTP server or deployed with Docker.

Key features of pgEdge MCP Server for Postgres

Read‑only protection – all queries run in read‑only transactions
Resources, tools, and prompts for database interaction
Production Go CLI client with Anthropic prompt caching (90% cost reduction)
HTTP/HTTPS mode with token authentication and TLS support
Web‑based management interface built with React
Docker support for containerized deployment and hot‑reload of auth files

Use cases of pgEdge MCP Server for Postgres

Schema discovery – retrieve table lists and column details with natural language
Data analysis – ask for top customers, slow shipping orders, or aggregation queries
System monitoring – check current connections, dead tuples, and cache hit ratios
Internal developer tools – safely query production‑like databases without write access

常见问题

What databases does this server work with?

It connects to any PostgreSQL database using standard `PG*` environment variables.

Is the server safe for production or public‑facing applications?

No. The code is pre‑release and must not be put into production without thorough testing. It provides LLMs read access to your entire schema and data, so it should only be used for internal tools, developer workflows, or trusted environments.

What transports and authentication are supported?

The server supports stdio (subprocess) and HTTP/HTTPS transports. HTTP mode supports token‑based authentication and TLS encryption.

What runtime dependencies are required?

A PostgreSQL database and a running MCP client (e.g., Claude Desktop, the Go CLI client, or a custom HTTP client). LLM API keys (Anthropic, OpenAI, or Ollama) are needed for the Natural Language Agent features.

Are there any known limitations?

All queries are executed in read‑only transactions – write operations are not allowed. The server is currently in pre‑release status and may not be suitable for all workloads.

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

Chroma MCP Server

chroma-core

A Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma

569

Postgres Mcp

crystaldba

Postgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.

3.0K

Schemity

tbson

Local database MCP server: your agent sees a migration's impact before it runs, for PostgreSQL, MySQL, SQL Server and SQLite, with no database credentials.