pgautopilot

PGAutoPilot — an MCP server that lets AI assistants safely explore, query, and manage any PostgreSQL database. Zero setup, auto-discovery, production-safe.

Installation

MCP client config (paste into mcp.json)

{
  "mcpServers": {
    "npm-pgautopilot": {
      "command": "npx",
      "args": [
        "pgautopilot"
      ]
    }
  }
}

Agent install prompt

Copy and paste into Cursor / Claude / other agents to install this MCP for you

Please read this MCP repository and install it into my current environment:
https://www.npmjs.com/package/pgautopilot

Known working client config (can write into mcp.json):
{
  "mcpServers": {
    "npm-pgautopilot": {
      "command": "npx",
      "args": [
        "pgautopilot"
      ]
    }
  }
}

Please: 1) check README for deps and env vars; 2) write config for my client; 3) if secrets are missing, tell me what to fill — do not invent values.

GitHub

Related servers