Advertise
MCP.so
Sign In

PostgreSQL Full Access MCP Server

@kamusis

Repository

Basic information

Category

Databases

Transports

stdio

Author

kamusis

About PostgreSQL Full Access MCP Server

A fully featured PostgreSQL server adapter for the Model Context Protocol (MCP), providing robust read/write access and enhanced schema metadata for LLM and AI-powered applications. Supports full SQL DML/DDL operations.

PostgreSQL Full Access MCP Server config

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

{
  "mcpServers": {
    "mcp-postgres-full-access-extended": {
      "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. It is an independently maintained fork of the original mcp-postgres-full-access, enabling LLMs to both query and modify database content with transaction management and safety controls.

How to use PostgreSQL Full Access MCP Server?

Install via npx and configure Claude Desktop by editing claude_desktop_config.json with the server command and connection string. Use environment variables to customize timeouts and safety limits. The server can also be run in a Docker container. Example configurations are provided in the README.

Key features of PostgreSQL Full Access MCP Server

  • Execute DML, DDL, DCL, and TCL operations with safety controls
  • Rich schema information including primary keys, foreign keys, and indexes
  • Transaction management with explicit commit and rollback
  • SQL query classification and automatic timeout monitoring
  • Two-step commit process requiring user approval
  • Docker support for containerized deployment

Use cases of PostgreSQL Full Access MCP Server

  • Create new tables and insert data with user approval
  • Perform read-only data analysis and reporting
  • Manage database objects and schema changes
  • Review and safely commit write transactions after verification

Frequently asked questions

1

How does PostgreSQL Full Access MCP Server differ from the official MCP PostgreSQL server?

The official server is read-only; this server provides full read-write access with transaction management and safety controls.

2

What environment variables are available?

Key variables include `TRANSACTION_TIMEOUT_MS`, `MAX_CONCURRENT_TRANSACTIONS`, `ENABLE_TRANSACTION_MONITOR`, `PG_STATEMENT_TIMEOUT_MS`, `PG_MAX_CONNECTIONS`, and `MONITOR_INTERVAL_MS`. Defaults are specified in the README.

3

What permissions should I grant the database user?

Create a dedicated user with restricted grants. Avoid superuser access. For example, grant SELECT on all tables and INSERT/UPDATE/DELETE only on specific tables as needed.

4

How does the two-step commit safety workflow work?

For write operations, the SQL executes in a transaction and the conversation ends. The user reviews results, then starts a new conversation saying "Yes" to commit or "No" to rollback.

5

Can I run this server in Docker?

Yes. Build the Docker image and run it with a PostgreSQL connection string. On macOS use `host.docker.internal` to reach the host network.

Comments

More Databases MCP servers

Neon MCP Server

neondatabase-labs

MCP server for interacting with Neon Management API and databases

617

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

Lawstronaut

Lawstronaut-FZCO

Access millions of official legal and regulatory source documents from 155+ jurisdictions via MCP. Lawstronaut supports AI agents with structured legal research, legal data, laws, regulations, cases, guidance, official s

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers

88.1K

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.

1
Advertise