Oracle Service Cloud MCP Server by CData

Name: Oracle Service Cloud MCP Server by CData
Author: CDataSoftware

@CDataSoftware

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

#oracle #service-cloud #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-service-cloud.prp"
      ]
    }
  }
}

ツール

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

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

概要

What is Oracle Service Cloud MCP Server by CData?

Oracle Service Cloud MCP Server by CData is a read-only Model Context Protocol (MCP) server that lets large language models (LLMs) like Claude Desktop query live Oracle Service Cloud data using natural language. It wraps the CData JDBC Driver for Oracle Service Cloud, exposing the data as relational SQL models without requiring SQL knowledge from the user.

How to use Oracle Service Cloud MCP Server by CData?

Clone the repository, build the JAR with mvn clean install, download and license the CData JDBC Driver for Oracle Service Cloud, configure a connection string via the driver’s utility, and create a .prp properties file with the JDBC URL. Then add the server to your AI client’s MCP configuration (e.g., claude_desktop_config.json) and launch the client. The server runs via stdio and must be on the same machine as the client.

Key features of Oracle Service Cloud MCP Server by CData

Read-only access to Oracle Service Cloud data.
Exposes live data as relational SQL models.
Supports natural language queries through AI clients.
Provides three tools: get_tables, get_columns, and run_query.
Built on the CData JDBC Driver for Oracle Service Cloud.
Licensed under MIT License.

Use cases of Oracle Service Cloud MCP Server by CData

Let support agents ask “How many open tickets do I have?” without writing SQL.
Enable executives to correlate closed won opportunities with account industry.
Provide AI assistants with up-to-date Oracle Service Cloud report data.
Embed live service cloud lookups into custom LLM-powered chatbots.

FAQ from Oracle Service Cloud MCP Server by CData

Is the server read-only or can it modify data?

The server is explicitly designed as read-only. For full CRUD and action capabilities, CData offers a separate beta MCP Server for Oracle Service Cloud.

What are the dependencies and runtime requirements?

You need Java, Maven (to build the JAR), and the CData JDBC Driver for Oracle Service Cloud (requires a license). The server runs on any platform that supports Java.

Where does the data actually live?

Data resides in Oracle Service Cloud. The server never stores data locally; all queries are executed live against the source via the JDBC driver.

What transport does the server use?

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

How do I authenticate to Oracle Service Cloud?

Authentication is configured through the JDBC connection string (e.g., using OAuth). The driver’s Connection String utility helps you set up and test the connection.

「データベース」の他のコンテンツ

Snowflake MCP Server

isaacwasserman

185

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412