Quick Reference (Preview)

Use this quick reference to identify the recommended Oracle Analytics Cloud MCP tool sequences for common tasks, including data discovery, catalog management, and Logical SQL generation.

Read-Only Discovery

search_catalog -> describe_data -> execute_logical_sql
find_matching_datasources -> describe_data -> execute_logical_sql
search_catalog -> export_workbook

Catalog Management

search_catalog -> create_catalog_folder
search_catalog -> copy_catalog_item
search_catalog -> move_catalog_item
search_catalog -> delete_catalog_item
search_catalog -> update_catalog_acl

Minimum Metadata Loop Before Writing Logical SQL

1. search_catalog for subject areas or datasets
2. describe_data with tablesOnly
3. describe_data with tableName or tableNames
4. generate Logical SQL with fully qualified columns
5. execute_logical_sql with maxRows and FETCH FIRST