mcp-siag mcp

v1.0.0 · MCP Tool · analytics · registry.pascalai.org

FULL access to a SIAG analytics server: run any DSL (read and write) and manage configuration. Operations: health, login, get_me, execute_dsl, get/save/delete_categoria, get/save/delete_variable, get/save/delete_indicador, get_biblioteca_categorias, get_biblioteca_indicadores. DSL writes (CREATE/ALTER/DROP/LOAD/DEFINE) require the user to have rol=admin. Auth is automatic via SIAG_EMAIL/SIAG_PASSWORD/SIAG_TENANT env vars; pass email+password+tenant to override per call. For a read-only surface use mcp-siag-query.

siaganalyticsbiindicatorsdslconfigcrudadminagentdatasnap

Input Parameters

ParameterTypeDescription
operationrequired string Operation: health, login, get_me, execute_dsl, get_categorias, save_categoria, delete_categoria, get_variables, save_variable, delete_variable, get_indicadores, save_indicador, delete_indicador, get_biblioteca_categorias, get_biblioteca_indicadores One of: health, login, get_me, execute_dsl, get_categorias, save_categoria, delete_categoria, get_variables, save_variable, delete_variable, get_indicadores, save_indicador, delete_indicador, get_biblioteca_categorias, get_biblioteca_indicadores.
dsloptional string SIAG DSL statement(s) for execute_dsl. Read: QUERY, DRILL, NAVIGATE, INSPECT. Write (needs rol=admin): CREATE/ALTER/DROP TABLE, LOAD DIMENSION, LOAD DATA, DEFINE INDICATOR. Multiple statements may be separated by newlines. Example: "DEFINE INDICATOR roi FORMULA: utilidad / ventas UNIT: %".
emailoptional string Override credentials: user email (else uses SIAG_EMAIL)
passwordoptional string Override credentials: password (else uses SIAG_PASSWORD)
tenantoptional string Override credentials: tenant slug / empresa (else uses SIAG_TENANT)
tenantIdoptional string Tenant id for config operations. If omitted, resolved from the token.
idoptional string Record id (for save/delete of categoria/variable/indicador; empty on save = create new)
nombreoptional string Category name (for save_categoria)
dataoptional string JSON object payload for save_variable / save_indicador. Example: {"id":"","nombre":"Ventas","unidad":"MXN"}
catIdoptional string Category id for get_biblioteca_indicadores

Output Fields

FieldTypeDescription
No output fields defined

Examples

Define an indicator (write, needs rol=admin)

// Input
{
  "operation": "execute_dsl",
  "dsl": "DEFINE INDICATOR roi FORMULA: utilidad / ventas UNIT: %"
}

// Output
{
  "ok": true
}

List configured indicators

// Input
{
  "operation": "get_indicadores"
}

// Output
{
  "ok": true
}

Create/save a variable from JSON payload

// Input
{
  "operation": "save_variable",
  "data": "{\"id\":\"\",\"nombre\":\"Ventas\",\"unidad\":\"MXN\"}"
}

// Output
{
  "ok": true
}

Install & Discovery

Install

ppm install mcp-siag

Get JSON Schema

GET /v1/packages/mcp-siag/1.0.0/schema

Discover by keyword

GET /v1/mcp/discover?q=siag
Discovery hint: Install with ppm install mcp-siag or invoke remotely via POST /v1/invoke/mcp-siag on the MCP Service.

PascalAI Usage

uses toolslib;
var Tool := LoadTool('mcp-siag');
var R := Tool.Call(JsonObj(['operation','execute_dsl','dsl','INSPECT INDICATORS']));