PostgreSQL MCP Server

@jamesg31

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

jamesg31

关于 PostgreSQL MCP Server

暂无概览

#postgresql #database #mcp-server

PostgreSQL MCP Server 配置

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

{
  "mcpServers": {
    "mcp-server-postgres": {
      "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. It enables LLMs to inspect database schemas and execute read-only SQL queries.

How to use PostgreSQL?

Configure the server in the mcpServers section of your claude_desktop_config.json using either Docker or NPX. Provide a PostgreSQL connection URL (e.g., postgresql://localhost/mydb). The server exposes a query tool for read-only SQL execution and automatically discovers table schemas as resources.

Key features of PostgreSQL

Execute read-only SQL queries against the database
Automatically discover table schemas (column names, data types)
All queries run within a READ ONLY transaction
Schema information exposed as JSON resources
Supports Docker and NPX deployment methods

Use cases of PostgreSQL

Let an LLM explore and query a PostgreSQL database safely
Inspect database schema without write access
Integrate read-only database queries into AI workflows

常见问题

What operations does the server allow?

The server only permits read-only SQL queries executed within a READ ONLY transaction. No write operations are possible.

How do I connect to a PostgreSQL database?

Use a PostgreSQL connection URL such as `postgresql://user:password@host:port/db-name`. For Docker on macOS, use `host.docker.internal` if the database runs on the host.

What schema information is exposed?

Table schemas are provided as JSON resources at `postgres://<host>/<table>/schema`, including column names and data types. Schemas are automatically discovered from database metadata.

What are the runtime requirements?

The server can be run via Docker (using the `mcp/postgres` image) or via NPX (using `@modelcontextprotocol/server-postgres`). No additional dependencies are listed beyond a PostgreSQL connection.

Is the server licensed?

Yes, it is licensed under the MIT License.

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

NPILayer

Healthcare provider data for AI assistants, from the official CMS NPPES dataset (updated weekly). Look up any NPI (active or deactivated), search providers and organizations by name, city, state, ZIP, taxonomy code or pl

MCP DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.