Oracledb MCP Server

🚀 OracleDB MCP Server

This project installs the MCP - Model Context Protocol Server, which provides configured Oracle database tables/fields as context for Large Language Models (LLMs). With this functionality, LLMs can interact with Oracle databases, generate SQL statements, and return results.

🚀 Quick Start

✨ Features

• Install the MCP - Model Context Protocol Server to offer Oracle database table/field context for LLMs.
• Enable LLMs to interact with Oracle databases, generate SQL statements, and obtain results.

📦 Installation

1. Install the package:

pip install oracledb_mcp_server

2. Create a .env file containing the minimum Oracle DB connection string. You can download an example file here.
3. Test the oracledb_mcp_server using the following command:

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

List of available environment variables:

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

🔗 Smithery Badge