mcp-oracle-db

An MCP (Model Context Protocol) server for Oracle Database.

Lets AI assistants explore your database schema, run queries, write data, and monitor sessions — all through natural language.

Works with Claude Desktop, Claude Code, Cursor, Windsurf, and any MCP-compatible client.

Features

• Explore — list schemas, tables, columns, indexes, constraints

• Query — execute SELECT with bind variables

• Write — INSERT, UPDATE, DELETE, MERGE, DDL (opt-in)

• Monitor — explain plans, active sessions, locks

• Safe — read-only by default, write requires explicit opt-in

• Zero install — Oracle Thin mode, no Oracle Client needed

• Connection pooling — efficient resource usage

Related MCP server: mcp-ohmy-sql

Quick Start

npx mcp-oracle-db

Or install globally:

npm install -g mcp-oracle-db

Configuration

Set these environment variables:

Connection string formats

# Standard
ORACLE_CONNECTION_STRING=myhost:1521/myservice

# TNS alias
ORACLE_CONNECTION_STRING=MY_TNS_ALIAS
ORACLE_TNS_ADMIN=/path/to/tns_admin

# Oracle Cloud / Autonomous DB (wallet)
ORACLE_CONNECTION_STRING=myatp_high
ORACLE_TNS_ADMIN=/path/to/wallet
ORACLE_WALLET_LOCATION=/path/to/wallet

Setup

Claude Desktop

Add to claude_desktop_config.json:

{
  "mcpServers": {
    "oracle": {
      "command": "npx",
      "args": ["-y", "mcp-oracle-db"],
      "env": {
        "ORACLE_USER": "your_user",
        "ORACLE_PASSWORD": "your_password",
        "ORACLE_CONNECTION_STRING": "your_host:1521/your_service"
      }
    }
  }
}

Claude Code

Add to .claude/settings.json:

{
  "mcpServers": {
    "oracle": {
      "command": "npx",
      "args": ["-y", "mcp-oracle-db"],
      "env": {
        "ORACLE_USER": "your_user",
        "ORACLE_PASSWORD": "your_password",
        "ORACLE_CONNECTION_STRING": "your_host:1521/your_service"
      }
    }
  }
}

Cursor / Windsurf

Same format as Claude Code — add to your MCP settings with the env vars above.

Tools

Exploration

Query

Write (requires ORACLE_MODE=readwrite)

DBA / Monitoring

Security

• Read-only by default — writes blocked unless ORACLE_MODE=readwrite

• SQL validation — query only accepts SELECT/WITH

• Bind variables — prevents SQL injection

• No credentials in code — everything via environment variables

Requirements

• Node.js >= 18

• Oracle Database (any version)

• No Oracle Client installation needed

License

MIT