mcp-server-postgres

Name: mcp-server-postgres
Author: yuru-sha

@yuru-sha

代码仓库

关于 mcp-server-postgres

MCP Server for PostgreSQL databases

基本信息

分类

数据库

许可证

MIT

运行时

node

传输方式

stdio

发布者

yuru-sha

配置

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

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

工具

未检测到工具

工具是从 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

FAQ from mcp-server-postgres

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.