Rahgadda Oracledb MCP Server

🚀 OracleDB MCP Server

This project installs the MCP - Model Context Protocol Server, which provides configured Oracle database tables/columns as context for large language models (LLMs). With this project, we can enable LLMs to interact with Oracle databases, generate SQL statements, and return results.

🚀 Quick Start

The OracleDB MCP Server allows LLMs to interact with Oracle databases, generate SQL statements, and return results.

✨ Features

• Installs the MCP - Model Context Protocol Server.
• Provides configured Oracle database tables/columns as context for LLMs.
• Enables LLMs to interact with Oracle databases, generate SQL statements, and return results.

📦 Installation

Install the Package

pip install oracledb_mcp_server

Create an Environment File

Create a .env file containing the minimum Oracle DB Connection String. You can download an example file here.

Test the Server

Run the following command from the above folder to test the oracledb_mcp_server:

uv run oracledb_mcp_server

💻 Usage Examples

Claud Desktop Configuration

The configuration details for Claud Desktop are as follows:

{
    "mcpServers": {
        "oracledb_mcp_server":{
            "command": "uv",
            "args": ["run","oracledb_mcp_server"],
            "env": {
                "DEBUG":"True",
                "COMMENT_DB_CONNECTION_STRING":"oracle+oracledb://USERNAME:PASSWORD@IP:PORT/?service_name=SERVICENAME",
                "DB_CONNECTION_STRING":"oracle+oracledb://USERNAME:PASSWORD@IP:PORT/?service_name=SERVICENAME",
                "TABLE_WHITE_LIST":"ACCOUNTS,CUS_ACC_RELATIONS,CUSTOMERS",
                "COLUMN_WHITE_LIST":"ACCOUNTS.ACC_AAD_ID,CUS_ACC_RELATIONS.CAR_CUS_ID,CUS_ACC_RELATIONS.CAR_AAD_ID,CUSTOMERS.CUS_ID"
            }
        }
    }
}

Configuration

The list of available environment variables is as follows:

Interceptor

npx @modelcontextprotocol/inspector uv --directory "D:\\MyDev\\mcp\\oracledb_mcp_server" run -m oracledb_mcp_server

🤝 Contribution

Contributions are welcome. Please feel free to submit a Pull Request.

📄 License

This project is licensed under the terms of the MIT License.

🎥 Demo

⭐ Github Stars