Oracle SCM MCP Server by CData

Name: Oracle SCM MCP Server by CData
Author: CDataSoftware

@CDataSoftware

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

基本情報

カテゴリ

データベース

トランスポート

stdio

公開者

CDataSoftware

投稿者

Cameron Leblanc

設定

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

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

ツール

ツールは検出されませんでした

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

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.