PostgreSQL MCP Server

@pyljain

代码仓库

基本信息

分类

开发工具

传输方式

stdio

作者

pyljain

关于 PostgreSQL MCP Server

暂无概览

PostgreSQL MCP Server 配置

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

{
  "mcpServers": {
    "mcp_server_template": {
      "command": "docker",
      "args": [
        "build",
        "-t",
        "mcp/postgres",
        "-f",
        "src/postgres/Dockerfile",
        "."
      ]
    }
  }
}

PostgreSQL MCP Server 工具

Execute read-only SQL queries against the connected database

概览

What is PostgreSQL?

A Model Context Protocol server that provides read-only access to PostgreSQL databases, enabling LLMs to inspect database schemas and execute read-only SQL queries.

How to use PostgreSQL?

Use the server with Claude Desktop by adding configuration to claude_desktop_config.json. Run via Docker (docker run -i --rm mcp/postgres postgresql://...) or NPX (npx -y @modelcontextprotocol/server-postgres postgresql://...). Replace the connection string with your database URL.

Key features of PostgreSQL

Execute read-only SQL queries via the query tool.
All queries run within a READ ONLY transaction.
Automatically discover table schemas as JSON resources.
Schema resources include column names and data types.
Connect to any PostgreSQL database via connection string.

Use cases of PostgreSQL

Let an LLM explore a database schema before generating queries.
Allow an LLM to run safe, read-only analytical queries.
Provide structured schema context to improve LLM query accuracy.

常见问题

What exactly does this MCP server do?

It provides read-only database access: it can inspect schemas and execute read-only SQL queries, but never writes data.

How do I connect to my PostgreSQL database?

Provide a PostgreSQL connection URL (e.g., `postgresql://user:password@host:port/db-name`) as a command argument when using Docker or NPX.

Is the server read-only?

Yes. All queries are executed within a READ ONLY transaction, preventing any modifications.

What are the runtime requirements?

The server can be run via Docker (using the `mcp/postgres` image) or Node.js via NPX (using the `@modelcontextprotocol/server-postgres` package). No other dependencies are listed.

How is authentication handled?

Authentication is managed through the PostgreSQL connection URL, which can include username and password directly in the URL string.

开发工具分类下的更多 MCP 服务器

Casefile

azimov777

One case file per task — shared by every session, agent and person that touches it. Self-hosted MCP server and live board. MIT.

OrangePro

Aamir Siddiqui

OrangePro local-first CLI + MCP server for behavior mapping, grounded test generation, and dynamic proof.

SSH MCP Server

hypnosis

SSH MCP server for AI agents: remote commands, file transfer, log search and server audits through OpenSSH.

Collide MCP

Lithometric Inc. | Collide Inc.

Collide is the multiplayer layer for AI coding agents, and it pays for itself. Expert orchestration across every agent on your repo saves teams tens to hundreds of dollars a day in token burn. Run Claude Code, Codex, Cu

ReactVision MCP

ReactVision, Inc

Most MCP servers hand your agent documentation. This one hands it a renderer. Write a single React Native codebase that ships native AR to phones and VR to headsets, then let your agent validate every prop, check each pl