PostgreSQL Full Access MCP Server

Name: PostgreSQL Full Access MCP Server
Author: syahiidkamil

@syahiidkamil

リポジトリ

PostgreSQL Full Access MCP Server について

Full access postgres mcp server

基本情報

カテゴリ

データベース

ランタイム

node

トランスポート

stdio

公開者

syahiidkamil

設定

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

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

ツール

ツールは検出されませんでした

ツールは 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

FAQ from PostgreSQL Full Access MCP Server

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