home / mcp / oracle hcm cloud mcp server

Oracle HCM Cloud MCP Server

This read-only MCP Server allows you to connect to Oracle HCM Cloud data from Claude Desktop through CData JDBC Drivers. For full CRUD support, check out the first managed MCP platform: CData Connect AI (https://www.cdata.com/ai/).

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "cdatasoftware-oracle-hcm-cloud-mcp-server-by-cdata": {
      "command": "java",
      "args": [
        "-jar",
        "CDataMCP-jar-with-dependencies.jar",
        "/PATH/TO/oracle-hcm-cloud.prp"
      ]
    }
  }
}

You can query live Oracle HCM Cloud data through a local, read-only MCP server that wraps the CData JDBC Driver. This server exposes Oracle HCM Cloud data via a simple MCP interface, enabling LLMs and clients to ask natural language questions and retrieve up-to-date information without writing SQL. It provides a practical way to access live data securely on your machine for testing and experimentation.

How to use

Once the MCP server is running, connect your MCP client to the local server to ask questions about Oracle HCM Cloud data. You do not need to write SQL; instead, you ask in plain language and the client translates your requests into data queries. Typical use cases include fetching lists of records, inspecting related data across tables, and asking for counts, aggregates, or recent activity. The server presents results in a structured format suitable for display in your AI assistant or analysis tool.

Available tools

oraclehcm_cloud_get_tables

Retrieves a list of tables available in the Oracle HCM Cloud data source. The output is returned in CSV format with the first line containing column headers.

oraclehcm_cloud_get_columns

Retrieves a list of columns for a specified table. The output is returned in CSV format with the first line containing column headers.

oraclehcm_cloud_run_query

Executes a SQL SELECT query against the Oracle HCM Cloud data model exposed by the MCP server.