Skip to main content
MCP server CX Codex

Oracle Database — Claude Code MCP server: what it does, how to install

Oracle Database — an MCP server that puts Oracle behind your agent: bound SQL queries, table and index lookup across schemas, plus Lab control-plane tools.

no license updated 2026-10-29

Open on GitHub

What Oracle Database does

execute_query runs SQL against Oracle and accepts bind parameters; Postgres-style $1 placeholders get rewritten to :1 before the call goes out. The rest of the generic set reads the catalog: list_tables across schemas, describe_table for columns and defaults, list_schemas, get_table_indexes, get_table_constraints. A second group talks to the Lab control-plane tables — check_gates, get_dispatchable_items, build_dispatch_packet, stamp_dispatch_consumed, fail_dispatch_preflight, handle_final_return, dispatch_scene.

Setup starts with npm install in the repo. Credentials live in .env, and there are three ways to supply them: an Easy Connect string, a TNS name, or host, port and service name as separate variables. ORACLE_DEFAULT_SCHEMA picks the schema when it differs from the user. Register the server in ~/.claude.json under mcpServers with "type": "stdio" and a node command pointing at src/index.js, then restart Claude. The Lab mirror comes from the DDL files, run through sqlplus on Oracle or psql on PostgreSQL.

You need Node.js 18+, an Oracle instance and a route to it. Connections open per query rather than from a pool. execute_query also lets writes through: bind variables block injection, they do not stop a stray DELETE, and the audit log only records timing and duration.

What it helps with

  • inspect a table's columns without opening SQL*Plus
  • list tables in one schema with row counts
  • run a parameterised query instead of concatenating values
  • trace indexes and foreign keys on a table
  • read lab_work_items before starting a dispatch run

Example prompts for the agent

  • List every table in the HR schema with its row count.
  • Describe EMPLOYEES: columns, types, defaults.
  • Run a query against ORDERS with :1 as a bind parameter.

How to install Oracle Database

Install

The MCP registry has no launch command for it: see the repository README

Step by step, with commands for each platform: How to add an MCP server to Claude Code, Codex, Cursor, VS Code, Gemini CLI and more

Questions about Oracle Database

How do I install Oracle Database MCP server in Claude Code?

Clone the repo and run npm install. Add an oracle entry to mcpServers in ~/.claude.json with "type": "stdio", a node command and the path to src/index.js, along with ORACLE_CONNECTION_STRING, ORACLE_USER and ORACLE_PASSWORD. Restart Claude once the config is saved.

What does Oracle Database MCP server do?

It hands the agent tools for the database: parameterised SQL execution, schema and table listing, column, index and constraint details. A separate set of tools reads and advances Lab records held in lab_control and lab_work_items.

What does the server need to run?

Node.js 18+, an Oracle instance and network access to it. Credentials come from .env, and every query opens a fresh connection instead of borrowing one from a pool.

Similar MCP servers

All MCP servers for Data and databases →

Project sponsors

Companies that keep this analytics open