Skip to content
VS Code

oracle for VS Code

io.github.marcelo-ochoa/oracle

MCP server for interacting with Oracle databases

client:VS Code transport:stdio runtime:npm

Install oracle in VS Code

.vscode/mcp.json

{
  "inputs": [
    {
      "type": "promptString",
      "id": "oracle-user",
      "description": "ORACLE_USER",
      "password": true
    },
    {
      "type": "promptString",
      "id": "oracle-password",
      "description": "ORACLE_PASSWORD",
      "password": true
    }
  ],
  "servers": {
    "oracle": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@marcelo-ochoa/server-oracle"
      ],
      "env": {
        "ORACLE_USER": "${input:oracle-user}",
        "ORACLE_PASSWORD": "${input:oracle-password}"
      }
    }
  }
}

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

oracle in other clients