OracleDB MCP Server

@rahgadda

リポジトリ

基本情報

カテゴリ

データベース

ライセンス

Apache-2.0

トランスポート

stdio

作者

rahgadda

OracleDB MCP Server について

MCP server to connect to Oracle Database

OracleDB MCP Server の設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

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

OracleDB MCP Server のツール

ツール一覧はまだありません

この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。

上のボタンで一時的なサンドボックスでこのサーバーを実行し、ツール一覧を取得できます。

概要

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.

よくある質問

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).