How do I install the mcp postgres full access mcp server?

Use a recorded configuration for your client, replace example credential values and paths, and verify the documented runtime. Restart or reconnect the client, then inspect the available tools.

What credentials does it need?

It reads `TRANSACTION_TIMEOUT_MS`, `MAX_CONCURRENT_TRANSACTIONS`, `PG_STATEMENT_TIMEOUT_MS` from the environment. Store these in your client's env block or a secrets manager — never commit them to a repository — and grant the narrowest scope that still covers your use case.

SSyncDev

Start a project

MCP Postgres Full Access MCP Server

Full-access PostgreSQL server for Model Context Protocol with read/write capabilities and enhanced schema metadata

Local serverstdio

What is the MCP Postgres Full Access MCP Server?

Full-access PostgreSQL server for Model Context Protocol with read/write capabilities and enhanced schema metadata

The short version

A powerful Model Context Protocol server providing full read-write access to PostgreSQL databases. Unlike the read-only official MCP PostgreSQL server, this enhanced implementation allows Large Language Models (LLMs) to both query and modify database content with proper transaction management and safety controls.

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

Recorded tools

Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.

Tool	What it does
execute_query	Execute read-only SQL queries (SELECT statements)
execute_dml_ddl_dcl_tcl	Execute data modification operations (INSERT, UPDATE, DELETE) or schema changes (CREATE, ALTER, DROP)
execute_maintenance	Execute maintenance commands like VACUUM, ANALYZE, or CREATE DATABASE outside of transactions
execute_commit	Explicitly commit a transaction by its ID
execute_rollback	Explicitly rollback a transaction by its ID
list_tables	Get a comprehensive list of all tables in the database
describe_table	Get detailed information about a specific table structure

How to install the MCP Postgres Full Access MCP Server

{
  "mcpServers": {
    "postgres-full": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-postgres-full-access",
        "postgresql://username:password@localhost:5432/database"
      ],
      "env": {
        "TRANSACTION_TIMEOUT_MS": "60000",
        "MAX_CONCURRENT_TRANSACTIONS": "5",
        "PG_STATEMENT_TIMEOUT_MS": "30000"
      }
    }
  }
}

From the project documentation. Replace placeholders and example paths before connecting.

Configuration

Variable	Description	Required
TRANSACTION_TIMEOUT_MS	Declared in the maintainer’s client configuration.	Check documentation
MAX_CONCURRENT_TRANSACTIONS	Declared in the maintainer’s client configuration.	Check documentation
PG_STATEMENT_TIMEOUT_MS	Declared in the maintainer’s client configuration.	Check documentation

Example prompts to try

“Use MCP Postgres Full Access to execute query.”
“Use MCP Postgres Full Access to Input.”
“Use MCP Postgres Full Access to execute dml ddl dcl tcl.”

Frequently asked questions

Full-access PostgreSQL server for Model Context Protocol with read/write capabilities and enhanced schema metadata Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.