Oracle MCP Query Server (Node.js) - Read-only SELECT via MCP
Connect Runs on your machine
claude mcp add oracle-link -e ORACLE_USERNAME=<ORACLE_USERNAME> -e ORACLE_PASSWORD=<ORACLE_PASSWORD> -e ORACLE_CONNECT_STRING=<ORACLE_CONNECT_STRING> -e ORACLE_PRIVILEGE=<ORACLE_PRIVILEGE> -e DEFAULT_MAX_ROWS=<DEFAULT_MAX_ROWS> -- npx -y @studious-xiaoyu/[email protected]{
"mcpServers": {
"oracle-link": {
"command": "npx",
"args": [
"-y",
"@studious-xiaoyu/[email protected]"
],
"env": {
"ORACLE_USERNAME": "<ORACLE_USERNAME>",
"ORACLE_PASSWORD": "<ORACLE_PASSWORD>",
"ORACLE_CONNECT_STRING": "<ORACLE_CONNECT_STRING>",
"ORACLE_PRIVILEGE": "<ORACLE_PRIVILEGE>",
"DEFAULT_MAX_ROWS": "<DEFAULT_MAX_ROWS>"
}
}
}
}{
"mcpServers": {
"oracle-link": {
"command": "npx",
"args": [
"-y",
"@studious-xiaoyu/[email protected]"
],
"env": {
"ORACLE_USERNAME": "<ORACLE_USERNAME>",
"ORACLE_PASSWORD": "<ORACLE_PASSWORD>",
"ORACLE_CONNECT_STRING": "<ORACLE_CONNECT_STRING>",
"ORACLE_PRIVILEGE": "<ORACLE_PRIVILEGE>",
"DEFAULT_MAX_ROWS": "<DEFAULT_MAX_ROWS>"
}
}
}
}{
"servers": {
"oracle-link": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@studious-xiaoyu/[email protected]"
],
"env": {
"ORACLE_USERNAME": "<ORACLE_USERNAME>",
"ORACLE_PASSWORD": "<ORACLE_PASSWORD>",
"ORACLE_CONNECT_STRING": "<ORACLE_CONNECT_STRING>",
"ORACLE_PRIVILEGE": "<ORACLE_PRIVILEGE>",
"DEFAULT_MAX_ROWS": "<DEFAULT_MAX_ROWS>"
}
}
}
}Replace the values in angle brackets with your own. Keys stay on your machine; we never see them.
Tools
This server runs locally, so its tools are listed by your MCP client once it starts.
Environment variables
| Name | Description |
|---|---|
ORACLE_USERNAMEOptional | Oracle DB username (optional when using tool url) |
ORACLE_PASSWORDOptional, secret | Oracle DB password (optional when using tool url) |
ORACLE_CONNECT_STRINGOptional | Oracle connect string host:port/service (optional when using tool url) |
ORACLE_PRIVILEGEOptional | Admin privilege (SYSDBA or SYSOPER), optional |
DEFAULT_MAX_ROWSOptional | Default max rows for queries |
Details
| Package | @studious-xiaoyu/[email protected] (NPM, stdio) |
| First published | 4 Dec 2025 |
| Last updated | 4 Dec 2025 |
| Registry name | io.github.StudiousXiaoYu/oracle-link |
More other servers See all
Listing data from the official MCP registry. Status and tools from NestDaddy's daily check. Browse all MCP servers.