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 服务器

Multi Database MCP Server

FreePeak

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

397

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers

88.1K

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.

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note