mcp_server_with_asdf.json

{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-postgres",
        "postgresql://<user>:<pass>@<host>:<port>/<database>"
      ],
      "env": {
        "PATH": "/Users/<user>/.asdf/shims:/opt/homebrew/bin:/usr/bin:/bin",
        "ASDF_DIR": "/opt/homebrew/opt/asdf/libexec",
        "ASDF_DATA_DIR": "/Users/<user>/.asdf",
        "ASDF_NODEJS_VERSION": "23.11.0"
      }
    }
  }
}