pgmcp for Windsurf
io.github.pascalallen/pgmcp
Read-only Postgres ops/DBA diagnostics: slow queries, EXPLAIN, locks, index and table health.
client:Windsurf
transport:stdio
runtime:oci
Install pgmcp in Windsurf
~/.codeium/windsurf/mcp_config.json · windows: %USERPROFILE%\.codeium\windsurf\mcp_config.json
{
"mcpServers": {
"pgmcp": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"ghcr.io/pascalallen/pgmcp:1.1.0"
],
"env": {
"PGMCP_DATABASE_URL": "<PGMCP_DATABASE_URL>"
}
}
}
}
Global only — Windsurf has no per-project MCP config. Refresh Cascade after saving. Windsurf docs