About the Tools Available With Oracle Analytics Cloud MCP Server

The Oracle Analytics Cloud MCP server provides a set of tools that allows you to explore data within your Oracle Analytics Cloud instance.

With these tools, you can discover which datasets or subject areas are available in Oracle Analytics Cloud, describe them to the LLM or AI model, and allow the client to generate and run Logical SQL.

Oracle Analytics Cloud MCP server provides these tools:

• Discover (oracle_analytics-discoverData) - List available datasets and subject areas. This helps AI clients identify what data exists.
• Describe (oracle_analytics-describeData) - Retrieves dataset metadata (tables, columns, measures, and hierarchies) available for logical SQL and natural language queries.
• Execute (oracle_analytics-executeLogicalSQL) - Runs governed logical SQL queries generated by oracle_analytics-generateLogicalSQL.