pREST for VS Code

io.github.prest/prest

Stdio MCP adapter bridging AI clients to pREST’s HTTP /_mcp endpoint for PostgreSQL APIs.

client:VS Code transport:stdio runtime:oci

Install pREST in VS Code

.vscode/mcp.json

{
  "inputs": [
    {
      "type": "promptString",
      "id": "prest-mcp-url",
      "description": "PREST_MCP_URL",
      "password": true
    },
    {
      "type": "promptString",
      "id": "prest-mcp-token",
      "description": "PREST_MCP_TOKEN",
      "password": true
    },
    {
      "type": "promptString",
      "id": "prest-mcp-timeout-ms",
      "description": "PREST_MCP_TIMEOUT_MS",
      "password": true
    }
  ],
  "servers": {
    "prest": {
      "type": "stdio",
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/prest/prest-mcp-adapter:0.1.3"
      ],
      "env": {
        "PREST_MCP_URL": "${input:prest-mcp-url}",
        "PREST_MCP_TOKEN": "${input:prest-mcp-token}",
        "PREST_MCP_TIMEOUT_MS": "${input:prest-mcp-timeout-ms}"
      }
    }
  }
}

VS Code prompts for each input the first time the server starts, so no secret is written to the file. VS Code docs

pREST in other clients

pREST MCP server