Use This MCP server To

Query Oracle databases directly from LLM-powered applications Retrieve structured data from Oracle DB for real-time analysis Integrate Oracle DB access into AI workflows and agents Enable LLMs to execute SQL queries on Oracle databases Automate data extraction from Oracle for reporting Combine Oracle data with other MCP data sources for enriched context

README

mcp-server-oracle

Model Context Protocol server to access oracle

Python 3.12 License: MIT

Demos

mpc-server-oracle.mp4

Quickstart

To try this in Claude Desktop app, add this to your claude config files:

{
  "mcpServers": {
    "mcp-server-oracle": {
      "command": "uvx",
      "args": [
        "mcp-server-oracle"
      ],
      "env": {
        "ORACLE_CONNECTION_STRING": "username/password@hostname:port/service_name"
      }
    }
  }
}

Prerequisites

UV (pacakge manager)
Python 3.12+
Claude Desktop

Installation

Claude Desktop Configuration

Add the server configuration to your Claude Desktop config file:

MacOS: ~/Library/Application\ Support/Claude/claude_desktop_config.json
Windows: %APPDATA%/Claude/claude_desktop_config.json

Contributing

Fork the repository from mcp-server-oracle
Create your feature branch
Commit your changes
Push to the branch
Open a Pull Request

License

This project is licensed under the MIT License - see the LICENSE file for details.

mcp-server-oracle FAQ

How do I configure the Oracle connection string for mcp-server-oracle?

Set the ORACLE_CONNECTION_STRING environment variable with the format username/password@hostname:port/service_name.

What are the prerequisites for running mcp-server-oracle?

You need Python 3.12 or higher, the UV package manager, and a compatible MCP host like Claude Desktop.

Can mcp-server-oracle be used with LLM providers other than Claude?

Yes, it supports any MCP-compatible host and can work with models from OpenAI, Claude, Gemini, and others.

Is mcp-server-oracle secure for production use?

It follows MCP principles for scoped and secure model interaction, but you should secure your Oracle credentials and network access appropriately.

How do I install mcp-server-oracle?

Install Python 3.12+, use UV package manager to install dependencies, and configure your MCP host to launch the server with the Oracle connection string.

Does mcp-server-oracle support executing arbitrary SQL queries?

Yes, it allows LLMs to run SQL queries on the connected Oracle database within the scope of the MCP protocol.

Can I use mcp-server-oracle on platforms other than MacOS?

Yes, it is cross-platform as long as Python 3.12+ and the required dependencies are installed.

How does mcp-server-oracle handle query results?

It returns structured query results in a format consumable by MCP clients and LLMs for further processing.