oracle link for VS Code

io.github.studiousxiaoyu/oracle-link

Oracle MCP Query Server (Node.js) - Read-only SELECT via MCP

client:VS Code transport:stdio runtime:npm

Install oracle link in VS Code

.vscode/mcp.json

{
  "inputs": [
    {
      "type": "promptString",
      "id": "oracle-username",
      "description": "ORACLE_USERNAME",
      "password": true
    },
    {
      "type": "promptString",
      "id": "oracle-password",
      "description": "ORACLE_PASSWORD",
      "password": true
    },
    {
      "type": "promptString",
      "id": "oracle-connect-string",
      "description": "ORACLE_CONNECT_STRING",
      "password": true
    },
    {
      "type": "promptString",
      "id": "oracle-privilege",
      "description": "ORACLE_PRIVILEGE",
      "password": true
    },
    {
      "type": "promptString",
      "id": "default-max-rows",
      "description": "DEFAULT_MAX_ROWS",
      "password": true
    }
  ],
  "servers": {
    "oracle-link": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@studious-xiaoyu/oracle-link"
      ],
      "env": {
        "ORACLE_USERNAME": "${input:oracle-username}",
        "ORACLE_PASSWORD": "${input:oracle-password}",
        "ORACLE_CONNECT_STRING": "${input:oracle-connect-string}",
        "ORACLE_PRIVILEGE": "${input:oracle-privilege}",
        "DEFAULT_MAX_ROWS": "${input:default-max-rows}"
      }
    }
  }
}

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

oracle link in other clients

oracle link MCP server