READ-ONLY access to a SIAG analytics server: query business indicators and explore the data model. Operations: health, get_me, query, drill, navigate, inspect, dsl. The "dsl" parameter carries a SIAG DSL statement (e.g. "QUERY roi PERIOD 2024 GRANULARITY monthly", "DRILL ventas BY DIMENSION region LAST 12 MONTHS", "INSPECT INDICATORS"). Write operations (CREATE/ALTER/DROP/LOAD/DEFINE/...) are rejected client-side. Auth is automatic via the SIAG_EMAIL/SIAG_PASSWORD/SIAG_TENANT env vars.
SIAG DSL statement to run (required for query/drill/navigate/inspect/dsl). Read-only only. Examples: "QUERY roi PERIOD 2024 GRANULARITY monthly"; "DRILL ventas BY DIMENSION region LAST 12 MONTHS"; "INSPECT INDICATORS"; "INSPECT INDICATOR roi"; "INSPECT TABLES"; "INSPECT DIMENSIONS OF ventas". Multiple statements may be separated by newlines.
Discovery hint: Install with ppm install mcp-siag-query or invoke remotely via POST /v1/invoke/mcp-siag-query on the MCP Service.
PascalAI Usage
uses toolslib;
var Tool := LoadTool('mcp-siag-query');
var R := Tool.Call(JsonObj(['operation','query','dsl','QUERY roi PERIOD 2024 GRANULARITY monthly']));