Oracle Service Cloud MCP Server by CData
@CDataSoftware
About 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
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-service-cloud.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 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, andrun_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.
More Databases MCP servers
mcp_mysql_server
xwb602625136Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼!更加好用!不仅止于mysql的增删改查功能; 还包含了数据库异常分析能力;且便于开发者们进行个性化的工具扩展
Postgres Mcp
crystaldbaPostgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.
MotherDuck's DuckDB MCP Server
motherduckdbLocal MCP server for DuckDB and MotherDuck
MCP Server for MySQL based on NodeJS
benborlaA Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.
Redis MCP Server
redisThe official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently
Comments