PostgreSQL Full Access MCP Server

@syahiidkamil

リポジトリ

基本情報

カテゴリ

データベース

トランスポート

stdio

作者

syahiidkamil

PostgreSQL Full Access MCP Server について

Full access postgres mcp server

PostgreSQL Full Access MCP Server の設定

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

{
  "mcpServers": {
    "mcp-postgres-full-access": {
      "command": "docker",
      "args": [
        "build",
        "-t",
        "mcp-postgres-full-access",
        "."
      ]
    }
  }
}

PostgreSQL Full Access MCP Server のツール

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

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

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

概要

What is PostgreSQL Full Access MCP Server?

A Model Context Protocol server that provides full read-write access to PostgreSQL databases. Unlike the official read‑only MCP PostgreSQL server, this implementation lets LLMs query and modify database content with transaction management and safety controls.

How to use PostgreSQL Full Access MCP Server?

Install via npm/npx, then configure Claude Desktop by editing claude_desktop_config.json with the command npx -y mcp-postgres-full-access "postgresql://..." and optional environment variables. Write operations require explicit user approval via a two‑step commit process. The server can also be run in a Docker container.

Key features of PostgreSQL Full Access MCP Server

Full read-write access to PostgreSQL databases
Transaction management with explicit commit and rollback
Safety controls: timeouts, automatic rollback, read-only enforcement
Enhanced schema details: primary keys, foreign keys, indexes
Two-step commit process requiring user approval
Configurable environment variables for timeouts and limits

Use cases of PostgreSQL Full Access MCP Server

Create new tables and populate them with data via natural language
Perform read‑only data analysis with automatic safe execution
Modify existing data (INSERT, UPDATE, DELETE) with user approval
Execute schema changes (CREATE, ALTER, DROP) with safety controls
Run maintenance commands like VACUUM and ANALYZE

よくある質問

How does this server differ from the official MCP PostgreSQL server?

It provides full read‑write access (not just read‑only) and includes enhanced schema information and explicit transaction management with safety controls.

What safety mechanisms are included?

All write operations run in isolated transactions with configurable timeouts. Changes require explicit commit approval after review. Read‑only queries are automatically enforced.

How do I configure environment variables?

Add an `"env"` object to the server configuration in `claude_desktop_config.json` and set variables like `TRANSACTION_TIMEOUT_MS`, `MAX_CONCURRENT_TRANSACTIONS`, and `PG_STATEMENT_TIMEOUT_MS`.

Can I run the server in Docker?

Yes. Build the image with `docker build -t mcp-postgres-full-access .` and run with the connection string: `docker run -i --rm mcp-postgres-full-access "post