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

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

Multi Database MCP Server

FreePeak

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

397

Snowflake MCP Server

isaacwasserman

185

mcp-server-duckdb

ktanaka101

A Model Context Protocol (MCP) server implementation for DuckDB, providing database interaction capabilities

177

Redis

modelcontextprotocol

Model Context Protocol Servers

88.2K

mcp_mysql_server

xwb602625136

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能；还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245