MCP Server Postgres

@yuru-sha

リポジトリ

基本情報

カテゴリ

データベース

ライセンス

MIT

トランスポート

stdio

作者

yuru-sha

MCP Server Postgres について

MCP Server for PostgreSQL databases

MCP Server Postgres の設定

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

{
  "mcpServers": {
    "mcp-server-postgres-yuru-sha": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "mcp/postgres",
        "postgresql://host:port/dbname"
      ]
    }
  }
}

MCP Server Postgres のツール

ツール一覧はまだありません

この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

What is mcp-server-postgres?

mcp-server-postgres is a Model Context Protocol (MCP) server for PostgreSQL databases. It lets LLMs inspect database schemas and execute read-only queries, providing safe, read-only access to PostgreSQL through the MCP interface.

How to use mcp-server-postgres?

Install via Docker (build with make docker and run with docker run -i --rm mcp/postgres postgresql://host:port/dbname) or install via Smithery (npx -y @smithery/cli install @yuru-sha/mcp-server-postgres --client claude). For Claude Desktop, add a configuration entry to claude_desktop_config.json specifying the Docker command and connection URL.

Key features of mcp-server-postgres

Read-only access to PostgreSQL databases
Schema inspection capabilities
Queries executed within READ ONLY transactions
Docker support for easy deployment
Available as an NPM package
Secure by default—enforces read-only operations

Use cases of mcp-server-postgres

Let an LLM explore and describe table structures in a PostgreSQL database
Generate safe, read-only SQL queries for data analysis
Provide database context to AI assistants without risk of data modification
Integrate with Claude Desktop for interactive database schema inspection
Use in development environments to allow AI tools to examine database design

よくある質問

What type of database access does mcp-server-postgres provide?

It provides read-only access only. All queries are executed within READ ONLY transactions to protect your data.

How do I connect mcp-server-postgres to my PostgreSQL database?

Use a connection URL in the format `postgresql://[user][:password]@host[:port]/database`. Replace `/database` with your database name.

What are the runtime requirements?

You need either Docker (to run the provided Docker image) or Node.js (if installing via Smithery/npm). A running PostgreSQL instance is required.

Can mcp-server-postgres modify my database?

No. The server enforces read-only queries; any write operations are blocked by the READ ONLY transaction mode.

How does mcp-server-postgres handle authentication?

Authentication is handled through the PostgreSQL connection string, which can include username and password. For enhanced security, creating a dedicated read-only PostgreSQL user is recommended.