Postgresql MCP

A Model Context Protocol (MCP) server for PostgreSQL with full read-write support, atomic transactions, and schema inspection. Works with Claude Desktop, Cursor, Windsurf, and any MCP-compatible AI…

Local serverstdio

What is the Postgresql MCP Server?

Postgresql MCP is an MCP project maintained in the sarmadparvez/postgresql-mcp repository. The maintainer describes its purpose as “A Model Context Protocol (MCP) server for PostgreSQL with full read-write support, atomic transactions, and schema inspection. Works with Claude Desktop, Cursor, Windsurf, and any…”. Read the project documentation for the complete scope.

Local setup

The project provides a local client configuration using /usr/local/bin/node. Follow the repository’s build and installation steps before copying it, and replace example paths with the paths on your own computer.

Source

Project documentation · Repository · Discovery listing. This profile records the public documentation checked on 2026-10-08.

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.

ToolWhat it does
queryAlways
executeRead-write mode
schemaAlways
list_tablesAlways
transactionRead-write mode

How to install the Postgresql MCP Server

{
  "mcpServers": {
    "postgres": {
      "command": "/usr/local/bin/node",
      "args": [
        "/usr/local/lib/node_modules/@sarmadparvez/postgresql-mcp/index.js",
        "postgresql://user:pass@localhost:5432/mydb"
      ]
    }
  }
}

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