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 GitHubWhat 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_itemsbefore starting a dispatch run
Example prompts for the agent
- List every table in the
HRschema with its row count. - Describe
EMPLOYEES: columns, types, defaults. - Run a query against
ORDERSwith:1as 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.