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

数据库分类下的更多 MCP 服务器

golfdata.online - Verified Golf Clubs

golfdata.online

Verified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note