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 | Purpose | Modifies Oracle Analytics Cloud? * | Approval Required |
|---|---|---|---|
oracle_analytics-search_catalog |
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_oac_ansi_sql |
Execute OAC ANSI SQL. Default for standard analytical queries. | No | No |
oracle_analytics-execute_logical_sql |
Execute Oracle Analytics Logical SQL and return query results. | No | No |
oracle_analytics-save_catalog_content |
Create or replace workbook or connection catalog content. ** | Yes | Yes |
oracle_analytics-export_workbook |
Export a workbook to PNG or PDF. ** | No, but starts an export job | No |
oracle_analytics-create_catalog_folder |
Create a catalog folder. ** | Yes | Yes |
oracle_analytics-copy_catalog_item |
Copy a catalog item. ** | Yes | Yes |
oracle_analytics-move_catalog_item |
Move a catalog item. ** | Yes | Yes |
oracle_analytics-delete_catalog_item |
Delete a catalog item. ** | Yes | Yes |
oracle_analytics-update_catalog_acl |
Update catalog permissions. ** | Yes | Yes |
* 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
** Identifies an experimental MCP tool. Experimental tools are marked in the visible MCP metadata with:
