Visible MCP Tool Metadata (Preview)

This topic describes the metadata for each exposed Oracle Analytics Cloud MCP tool.

The longer reference sections later in this guide add examples, usage guidance, and safety notes.

MCP Tool Name	Visible Description	Key Inputs	Output/Behavior
oracle_analytics-search_catalog	Search Oracle Analytics Cloud catalog objects across one or more types. Supports cursor-based pagination and basic sorting.	search type types rootFolder limit sortBy sortOrder cursor	Returns catalog items, effective sorting, pagination state, nextCursor, and hasMore. Items may include objectId, dataset xsaExpr, metadataResource, contentResource, and viewUrl.
oracle_analytics-find_matching_datasources	Finds matching data sources for a natural-language analytics question.	nl_question	Returns data sources matching the query intent, identified by name and described by displayName, description, and score when available. The datasets must be indexed for use with AI features. Datasets are indexed using the same indexing process that Oracle Analytics Cloud uses for its AI features.
oracle_analytics-describe_data	Retrieves comprehensive column-level metadata for OAC subject areas and datasets.	datamodelName tablesOnly tableName tableNames	Returns table and column metadata including names, display names, fully qualified names, column/measure classification, data type, aggregation metadata, nullable, precision, and scale.
oracle_analytics-execute_logical_sql	Executes an Oracle Analytics Cloud Logical SQL query against the configured OAC server and streams results.	query maxRows	Returns JSON query results, row data, execution statistics, or error details. Metadata includes extensive Logical SQL generation guidance.
oracle_analytics-save_catalog_content	Create or replace catalog content for workbooks or connections.	type name description content parentId id userApproved	Create mode creates a new item under parentId; replace mode updates an existing item by id. Workbook validation failures return VALIDATION_ERROR; upstream/blob failures return UPSTREAM_ERROR.
oracle_analytics-export_workbook	Export a workbook as a file in one long-running operation: create export, poll work request, fetch artifact.	workbookId format name canvasIds screenWidth screenHeight	Returns image content for PNG exports and embedded/blob PDF resource content for PDF exports.
oracle_analytics-create_catalog_folder	Create a catalog folder.	path parentId name createIntermediateFolders userApproved	Uses path-first resolution when path is provided. Returns standardized status, upstream status code, and created item metadata.
oracle_analytics-copy_catalog_item	Copy a catalog item.	type id destId destParentId newItemName overwrite createIntermediateFolders userApproved	Copies the source item to the requested destination and returns a standardized envelope with copied item payload.
oracle_analytics-move_catalog_item	Move a catalog item.	type id destId destParentId newItemName overwrite createIntermediateFolders userApproved	Moves the source item to the requested destination and returns a standardized envelope with moved item payload.
oracle_analytics-delete_catalog_item	Delete a catalog item by type.	type id recursive userApproved	Deletes folders, workbooks, or connections. Uses the shared catalog modification approval flow and returns a standardized delete outcome.
oracle_analytics-update_catalog_acl	Update ACL for a catalog item.	type id aclList updateMode recursive userApproved	Applies ACL updates using ReplaceAll, ReplaceMatchingAccounts, or DeleteMatchingAccounts; returns a standardized envelope with updated ACL payload.