Oracle MCP Server by CData

@CDataSoftware

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

CDataSoftware

提交者

Cameron Leblanc

关于 Oracle MCP Server by CData

This project builds a read-only MCP server. For full read, write, update, delete, and action capabilities and a simplified setup, check out our free [CData MCP Server for Oracle (beta)](https://www.cdata.com/download/download.aspx?sku=SOZK-V&type=beta).

#oracle #mcp-server #cdata

Oracle MCP Server by CData 配置

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

{
  "mcpServers": {
    "{classname_dash}": {
      "command": "PATH\\TO\\java.exe",
      "args": [
        "-jar",
        "PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
        "PATH\\TO\\oracle.prp"
      ]
    }
  }
}

Oracle MCP Server by CData 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

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

概览

What is Oracle MCP Server by CData?

CData's read-only Model Context Protocol (MCP) server that enables LLMs like Claude Desktop to query live Oracle data using natural language. It wraps the CData JDBC Driver for Oracle and exposes the database as relational SQL models through a simple MCP interface.

How to use Oracle MCP Server by CData?

Clone the repository, build the JAR with mvn clean install, download and license the CData JDBC Driver for Oracle, create a .prp file with your JDBC connection string, then configure your MCP client (e.g., Claude Desktop's claude_desktop_config.json) to point to the JAR and .prp file. The server runs via stdio on the same machine as the client.

Key features of Oracle MCP Server by CData

Read-only access to live Oracle data via MCP
Natural language querying — no SQL required
Built on the CData JDBC Driver for Oracle
Provides get_tables, get_columns, and run_query tools
Open source under the MIT License

Use cases of Oracle MCP Server by CData

Ask an LLM to analyze correlations between Oracle data fields
Retrieve live counts of records (e.g., tickets, opportunities) from Oracle
Explore Oracle table schemas and columns through conversational AI

常见问题

Is this server read-only?

Yes, this server is read-only. For full create, read, update, and delete capabilities, CData offers a separate beta MCP Server for Oracle.

What dependencies are required?

You need Java, Maven, and the CData JDBC Driver for Oracle (available for download and trial licensing from CData).

What transport does the server use?

The server uses `stdio` transport, so it can only be used with clients running on the same machine.

How do I troubleshoot connection issues?

Verify your connection string using the CData JDBC Driver's Connection String utility, ensure the driver is properly licensed, and fully quit and restart your client (e.g., Claude Desktop) after configuration changes.

Where can I get support?

For connection issues, contact the CData Support Team. For MCP server usage or feedback, join the CData Community.

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

Lawstronaut

Lawstronaut-FZCO

Access millions of official legal and regulatory source documents from 155+ jurisdictions via MCP. Lawstronaut supports AI agents with structured legal research, legal data, laws, regulations, cases, guidance, official s