Advertise
MCP.so
Sign In

PostgreSQL Full Access MCP Server

@syahiidkamil

Repository

Basic information

Category

Databases

Transports

stdio

Author

syahiidkamil

About PostgreSQL Full Access MCP Server

Full access postgres mcp server

PostgreSQL Full Access 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",
        "."
      ]
    }
  }
}

PostgreSQL Full Access MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

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

Frequently asked questions

1

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.

2

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.

3

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`.

4

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

More Databases MCP servers

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K

golfdata.online - Verified Golf Clubs

golfdata.online

Verified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes

Xata MCP Server

The Xata MCP server lets AI assistants and agents interact with your Xata organizations, projects, and Postgres database branches.

Local YDB MCP

astandrik

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

4

Elasticsearch MCP Server

elastic

685
Advertise