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.
コメント