Skip to main content
Glama
mcp-oracle-db

mcp-oracle-db

by mesquitadev

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:

Variable

Required

Default

Description

ORACLE_USER

Yes

—

Database username

ORACLE_PASSWORD

Yes

—

Database password

ORACLE_CONNECTION_STRING

Yes

—

host:port/service or TNS alias

ORACLE_MODE

No

readonly

readonly or readwrite

ORACLE_MAX_ROWS

No

1000

Max rows per query

ORACLE_TNS_ADMIN

No

—

Path to tnsnames.ora directory

ORACLE_WALLET_LOCATION

No

—

Path to Oracle Wallet (for cloud DBs)

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

Tool

Description

list_schemas

List all accessible schemas

list_tables

List tables and views in a schema

describe_table

Columns, PKs, FKs, indexes of a table

Query

Tool

Description

query

Run SELECT queries (supports bind variables)

Write (requires ORACLE_MODE=readwrite)

Tool

Description

execute

Run DML — INSERT, UPDATE, DELETE, MERGE

ddl

Run DDL — CREATE, ALTER, DROP, TRUNCATE

DBA / Monitoring

Tool

Description

explain_plan

Execution plan for a query

session_info

Current session details

active_sessions

All active database sessions

locks

Active locks and blockers

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

Available Tools

10 tools
active_sessionsActive SessionsA

List active sessions in the Oracle database (V$SESSION)

Inputs: no named parameters.

ddlExecute DDLA

Execute DDL statements (CREATE, ALTER, DROP, TRUNCATE, etc). Requires ORACLE_MODE=readwrite.

Inputs: sql (required).

describe_tableDescribe TableA

Show columns, types, primary keys, foreign keys, and indexes for a table

Inputs: table (required), schema (required).

executeExecute DMLA

Execute INSERT, UPDATE, DELETE, or MERGE statement. Requires ORACLE_MODE=readwrite. Auto-commits on success.

Inputs: sql (required), binds.

explain_planExplain PlanB

Generate execution plan for a SQL query

Inputs: sql (required).

list_schemasList SchemasA

List all accessible schemas in the Oracle database

Inputs: no named parameters.

list_tablesList TablesA

List all tables and views in a schema

Inputs: schema (required).

locksDatabase LocksA

Show active locks and blocking sessions

Inputs: no named parameters.

queryExecute QueryB

Execute a SELECT query against the Oracle database. Returns results as JSON.

Inputs: sql (required), binds, max_rows.

session_infoSession InfoA

Get information about the current database session

Inputs: no named parameters.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    A3.8/5.0

    Scored across 10 tools

    Disambiguation5/5

    Each tool has a clearly distinct purpose: schema/table metadata (list_schemas, list_tables, describe_table), SQL operations (query, execute, ddl), query planning (explain_plan), and session/admin monitoring (session_info, active_sessions, locks). No overlaps exist.

    Naming Consistency4/5

    Most names are clear and follow a verb_noun pattern (list_schemas, describe_table, explain_plan), but a few are single verbs (query, execute) or bare nouns (ddl, locks), creating minor inconsistency. Still readable and predictable overall.

    Tool Count5/5

    10 tools is well-scoped for a database server, covering metadata exploration, SQL DML/DDL, query analysis, and session/lock monitoring without excess. Each tool earns its place.

    Completeness4/5

    The set covers the core database lifecycle: schema discovery, querying, data modification, DDL, and monitoring. Minor gaps like a dedicated index-listing tool or multi-statement runner exist, but agents can work around them via DDL and query.

    Maintenance

    ActivityInactive
    ResponsivenessNo recent community issues

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      A
      quality
      D
      maintenance
      An MCP server that connects to Oracle databases using sqlplus, enabling SQL queries, schema exploration, and DDL/DML execution through natural language.
      8
      19 npm
      MIT
    • -
      license
      Not graded
      quality
      D
      maintenance
      An MCP server that bridges AI assistants with SQL databases, enabling natural language querying across multiple database types with built-in optimization and security.
      3
      -
    • A
      license
      B
      quality
      D
      maintenance
      MCP server for accessing Oracle databases, enabling schema exploration, query execution, and performance analysis.
      12
      MIT
    • A
      license
      Not graded
      quality
      D
      maintenance
      Read-only MCP server that lets coding AI agents inspect Oracle Database schema through live metadata.
      ISC