AdYour product here, seen by people installing AI tools every day Sponsor slots open: 12 of 12, from $249 a month

How to install PostgreSQL Performance (read-only) in Windsurf

To install PostgreSQL Performance (read-only) in Windsurf, paste the "postgresql-performance-read-only" block into ~/.codeium/windsurf/mcp_config.json and refresh the MCP panel in Cascade.

Built from the published package · server updated 4 days ago

  1. 1

    Open the MCP config

    In Windsurf, open Settings, then Cascade, then MCP servers, and choose to view the raw config.

  2. 2

    Add the server

    Paste this into mcp_config.json:

    {
      "mcpServers": {
        "postgresql-performance-read-only": {
          "command": "docker",
          "args": [
            "run",
            "-i",
            "--rm",
            "-e",
            "PGPERF_DB_URL",
            "-e",
            "PGPERF_DB_USER",
            "-e",
            "PGPERF_DB_PASSWORD",
            "-e",
            "MCP_API_KEY",
            "ghcr.io/gouranshul/pg-perf-mcp:0.1.0"
          ],
          "env": {
            "PGPERF_DB_URL": "YOUR_PGPERF_DB_URL",
            "PGPERF_DB_USER": "YOUR_PGPERF_DB_USER",
            "PGPERF_DB_PASSWORD": "YOUR_PGPERF_DB_PASSWORD",
            "MCP_API_KEY": "YOUR_MCP_API_KEY"
          }
        }
      }
    }
  3. 3

    Refresh

    Click refresh in the MCP panel. The server and its tools appear in Cascade.

Config file: ~/.codeium/windsurf/mcp_config.json

MCP servers run with your permissions. If PostgreSQL Performance (read-only) needs an API key, add it under env in the config. Check its README.

Install PostgreSQL Performance (read-only) in another app

Similar servers

Questions

Does PostgreSQL Performance (read-only) work in Windsurf?

Yes. Windsurf supports local and remote mcp servers, and PostgreSQL Performance (read-only) installs with the steps above.

PostgreSQL Performance (read-only) does not show up in Windsurf. What now?

Restart Windsurf fully, check the JSON is valid, and make sure Node.js (for npx) is installed. See common MCP errors and fixes.

Is PostgreSQL Performance (read-only) safe?

It scores 30 of 100. Review the code before you install it, and only give it the access it needs. Grades and details.