MCP Server Postgres

@yuru-sha

代码仓库

基本信息

分类

数据库

许可证

MIT

传输方式

stdio

作者

yuru-sha

关于 MCP Server Postgres

MCP Server for PostgreSQL databases

MCP Server Postgres 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "mcp-server-postgres-yuru-sha": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "mcp/postgres",
        "postgresql://host:port/dbname"
      ]
    }
  }
}

MCP Server Postgres 工具

工具列表暂未提供

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

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

概览

What is mcp-server-postgres?

mcp-server-postgres is a Model Context Protocol (MCP) server for PostgreSQL databases. It lets LLMs inspect database schemas and execute read-only queries, providing safe, read-only access to PostgreSQL through the MCP interface.

How to use mcp-server-postgres?

Install via Docker (build with make docker and run with docker run -i --rm mcp/postgres postgresql://host:port/dbname) or install via Smithery (npx -y @smithery/cli install @yuru-sha/mcp-server-postgres --client claude). For Claude Desktop, add a configuration entry to claude_desktop_config.json specifying the Docker command and connection URL.

Key features of mcp-server-postgres

Read-only access to PostgreSQL databases
Schema inspection capabilities
Queries executed within READ ONLY transactions
Docker support for easy deployment
Available as an NPM package
Secure by default—enforces read-only operations

Use cases of mcp-server-postgres

Let an LLM explore and describe table structures in a PostgreSQL database
Generate safe, read-only SQL queries for data analysis
Provide database context to AI assistants without risk of data modification
Integrate with Claude Desktop for interactive database schema inspection
Use in development environments to allow AI tools to examine database design

常见问题

What type of database access does mcp-server-postgres provide?

It provides read-only access only. All queries are executed within READ ONLY transactions to protect your data.

How do I connect mcp-server-postgres to my PostgreSQL database?

Use a connection URL in the format `postgresql://[user][:password]@host[:port]/database`. Replace `/database` with your database name.

What are the runtime requirements?

You need either Docker (to run the provided Docker image) or Node.js (if installing via Smithery/npm). A running PostgreSQL instance is required.

Can mcp-server-postgres modify my database?

No. The server enforces read-only queries; any write operations are blocked by the READ ONLY transaction mode.

How does mcp-server-postgres handle authentication?

Authentication is handled through the PostgreSQL connection string, which can include username and password. For enhanced security, creating a dedicated read-only PostgreSQL user is recommended.