io.github.StudiousXiaoYu/oracle-link

Official

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

Read-only Oracle database query server via MCP.

Install

Configuration

Environment variables

ORACLE_USERNAME

Oracle DB username (optional when using tool url)

ORACLE_PASSWORDsecret

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_config.json

{
  "mcpServers": {
    "oracle-link": {
      "command": "npx",
      "args": [
        "-y",
        "@studious-xiaoyu/oracle-link@0.2.2"
      ],
      "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>"
      }
    }
  }
}