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.

「開発者ツール」の他のコンテンツ

Hermoso

Hermoso is an AI marketing agent and AI ad generator you run from your AI agent: a remote MCP server that researches the ads already winning in your market, makes image and video ads and organic posts in your brand, publ