MCP.so
Sign In
O

Oracle MCP Server by CData

@CDataSoftware

Repository

About 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

Basic information

Category

Databases

Transports

stdio

Publisher

CDataSoftware

Submitted by

Cameron Leblanc

Config

Add this server to your MCP-compatible client using the configuration below.

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

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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

FAQ from Oracle MCP Server by CData

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.

Comments

More Databases MCP servers

MongoDB Lens

furey

🍃🔎 MongoDB Lens: Full Featured MCP Server for MongoDB Databases

204

Meilisearch MCP Server

meilisearch

A Model Context Protocol (MCP) server for interacting with Meilisearch through LLM interfaces.

193

Elasticsearch/OpenSearch MCP Server

cr7258

A Model Context Protocol (MCP) server implementation that provides Elasticsearch and OpenSearch interaction.

295

Redis MCP Server

redis

The official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently

539

mcp_mysql_server

xwb602625136

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能； 还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245