PostgreSQL Full-Access MCP

Example Use Cases

• 1

  Perform safe, auditable data modifications (INSERT/UPDATE/DELETE) in PostgreSQL with explicit commit/rollback and transaction timeouts.

• 2

  Detailed schema and index metadata (columns, PK/FK, indexes, descriptions) to generate correct queries and transformations.

• 3

  Run maintenance commands or schema changes (VACUUM, ANALYZE, CREATE/ALTER/DROP) with controlled execution and result reporting.

Description

This server enables agents to execute read-only queries as well as DML/DDL/DCL/TCL operations against PostgreSQL while enforcing transaction isolation, timeouts, and an explicit commit/rollback workflow. It exposes rich schema and index metadata, row-count estimates, and table/column descriptions to help agents reason about the database. Safety features include statement timeouts, limited concurrent transactions, an automatic transaction monitor, and a two-step commit process designed for manual approval (e.g., via Claude Desktop). The project is open-source (MIT) and intended for safe, auditable database modifications by LLM-powered tools.