PostgreSQL

Name: PostgreSQL
Author: pyljain

@pyljain

リポジトリ

PostgreSQL について

概要はまだありません

基本情報

カテゴリ

開発者ツール

ランタイム

node

トランスポート

stdio

公開者

pyljain

設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

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

ツール

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.

FAQ from PostgreSQL

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.