OracleDB MCP Server

Name: OracleDB MCP Server
Author: rahgadda

@rahgadda

代码仓库

关于 OracleDB MCP Server

MCP server to connect to Oracle Database

基本信息

分类

数据库

许可证

Apache-2.0

运行时

python

传输方式

stdio

发布者

rahgadda

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "oracledb_mcp_server": {
      "command": "npx",
      "args": [
        "@modelcontextprotocol/inspector",
        "uv",
        "--directory",
        "D:\\MyDev\\mcp\\oracledb_mcp_server",
        "run",
        "-m",
        "oracledb_mcp_server"
      ]
    }
  }
}

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is OracleDB MCP Server?

A Model Context Protocol (MCP) server that exposes configured Oracle Database tables and columns as context for large language models (LLMs). It enables LLMs to interact with an Oracle database by generating SQL statements and returning query results from natural language prompts.

How to use OracleDB MCP Server?

Install the Python package via pip install oracledb_mcp_server, create a .env file with the required Oracle DB connection string, and test the server with uv run oracledb_mcp_server. For Claude Desktop, add the JSON configuration shown in the README, specifying both a connection string for comments and one for query execution, along with whitelisted tables and columns.

Key features of OracleDB MCP Server

Provides Oracle database schema as context to LLMs.
Generates SQL statements from natural language prompts.
Returns query results directly to the LLM.
Configurable whitelist of tables and columns.
Separate connection strings for metadata comments and queries.
Optional debug logging and configurable result limit (default 10).

Use cases of OracleDB MCP Server

Chat with an Oracle database using natural language.
Automate SQL query generation and execution for reporting.
Enable LLM-powered data exploration without writing raw SQL.
Integrate Oracle database context into AI assistants like Claude Desktop.

FAQ from OracleDB MCP Server

What dependencies are required to run OracleDB MCP Server?

Python and the uv package manager are required. You also need access to an Oracle database with valid connection strings.

How do I configure the server for my Oracle database?

Set the DB_CONNECTION_STRING and COMMENT_DB_CONNECTION_STRING environment variables with your Oracle credentials and service name. Also specify required whitelists: TABLE_WHITE_LIST (table names) and COLUMN_WHITE_LIST (table.column pairs).

What is the QUERY_LIMIT_SIZE setting and what is its default?

QUERY_LIMIT_SIZE limits the number of rows returned by queries. It is optional and defaults to 10 records.

Are there any security or access controls built in?

The server uses whitelists (TABLE_WHITE_LIST and COLUMN_WHITE_LIST) to restrict which database objects the LLM can access. Credentials are provided via environment variables.

What transport or authentication protocol does the server use?

The server follows the Model Context Protocol (MCP) standard. Authentication to the Oracle database is handled via the provided connection strings (username/password in the DSN).