PostgreSQL Full Access MCP Server

@syahiidkamil

About PostgreSQL Full Access MCP Server

Full access postgres mcp server

Config

Add this server to your MCP-compatible client using the configuration below.

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

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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

Frequently asked questions

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

Comments

Basic information

More Databases MCP servers

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412