Use the oracle_analytics-discover_data MCP Server Tool (Preview)

The analytics-discover_data tool allows you to programmatically discover the available subject areas and datasets in an Oracle Analytics Cloud instance.

Input Schema

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "type": "object",
  "properties": {
    "fetchType": {
      "type": "string",
      "enum": ["subjectareas", "datasets", "all"],
      "description": "Controls which data sources to retrieve"
    }
  }
}

Parameters

Name	Type	Required or Optional	Default Value	Description
fetchType	String	Optional	"all"	Filter for data source type.

Allowed values for fetchType

• "subjectareas" - Returns only traditional subject areas.
• "datasets" - Returns only extended subject areas, files, data flows, connections, and so on.
• "all" - Returns both subject areas and datasets (Default).

JSON-RPC Request

{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "oracle_analytics-discover_data",
    "arguments": {
      "fetchType": "all"
    }
  }
}

Response Structure

{
  "Datasets": [
    {
      "displayName": "Chocolate Sales",
      "name": "'[email protected]'.'Chocolate Sales'",
      "description": "Uploaded from Chocolate Sales.csv.",
      "model": "custom",
      "type": "datasets"
    }
  ],
  "SubjectAreas": [
    {
      "name": "Sales History Subject Area",
      "description": "",
      "model": "Sales History",
      "type": "SubjectArea"
    }
  ]
}