MCP Oracle Database Server

MCP Oracle Database Server is an MCP server that provides full integration with Oracle Database systems for Model Context Protocol clients. It connects AI assistants directly to local or remote Oracle instances, enabling database administrators, developers, and data analysts to inspect schemas, execute SQL queries, and manage transactional workloads through natural conversation. The server exposes specialized tools for running SELECT queries with configurable table or JSON output formatting, executing DML and DDL commands like INSERT, UPDATE, DELETE, and CREATE, and running multi-statement transactional operations with automatic rollback capabilities. In addition to data manipulation, the server allows clients to inspect database architecture by listing schema tables and retrieving column definitions and constraints. Built-in connection pooling handles resource management, statement caching, and timeouts efficiently. MCP Oracle Database Server also includes compatibility modes for older Oracle versions, such as Oracle 9g, 10g, and 11g, by supporting Thick connections via Oracle Instant Client libraries alongside standard Thin connections for modern Oracle 12c and higher databases. Diagnostics such as health checks and connection details provide status monitoring directly from client interfaces.

Category: Databases & Data Stores

Tags: database, oracle, rdbms, SQL

Visit MCP Oracle Database Server

How to install and configure MCP Oracle Database Server

1. Open the Claude Desktop configuration file for your operating system (%APPDATA%\Claude\claude_desktop_config.json on Windows, ~/Library/Application Support/Claude/claude_desktop_config.json on macOS, or ~/.config/claude/claude_desktop_config.json on Linux). 2. Register the server under the mcpServers object using npx and @grec0/mcp-oracle-db: json { "mcpServers": { "oracle-db": { "command": "npx", "args": ["@grec0/mcp-oracle-db"], "env": { "ORACLE_HOST": "localhost", "ORACLE_PORT": "1521", "ORACLE_SERVICE_NAME": "XE", "ORACLE_USERNAME": "hr", "ORACLE_PASSWORD": "hr" } } } } 3. If connecting to Oracle 9g or older versions, install Oracle Instant Client 19.26 and set ORACLE_OLD_CRYPTO to "true" and ORACLE_CLIENT_LIB_DIR to the local client directory in the env section. 4. Restart Claude Desktop and test database communication with the oracle_health_check tool.

What you can do with MCP Oracle Database Server

• Query database tables using SQL SELECT statements to retrieve formatted tabular or JSON results directly within an AI chat interface. - Inspect schema structure by listing database tables and viewing comprehensive table definitions, column types, and constraints across schemas. - Execute data modification and definition statements such as INSERT, UPDATE, DELETE, and CREATE TABLE with explicit commit control. - Run multi-command transactional sequences with automatic rollback functionality to ensure atomic data modifications during complex updates. - Connect legacy database instances like Oracle 9g or 11g using thick mode configuration and native Oracle Instant Client libraries.

Key facts

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

Part of MCP Servers

What tools are provided by MCP Oracle Database Server?

MCP Oracle Database Server provides seven primary tools for interacting with Oracle instances. These include oracle_query for running SELECT queries, oracle_execute for DML and DDL commands, oracle_transaction for grouped transactional commands with rollback, oracle_list_tables for listing schema objects, oracle_describe_table for viewing schema details, oracle_health_check for verifying database connectivity, and oracle_info for reviewing connection pool and configuration details.

How do I install MCP Oracle Database Server?

You install and run MCP Oracle Database Server directly through npx by referencing the @grec0/mcp-oracle-db package in your MCP client configuration file. Alternatively, you can clone the repository from GitHub, run npm install to install dependencies, configure your database credentials in an environment file, and compile the project locally using npm run build.

Which MCP clients work with MCP Oracle Database Server?

MCP Oracle Database Server works with any client compliant with the Model Context Protocol that supports standard input/output server processes. Tested configurations include Claude Desktop on Windows, macOS, and Linux, as well as the standard MCP Inspector used for testing and development. Any developer tool supporting the MCP protocol can integrate with it.

Does MCP Oracle Database Server support legacy Oracle databases?

Yes, the server supports legacy versions including Oracle 9g, 10g, and 11g. For Oracle 9g or environments with older cryptographic verifiers, users can configure thick mode by setting the ORACLE_OLD_CRYPTO environment variable to true and specifying the file path to a compatible Oracle Instant Client installation using ORACLE_CLIENT_LIB_DIR. Modern Oracle 12c and higher versions operate in thin mode without Instant Client.