mcp-oracle-db
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@mcp-oracle-db show all tables in the HR schema"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
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-dbOr install globally:
npm install -g mcp-oracle-dbConfiguration
Set these environment variables:
Variable | Required | Default | Description |
| Yes | — | Database username |
| Yes | — | Database password |
| Yes | — |
|
| No |
|
|
| No |
| Max rows per query |
| No | — | Path to |
| 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/walletSetup
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 all accessible schemas |
| List tables and views in a schema |
| Columns, PKs, FKs, indexes of a table |
Query
Tool | Description |
| Run SELECT queries (supports bind variables) |
Write (requires ORACLE_MODE=readwrite)
Tool | Description |
| Run DML — INSERT, UPDATE, DELETE, MERGE |
| Run DDL — CREATE, ALTER, DROP, TRUNCATE |
DBA / Monitoring
Tool | Description |
| Execution plan for a query |
| Current session details |
| All active database sessions |
| Active locks and blockers |
Security
Read-only by default — writes blocked unless
ORACLE_MODE=readwriteSQL validation —
queryonly accepts SELECT/WITHBind 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 toolsactive_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
Scored across 10 tools
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.
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.
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.
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
Related MCP Connectors
Draxlr's remote MCP server connects AI assistants to your SQL databases and dashboards. Explore schemas, run read-only queries, manage saved queries and dashboards, and export results, all with row-level security so each user sees only their own data.
Cloud-hosted MCP server for secure AI access to enterprise data sources via CData Connect AI.
Query your org's data in natural language — read-only MCP access to SQL, NoSQL, files & warehouses.
Related MCP Servers
- AlicenseAqualityDmaintenanceAn MCP server that connects to Oracle databases using sqlplus, enabling SQL queries, schema exploration, and DDL/DML execution through natural language.819 npmMIT
- -licenseNot gradedqualityDmaintenanceAn MCP server that bridges AI assistants with SQL databases, enabling natural language querying across multiple database types with built-in optimization and security.3-
- AlicenseBqualityDmaintenanceMCP server for accessing Oracle databases, enabling schema exploration, query execution, and performance analysis.12MIT
- AlicenseNot gradedqualityDmaintenanceRead-only MCP server that lets coding AI agents inspect Oracle Database schema through live metadata.ISC