PostgreSQL (Enhanced) MCP Server

# PostgreSQL MCP Server (Enhanced) A Model Context Protocol server that provides both read and write access to PostgreSQL databases. This server

Local serverstdio

What is the PostgreSQL (Enhanced) MCP Server?

PostgreSQL MCP Server (Enhanced) A Model Context Protocol server that provides both read and write access to PostgreSQL databases. This server enables LLMs to

More MCP options

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

How to install the PostgreSQL (Enhanced) MCP Server

{
  "mcpServers": {
    "postgres": {
      "command": "docker",
      "args": [
        "run", 
        "-i", 
        "--rm", 
        "mcp/postgres", 
        "postgresql://host.docker.internal:5432/mydb"]
    }
  }
}

Configuration as documented by the project. Restart the client after saving.

Example prompts to try

  • “Use PostgreSQL (Enhanced) to Tools.”
  • “Use PostgreSQL (Enhanced) to Resources.”

Frequently asked questions

The original server provides read-only access. This enhanced version adds write capabilities (INSERT, UPDATE, DELETE) and schema management tools like create table, function, trigger, index, and alter table.