OracleDB

Community

rahgadda

MCP server to connect to Oracle Database

Publisher	rahgadda
Repository	`oracledb_mcp_server`
Language	Python
Forks	11
Stars	35
Available tools	0
Transport type	stdio
Categories	Databases
License	Apache-2.0
Links	GitHub

Connect tools to AI workflows
OracleDB exposes MCP capabilities that can be used by compatible AI clients and agents.
0 available tools
Browse the callable actions below, including names and descriptions when provided by the server.
Ready-to-copy setup
Use the installation snippets to configure this server in your preferred MCP client.
Open source signals
35 stars and 11 forks from the linked repository.

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

bash
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

json
{
  "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

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

Contributing

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

Installation

TypingMind

Prerequisites:

Node.js 18+

{
  "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"
      }
    }
  }
}

Use OracleDB MCP with multiple AI models

TypingMind connects MCP tools at the workspace level, so once OracleDB is connected, you can use it with different AI models in TypingMind instead of setting it up separately for each model. This MCP runs locally through the TypingMind MCP connector on your device.

Setup guide to use the local connector

Use this when the MCP server needs access to local files, apps, or private resources on your computer.

Open the MCP settings

In TypingMind, go to Settings, Advanced Settings, then Model Context Protocol and choose Setup Connector.

Open TypingMind in your browser.
Click the Settings icon.
Go to Advanced Settings.
Open the Model Context Protocol section.
Click Setup Connector and choose This Device.

TypingMind MCP connector setup screen with This Device selected

Run the connector command

Choose This Device, copy the command from TypingMind, and run it in Terminal. Keep the process running while you use MCP.

Copy the setup command shown by TypingMind.
Open Terminal on macOS or Windows Terminal on Windows.
Paste and run the command.
Approve the package install if Terminal asks you to proceed.
Keep the Terminal window running while using MCP tools.

Add OracleDB as a server

When the connector status is Ready, click Edit Servers and paste the MCP server configuration.

Wait until the connector status shows Ready.
Click Edit Servers.
Paste the OracleDB MCP server configuration.
Save the server list.
Refresh if you want to confirm the connector is still ready.

TypingMind MCP settings showing active server and Edit Servers button

Use it across models

Save the server list, open Plugins, enable the OracleDB MCP tools, then select any supported AI model in TypingMind and use the tools in chat or assign them to an AI agent.

Open the Plugins page in TypingMind.
Enable the OracleDB MCP tools.
Start a chat and choose the AI model you want to use.
Use the MCP tools in chat or assign them to an AI agent.
Switch to another AI model whenever needed without reconnecting MCP.

TypingMind chat using enabled MCP tools with a selected AI model

Frequently asked questions

What is the OracleDB MCP server used for?

OracleDB is an MCP server that lets compatible AI clients connect to external tools and context. In TypingMind, you can add this MCP server once and make its tools available in your AI workspace.

Can I use OracleDB MCP with multiple AI models in TypingMind?

Yes. TypingMind connects MCP tools at the workspace level, so you can use OracleDB with different AI models such as Claude, ChatGPT, Gemini, or other models you have configured in TypingMind without setting up the MCP server separately for each model.

Why use OracleDB MCP with TypingMind?

TypingMind is one of the best frontends for LLM chat because it brings multiple AI models, prompts, plugins, AI agents, API keys, and MCP tools into one workspace. With OracleDB connected, you can use its MCP tools across your preferred models while keeping your chat workflow organized in TypingMind.

How do I connect OracleDB MCP to TypingMind?

OracleDB runs through the TypingMind local MCP connector. This is best when the MCP server needs access to local files, desktop apps, command-line tools, or private resources on your computer.

What tools does OracleDB MCP provide in TypingMind?

OracleDB exposes MCP capabilities that can be enabled from the TypingMind Plugins page and used in chat or assigned to AI agents.

Do I need to share my API keys with TypingMind to use OracleDB MCP?

No. TypingMind is local-first and lets you keep your model providers, API keys, prompts, and MCP configuration under your control. If OracleDB requires authentication, add the required headers, OAuth settings, or local configuration for that MCP server when you create the connection.

Related MCP Servers

View all

Google GenAI Toolbox

googleapis

OrganizationPopular

MCP Toolbox for Databases is an open source MCP server for databases.

DBHub (Universal Database Gateway)

bytebase

OrganizationPopular

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

Postgres MCP Pro

Postgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.

Supabase MCP Server

Connect Supabase to your AI assistants

OracleDB MCP Server

Overview

Installation

Claud Desktop

Configuration

Interceptor

Contributing

License

Demo

Github Stars

Installation

Use OracleDB MCP with multiple AI models

Setup guide to use the local connector

Open the MCP settings

Run the connector command

Add OracleDB as a server

Use it across models

Frequently asked questions

Related MCP Servers

Set up your own AI workspace now