mcpField
O
oracle-link

oracle-link

Local
github.com/StudiousXiaoYuDatabases
Repository

About oracle-link

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

Configuration

Local server config is the same for every client. Copy it into your client’s MCP config file.

mcp.json · Universal config
{
  "mcpServers": {
    "studiousxiaoyu-oracle-link": {
      "command": "npx",
      "args": [
        "-y",
        "@studious-xiaoyu/oracle-link"
      ],
      "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>"
      }
    }
  }
}
Run commandnpx -y @studious-xiaoyu/oracle-link
Environment variables to set
ORACLE_USERNAMEOracle DB username (optional when using tool url)
ORACLE_PASSWORDSecretOracle DB password (optional when using tool url)
ORACLE_CONNECT_STRINGOracle connect string host:port/service (optional when using tool url)
ORACLE_PRIVILEGEAdmin privilege (SYSDBA or SYSOPER), optional
DEFAULT_MAX_ROWSDefault max rows for queries

Local servers need a runtime on your machine (e.g. Node.js 18+). Config file locations differ by client; see your client’s docs.

Packages
npm@studious-xiaoyu/oracle-link0.2.2

Tools

3

Saved tool list · updated 2w ago

ParameterTypeRequiredDescription
sqlstringYesSQL text of a read-only query. Must start with SELECT or WITH; DML/DDL are rejected.
urlstringNoPer-call connection string. Format: oracle://user:password@host:port/service?privilege=SYSDBA&maxRows=N
max_rowsintegerNoMaximum rows to return. Enforced by appending FETCH FIRST when needed.

Details

The maintainer has not added details yet. Check the README in the repository.

Comments

Markdown supported

New to MCP?

From what the protocol is to installing your first server, these answers cover most first questions.

An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.