Skip to content
Claude Desktop

PostgreSQL MCP Server for Claude Desktop

io.github.musaddiq-dev/postgresql-mcp-server

Python MCP server for PostgreSQL database inspection and querying

client:Claude Desktop transport:stdio runtime:pypi

Install PostgreSQL MCP Server in Claude Desktop

~/Library/Application Support/Claude/claude_desktop_config.json · windows: %APPDATA%\Claude\claude_desktop_config.json

Held in this page only — never stored, logged, or sent anywhere but back to your screen.

{
  "mcpServers": {
    "postgresql-mcp-server": {
      "command": "uvx",
      "args": [
        "mdev-postgresql-mcp-server"
      ],
      "env": {
        "POSTGRES_HOST": "<POSTGRES_HOST>",
        "POSTGRES_PORT": "<POSTGRES_PORT>",
        "POSTGRES_USER": "<POSTGRES_USER>",
        "POSTGRES_PASSWORD": "<POSTGRES_PASSWORD>",
        "POSTGRES_DB": "<POSTGRES_DB>",
        "POSTGRES_READ_QUERY_LIMIT": "<POSTGRES_READ_QUERY_LIMIT>"
      }
    }
  }
}

Settings → Developer → Edit Config opens this file. Restart the app after saving. Claude Desktop docs

PostgreSQL MCP Server in other clients