Available Oracle Analytics Cloud MCP Tools (Preview)
The raw MCP tool names use a hyphen after the oracle_analytics prefix. Codex normalizes tool identifiers to underscores in its generated function namespace, so oracle_analytics-describe_data appears in Codex as mcp__oac_mcp.oracle_analytics_describe_data. Use the raw MCP name in JSON-RPC tools/call payloads.
| MCP Tool Name | Visible Metadata Status | Purpose | Modifies Oracle Analytics Cloud? * | Approval Required |
|---|---|---|---|---|
oracle_analytics-search_catalog |
Experimental | Search catalog objects such as workbooks, folders, datasets, connections, subject areas, analyses, reports, dashboards, and scripts. | No | No |
oracle_analytics-find_matching_datasources |
- | Match a natural-language question to relevant OAC data sources. | No | No |
oracle_analytics-describe_data |
- | Retrieve table and column metadata for subject areas or datasets. | No | No |
oracle_analytics-execute_logical_sql |
- | Execute Oracle Analytics Logical SQL and return query results. | No | No |
oracle_analytics-save_catalog_content |
Experimental | Create or replace workbook or connection catalog content | Yes | Yes |
oracle_analytics-export_workbook |
Experimental | Export a workbook to PNG or PDF. | No, but starts an export job | No |
oracle_analytics-create_catalog_folder |
Experimental | Create a catalog folder. | Yes | Yes |
oracle_analytics-copy_catalog_item |
Experimental | Copy a catalog item. | Yes | Yes |
oracle_analytics-move_catalog_item |
Experimental | Move a catalog item. | Yes | Yes |
oracle_analytics-delete_catalog_item |
Experimental | Delete a catalog item. | Yes | Yes |
oracle_analytics-update_catalog_acl |
Experimental | Update catalog permissions. | Yes | Yes |
*Here modifying Oracle Analytics Cloud means that a change is made to the Oracle Analytics Cloud catalog.
Modification tools require userApproved: true or an explicit approval flow. Treat create, replace, move, copy, delete, and ACL operations as production-impacting actions
Experimental tools are marked in the visible MCP metadata with:
