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.