Radek Oracle MCP

Radek Oracle MCP

高级Oracle 19c诊断MCP服务器 人工智能工具（克劳德代码、光标）。

29工具 涵盖了完整的Oracle诊断堆栈：会话、锁、等待事件、SQL性能（v$SQL）、表空间、SGA/PGA内存、重做日志、撤消管理、优化器统计、数据保护和模式分析。

______________________________________________________________________

察看连接信息

______________________________________________________________________

快速开始

1.安装依赖项

cd /data/project/radek-oracle-mcp
npm install
npm run build

2.初始化配置并生成secret

cp db.config.example.json db.config.json
node dist/create-token.js --init

3.生成JWT令牌

node dist/create-token.js --name claude --days 365

输出包括一个即用型 .mcp.json Claude代码和游标块。

4.启动服务器

npm start
# or for development:
npm run dev

验证：

curl http://localhost:8003/health
# {"status":"ok","server":"Radek Oracle MCP","version":"1.0.0","tools":29}

5.启动Cloudflare隧道

cloudflared tunnel --config ~/.cloudflared/config-radek-oracle-mcp.yml run radek-oracle-mcp

______________________________________________________________________

配置

db.config.json：

{
  "auth": {
    "secret": ""
  },
  "server": {
    "port": 8003,
    "tunnel_url": "https://radek-oracle-mcp.clickchain.eu"
  }
}

database.url 是可选的--Claude通过以下方式动态传递Oracle URL X-Database-URL 头球

______________________________________________________________________

Oracle连接URL格式

X-Database-URL: oracle://user:password@host:1521/service_name
X-Database-URL: oracle://user:password@host:1521/ORCL
X-Database-URL: oracle://user:password@scan-host:1521/MYDB    (RAC)
X-Database-URL: oracle+ssl://user:password@host:2484/ORCL     (SSL/TLS)

所需Oracle权限

GRANT CREATE SESSION TO mcp_user;
GRANT SELECT_CATALOG_ROLE TO mcp_user;
GRANT SELECT ANY DICTIONARY TO mcp_user;
-- For explain_query:
GRANT CREATE ANY TABLE TO mcp_user;
-- Or simply:
GRANT DBA TO mcp_user;

______________________________________________________________________

MCP客户端配置

克劳德代码-- .mcp.json

{
  "mcpServers": {
    "radek-oracle": {
      "type": "http",
      "url": "https://radek-oracle-mcp.clickchain.eu/mcp",
      "headers": {
        "Authorization": "Bearer ",
        "X-Database-URL": "oracle://user:password@host:1521/ORCL"
      }
    }
  }
}

克劳德代码-CLI

TOKEN=""
DB="oracle://user:password@host:1521/ORCL"

claude mcp add radek-oracle https://radek-oracle-mcp.clickchain.eu/mcp \
  --transport http \
  --header "Authorization: Bearer $TOKEN" \
  --header "X-Database-URL: $DB" \
  --scope local

光标-- .cursor/mcp.json

{
  "mcpServers": {
    "radek-oracle": {
      "type": "http",
      "url": "https://radek-oracle-mcp.clickchain.eu/mcp",
      "headers": {
        "Authorization": "Bearer ",
        "X-Database-URL": "oracle://user:password@host:1521/ORCL"
      }
    }
  }
}

______________________________________________________________________

Cloudflare 隧道

隧道 radek-oracle-mcp 使用ID创建 ffcf0846-8f91-4687-a312-989ac2e11835.

域名系统 radek-oracle-mcp.clickchain.eu → 指向这条隧道。

手动开始

cloudflared tunnel --config ~/.cloudflared/config-radek-oracle-mcp.yml run radek-oracle-mcp

配置文件(~/.cloudflared/config-radek-oracle-mcp.yml)

credentials-file: /home/mcp/.cloudflared/ffcf0846-8f91-4687-a312-989ac2e11835.json
ingress:
  - hostname: radek-oracle-mcp.clickchain.eu
    service: http://127.0.0.1:8003
  - service: http_status:404

systemd服务

sudo tee /etc/systemd/system/cloudflared-radek-oracle-mcp.service > /dev/null << 'EOF'
[Unit]
Description=Cloudflare Tunnel — radek-oracle-mcp
After=network.target

[Service]
User=mcp
ExecStart=/usr/bin/cloudflared tunnel --config /home/mcp/.cloudflared/config-radek-oracle-mcp.yml run radek-oracle-mcp
Restart=always
RestartSec=5

[Install]
WantedBy=multi-user.target
EOF

sudo systemctl daemon-reload
sudo systemctl enable cloudflared-radek-oracle-mcp
sudo systemctl start cloudflared-radek-oracle-mcp

______________________________________________________________________

令牌生成

# First time — generate secret
node dist/create-token.js --init

# Generate tokens
node dist/create-token.js --name claude --days 365
node dist/create-token.js --name cursor --days 90
node dist/create-token.js --name ci-bot --days 365

# Using npm script
npm run token -- --name claude --days 365

______________________________________________________________________

可用工具（29）

______________________________________________________________________

Oracle专用工具（没有MySQL/PostgreSQL等效工具）

______________________________________________________________________

建筑

AI Client (Claude Code, Cursor)
    │  HTTPS + JWT Bearer + X-Database-URL header
    ▼
Cloudflare Tunnel (radek-oracle-mcp.clickchain.eu)
    │  ffcf0846-8f91-4687-a312-989ac2e11835
    ▼
HTTP Server (Node.js, port 8003)
    │  JWT verify → JSON-RPC 2.0
    ▼
MCP Handler (protocol 2025-11-25)
    │  tools/call dispatch
    ▼
Tool Layer (29 tools in src/tools/)
    │  Oracle SQL queries
    ▼
Query Layer (Oracle SQL in src/queries/)
    │  oracledb pool (max 5 connections, thin mode)
    ▼
Oracle 12c / 18c / 19c / 21c

______________________________________________________________________

文档

______________________________________________________________________

许可证

麻省理工学院