Oracle SCM MCP Server by CData

Name: Oracle SCM MCP Server by CData
Author: CDataSoftware

@CDataSoftware

About Oracle SCM 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 SCM (beta): https://www.cdata.com/download/download.aspx?sku=KSZK-V&type=beta

#oracle-scm #mcp-server #cdata

Basic information

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-scm.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 SCM MCP Server by CData?

Oracle SCM MCP Server by CData is a read-only MCP server that allows LLMs like Claude Desktop to query live Oracle SCM data using the CData JDBC Driver for Oracle SCM. It wraps the JDBC driver and exposes Oracle SCM as a relational SQL model, enabling natural language queries without needing to write SQL directly.

How to use Oracle SCM MCP Server by CData?

Clone the repository, build with Maven (mvn clean install), download and install the CData JDBC Driver for Oracle SCM, license the driver, create a .prp file with connection properties, then configure the server in Claude Desktop’s claude_desktop_config.json. Run the server via java -jar CDataMCP-jar-with-dependencies.jar <prp-file>.

Key features of Oracle SCM MCP Server by CData

Read-only access to Oracle SCM data via MCP.
Uses CData JDBC Driver for Oracle SCM.
Exposes relational SQL models for Oracle SCM.
Supports natural language queries through LLM clients.
Provides tools: get_tables, get_columns, run_query.
MIT-licensed server; JDBC driver requires separate license.

Use cases of Oracle SCM MCP Server by CData

Ask an AI assistant to retrieve live Oracle SCM data in natural language.
Explore available tables and columns in Oracle SCM without manual configuration.
Run ad‑hoc SQL SELECT queries on Oracle SCM through a conversational interface.
Integrate Oracle SCM data into AI‑driven analytics workflows.

FAQ from Oracle SCM MCP Server by CData

What does this server do that alternatives don’t?

It provides a read-only MCP interface to Oracle SCM using CData’s JDBC driver, letting LLMs query live data with natural language. Full CRUD and simplified setup are available in the separate CData MCP Server for Oracle SCM (beta).

What are the runtime requirements?

Java is required to run the server. The CData JDBC Driver for Oracle SCM must be installed and licensed (trial or full key). The server uses stdio transport, so the client must run on the same machine.