Back to MCP Servers
🔌

subnetmarco/pgmcp

NOASSERTIONAPI key required

🏎️ 🏠 - Natural language PostgreSQL queries with automatic streaming, read-only safety, and universal database compatibility.

GoDatabases

Install

npx -y subnetmarco-pgmcp

Required environment variables

OPENAI_API_KEYSet in your MCP config

claude_desktop_config.json

claude_desktop_config.json
{
  "mcpServers": {
    "subnetmarco-pgmcp": {
      "command": "npx",
      "args": [
        "-y",
        "subnetmarco-pgmcp"
      ],
      "env": {
        "OPENAI_API_KEY": "<YOUR_OPENAI_API_KEY>"
      }
    }
  }
}

Add this to your Claude Desktop config file. Find it at ~/Library/Application Support/Claude/claude_desktop_config.json on macOS.