Connect Claude AI (or any MCP-compatible client) to Oracle EPM Cloud via REST APIs.
Connect Claude AI (or any MCP-compatible client) to Oracle EPM Cloud via REST APIs. The oracle epm mcp server wraps that behind the Model Context Protocol, so an assistant can use it through 7 defined tools rather than through you.
This server is part of an ongoing series on connecting AI agents to Oracle EPM Cloud. For more Oracle EPM content, tutorials, and tools:
Everything the assistant can do here goes through one of these:
get_api_version — Test connectivity, discover API versionslist_applications — List all EPM applicationsget_substitution_variables — Read current month, year, scenario variablesrun_business_rule — Execute a calc script or business rulecheck_job_status — Poll whether a job completed or erroredexport_data_slice — Pull data from the cube by dimension membersupdate_substitution_variable — Change a substitution variable valueYou will need 5 environment variables: EPM_MODE, EPM_BASE_URL, EPM_USERNAME, EPM_PASSWORD, EPM_APP_NAME. The server will not start without them, which is usually why the tools fail to appear on a first run. Keep credentials in your client's env block or a secrets manager rather than in a file you might commit.
Setup follows the usual MCP pattern — install or clone the server, register it in your client's configuration file, restart the client. The configuration blocks on this page cover the common clients.
Plenty of developer tooling servers cover similar ground. The differences that matter in practice are scope of access and how much setup stands between you and a working tool call. Oracle Epm's toolset — get_api_version, list_applications, get_substitution_variables and 4 more — is a fair guide to whether it matches your workflow. It is maintained by fmepm; worth a glance at recent repository activity before you build anything load-bearing on it.
SyncDev reviews every entry in this directory against the project's own documentation before publishing, and revisits them as servers change.
| Tool | What it does |
|---|---|
| get_api_version | Test connectivity, discover API versions |
| list_applications | List all EPM applications |
| get_substitution_variables | Read current month, year, scenario variables |
| run_business_rule | Execute a calc script or business rule |
| check_job_status | Poll whether a job completed or errored |
| export_data_slice | Pull data from the cube by dimension members |
| update_substitution_variable | Change a substitution variable value |
Mac example:
```json
{
"mcpServers": {
"oracle-epm-cloud": {
"command": "node",
"args": ["/Users/fred/oracle-epm-mcp-server/server/index.js"]
}
}
}Configuration as documented by the project. Restart the client after saving.
| Variable | Description | Required |
|---|---|---|
| EPM_MODE | Configuration value read at startup. | Optional |
| EPM_BASE_URL | Endpoint or connection string the server talks to. | Yes |
| EPM_USERNAME | Configuration value read at startup. | Optional |
| EPM_PASSWORD | Configuration value read at startup. | Optional |
| EPM_APP_NAME | Configuration value read at startup. | Optional |
Kill hallucinated APIs — version-accurate, up-to-date library documentation injected straight into context.
Microsoft's official browser automation server — drive a real browser through the accessibility tree, no screenshots needed.
GitHub's official server — repos, issues, pull requests, Actions and code security, straight from your assistant.
Issue tracking at the speed of conversation — Linear's official hosted server with OAuth and zero install.
Local repository surgery — status, diffs, commits, branches and history for any repo on disk.
Timezone sanity for AI — current time anywhere and correct conversions, without the model doing date math.