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

数据库分类下的更多 MCP 服务器

Sail MCP Server for Spark SQL

lakehq

Drop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.

3.1K

Neon MCP Server

neondatabase

MCP server for interacting with Neon Management API and databases

617

MCP DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.

Postgres Mcp

crystaldba

Postgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.

3.0K

Local YDB MCP

astandrik

Safety-first stdio MCP server with 38 tools for operating Docker-based local-ydb environments locally or over SSH.