databases

OracleDB▌

by rahgadda

OracleDB bridges Oracle Database and cloud integrations, enabling secure queries, dynamic metadata discovery, and seamle

Provides a bridge to Oracle Database, enabling dynamic table and column discovery, secure query execution, and metadata retrieval through natural language interactions for data analysts and developers.

github stars

★ 36

GitHub npm

Dynamic schema discoveryWhitelist security controls

best for

/ Data analysts querying Oracle databases conversationally
/ Developers building Oracle database integrations
/ Business users exploring Oracle data without writing SQL

capabilities

/ Discover Oracle database tables and columns dynamically
/ Execute SQL queries securely on Oracle databases
/ Retrieve database metadata and schema information
/ Generate SQL statements from natural language prompts
/ Filter accessible tables and columns with whitelist controls

installation

Select a client to integrate this server.

Claude Desktop configuration

{
  "mcpServers": {
    "oracledb_mcp_server": {
      "command": "uv",
      "args": [
        "run",
        "oracledb_mcp_server"
      ],
      "env": {
        "DEBUG": "True",
        "COMMENT_DB_CONNECTION_STRING": "oracle\u002Boracledb://USERNAME:PASSWORD@IP:PORT/?service_name=SERVICENAME",
        "DB_CONNECTION_STRING": "oracle\u002Boracledb://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"
      }
    }
  }
}

what it does

Connects LLMs to Oracle Database, allowing them to discover tables/columns and execute SQL queries through natural language conversations.

about

OracleDB is a community-built MCP server published by rahgadda that provides AI assistants with tools and capabilities via the Model Context Protocol. OracleDB bridges Oracle Database and cloud integrations, enabling secure queries, dynamic metadata discovery, and seamle It is categorized under databases.

how to install

You can install OracleDB in your AI client of choice. Use the install panel on this page to get one-click setup for Cursor, Claude Desktop, VS Code, and other MCP-compatible clients. This server runs locally on your machine via the stdio transport.

license

Apache-2.0

OracleDB is released under the Apache-2.0 license. This is a permissive open-source license, meaning you can freely use, modify, and distribute the software.

readme

OracleDB MCP Server

Overview

This project will install MCP - Model Context Protocol Server, that provides configured Oracle Database Table/Columns as context to LLM's.
Using this we can enable LLMs to interact with Oracle Database, Generate SQL Statements and Return Results using LLM prompts.

Installation

Install package
```
pip install oracledb_mcp_server
```
Create .env in a folder with minimum value of Oracle DB Connection String. Sample file available here
Test oracledb_mcp_server server using uv run oracledb_mcp_server from the above folder.

Claud Desktop

Configuration details for Claud Desktop

{
  "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
- DEBUG: Enable debug logging (optional default is False)
- COMMENT_DB_CONNECTION_STRING: Oracle DB connection String for comments. (required)
- DB_CONNECTION_STRING: Oracle DB connection String for execution of queries. (required)
- TABLE_WHITE_LIST: White Listed table names in list format ["table1", "table2"] (required)
- COLUMN_WHITE_LIST: White Listed table-column names in list format ["table.column1", "table.column2"] (required)
- QUERY_LIMIT_SIZE: Default value is 10 records if not provided(optional default is 10)

Interceptor

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