MCP Server

io.github.StudiousXiaoYu/oracle-link MCP Server

Name: io.github.StudiousXiaoYu/oracle-link MCP Server
Author: io.github.StudiousXiaoYu

io.github.StudiousXiaoYu/oracle-link

Repository Registry

What is the io.github.StudiousXiaoYu/oracle-link MCP server?

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

How to install io.github.StudiousXiaoYu/oracle-link

Copy-paste configuration for popular MCP clients.

transport: stdio

Config generated by PluginBench — verify against the source before use.

Environment / auth

ORACLE_USERNAME
Oracle DB username (optional when using tool url)
ORACLE_PASSWORD
secret
Oracle DB password (optional when using tool url)
ORACLE_CONNECT_STRING
Oracle connect string host:port/service (optional when using tool url)
ORACLE_PRIVILEGE
Admin privilege (SYSDBA or SYSOPER), optional
DEFAULT_MAX_ROWS
Default max rows for queries

Claude Desktop

~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "oracle-link": {
      "command": "npx",
      "args": [
        "-y",
        "@studious-xiaoyu/oracle-link"
      ],
      "env": {
        "ORACLE_USERNAME": "<YOUR_ORACLE_USERNAME>",
        "ORACLE_PASSWORD": "<YOUR_ORACLE_PASSWORD>",
        "ORACLE_CONNECT_STRING": "<YOUR_ORACLE_CONNECT_STRING>",
        "ORACLE_PRIVILEGE": "<YOUR_ORACLE_PRIVILEGE>",
        "DEFAULT_MAX_ROWS": "<YOUR_DEFAULT_MAX_ROWS>"
      }
    }
  }
}

Cursor

~/.cursor/mcp.json

{
  "mcpServers": {
    "oracle-link": {
      "command": "npx",
      "args": [
        "-y",
        "@studious-xiaoyu/oracle-link"
      ],
      "env": {
        "ORACLE_USERNAME": "<YOUR_ORACLE_USERNAME>",
        "ORACLE_PASSWORD": "<YOUR_ORACLE_PASSWORD>",
        "ORACLE_CONNECT_STRING": "<YOUR_ORACLE_CONNECT_STRING>",
        "ORACLE_PRIVILEGE": "<YOUR_ORACLE_PRIVILEGE>",
        "DEFAULT_MAX_ROWS": "<YOUR_DEFAULT_MAX_ROWS>"
      }
    }
  }
}

Windsurf

~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "oracle-link": {
      "command": "npx",
      "args": [
        "-y",
        "@studious-xiaoyu/oracle-link"
      ],
      "env": {
        "ORACLE_USERNAME": "<YOUR_ORACLE_USERNAME>",
        "ORACLE_PASSWORD": "<YOUR_ORACLE_PASSWORD>",
        "ORACLE_CONNECT_STRING": "<YOUR_ORACLE_CONNECT_STRING>",
        "ORACLE_PRIVILEGE": "<YOUR_ORACLE_PRIVILEGE>",
        "DEFAULT_MAX_ROWS": "<YOUR_DEFAULT_MAX_ROWS>"
      }
    }
  }
}

VS Code

.vscode/mcp.json

{
  "servers": {
    "oracle-link": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@studious-xiaoyu/oracle-link"
      ],
      "env": {
        "ORACLE_USERNAME": "<YOUR_ORACLE_USERNAME>",
        "ORACLE_PASSWORD": "<YOUR_ORACLE_PASSWORD>",
        "ORACLE_CONNECT_STRING": "<YOUR_ORACLE_CONNECT_STRING>",
        "ORACLE_PRIVILEGE": "<YOUR_ORACLE_PRIVILEGE>",
        "DEFAULT_MAX_ROWS": "<YOUR_DEFAULT_MAX_ROWS>"
      }
    }
  }
}

Claude Code

claude mcp add oracle-link --env ORACLE_USERNAME=<YOUR_ORACLE_USERNAME> --env ORACLE_PASSWORD=<YOUR_ORACLE_PASSWORD> --env ORACLE_CONNECT_STRING=<YOUR_ORACLE_CONNECT_STRING> --env ORACLE_PRIVILEGE=<YOUR_ORACLE_PRIVILEGE> --env DEFAULT_MAX_ROWS=<YOUR_DEFAULT_MAX_ROWS> -- npx -y @studious-xiaoyu/oracle-link