Oracle Epm MCP Server

Connect Claude AI (or any MCP-compatible client) to Oracle EPM Cloud via REST APIs.

Local serverstdioGo

What is the Oracle Epm MCP Server?

Connect Claude AI (or any MCP-compatible client) to Oracle EPM Cloud via REST APIs.

What it actually does

This server is part of an ongoing series on connecting AI agents to Oracle EPM Cloud. For more Oracle EPM content, tutorials, and tools:

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

Recorded tools

Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.

ToolWhat it does
get_api_versionTest connectivity, discover API versions
list_applicationsList all EPM applications
get_substitution_variablesRead current month, year, scenario variables
run_business_ruleExecute a calc script or business rule
check_job_statusPoll whether a job completed or errored
export_data_slicePull data from the cube by dimension members
update_substitution_variableChange a substitution variable value

How to install the Oracle Epm MCP Server

{
  "mcpServers": {
    "oracle-epm-cloud": {
      "command": "node",
      "args": [
        "/FULL/PATH/TO/oracle-epm-mcp-server/server/index.js"
      ]
    }
  }
}

From the project documentation. Replace placeholders and example paths before connecting.

Example prompts to try

  • “Use Oracle Epm to get api version.”
  • “Use Oracle Epm to list applications.”
  • “Use Oracle Epm to get substitution variables.”

Frequently asked questions

Connect Claude AI (or any MCP-compatible client) to Oracle EPM Cloud via REST APIs. Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.