MCP Oracle Server

MCP Oracle Server is an MCP server that enables AI assistants to connect and interact directly with Oracle relational database systems. Built on Node.js and communicating via standard I/O (stdio), it provides a controlled bridge for developers, database administrators, and data analysts using MCP-compatible tools like Cursor. The server exposes functionality to list available tables, inspect relational schemas, and run read-only queries against an Oracle instance. By restricting interactions exclusively to SELECT statements, it prevents unintended data modifications, table drops, or accidental schema updates while enabling agents to inspect structures, generate reports, and verify records. Users configure their connection credentials using environment variables for host, port, database name, user, and password, allowing AI agents to read operational databases and explore data architectures safely without leaving their editing environment.

Category: Databases & Data Stores

Tags: database, oracle, rdbms, SQL

Visit MCP Oracle Server

How to install and configure MCP Oracle Server

1. Clone the repository and install dependencies: sh git clone https://github.com/YrsonHTM/mcp-oracle-server.git cd mcp-oracle-server npm install 2. Open your client configuration file (e.g., ~/.cursor/mcp.json or %USERPROFILE%\.cursor\mcp.json for Cursor). 3. Register the server under the mcpServers section with your Oracle credentials and the path to server.js: json { "mcpServers": { "oracle-db": { "command": "node", "args": ["/path/to/mcp-oracle-server/server.js"], "env": { "ORACLE_HOST": "10.10.10.10", "ORACLE_PORT": "1521", "ORACLE_DATABASE": "pruebadb", "ORACLE_USER": "admin", "ORACLE_PASSWORD": "password" } } } } 4. Start the server using npm start or enable the configured server directly inside Cursor.

What you can do with MCP Oracle Server

• Running read-only SELECT queries to extract and inspect records from remote Oracle databases directly through AI prompts. - Exploring Oracle database schemas by retrieving lists of all accessible tables associated with the authenticated user account. - Describing the column structures and data types of specific Oracle database tables during application development workflows. - Assisting developers with diagnosing backend data anomalies and generating read-only analytical summaries inside Cursor.

Key facts

• https://github.com/YrsonHTM/mcp-oracle-server
• Databases & Data Stores
• database, oracle, rdbms, SQL

Part of MCP Servers

What can MCP Oracle Server do?

MCP Oracle Server provides three core tools to interact with Oracle databases: execute_query for running read-only SELECT statements, describe_table for inspecting table schemas, and list_tables for viewing all tables available to the user.

Does MCP Oracle Server allow data modification?

No. The server restricts SQL execution strictly to SELECT queries. It does not permit INSERT, UPDATE, DELETE, or DDL commands, preventing accidental data corruption or schema changes by AI assistants.

Which MCP clients work with MCP Oracle Server?

The server works with any MCP-compliant client that supports standard I/O (stdio) transport, such as Cursor. Configuration involves adding the server command, script path, and environment variables into the client MCP configuration file.

Is MCP Oracle Server open source?

Yes, MCP Oracle Server is open source and licensed under the MIT License. The code is available on GitHub for users to inspect, clone, and modify for their database environments.