Oracle SCM MCP Server by CData
@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
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.
How is the data accessed and where does it live?
Data is accessed live from Oracle SCM through the JDBC driver. The server does not store data; it queries the source system each time.
What are the known limits?
This version is read-only; write, update, delete, and action capabilities are not available. The server uses stdio transport only.
What authentication or transport is supported?
The server relies on the JDBC connection string for authentication (e.g., OAuth). The MCP transport is stdio.
Frequently asked questions
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.
How is the data accessed and where does it live?
Data is accessed live from Oracle SCM through the JDBC driver. The server does not store data; it queries the source system each time.
What are the known limits?
This version is read-only; write, update, delete, and action capabilities are not available. The server uses `stdio` transport only.
What authentication or transport is supported?
The server relies on the JDBC connection string for authentication (e.g., OAuth). The MCP transport is `stdio`.
Basic information
More Databases MCP servers
Multi Database MCP Server
FreePeakA powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.
Chroma MCP Server
chroma-coreA Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma
Elasticsearch MCP Server
elastic
PostgreSQL
modelcontextprotocolModel Context Protocol Servers
mcp_mysql_server
xwb602625136Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼!更加好用!不仅止于mysql的增删改查功能; 还包含了数据库异常分析能力;且便于开发者们进行个性化的工具扩展
Comments