/bi-modelingDesign, audit, and extend the semantic model via MCP.
The model architect. Star schema design, health audits with severity classification, and template pattern enforcement (Métricas, Aux Comparaciones, marked Date table, IBCS theme), all driven through the Modeling MCP against the live model.
What it does
- Inspects the live model before prescribing any change.
- Runs a health checklist (Auto Date/Time, marked Date table, FK hiding, RLS).
- Classifies findings as CRÍTICO, ADVERTENCIA, or INFO and fixes in order.
- Builds star schemas with integer surrogate keys and single-direction relationships.
- Writes the first 5-8 measures with VAR, DIVIDE, and explicit time intelligence.
- Replicates template patterns (Métricas, calculation groups, currency conversion).
- Triggers the save helper before any taskkill so MCP edits land on disk.
When to use
- A measure returns wrong numbers and you suspect the model shape.
- You want a structural audit before publishing.
- You're adding a new dimension, role-playing date, or RLS role.
- The model has Auto Date/Time on or no marked Date table.
Example prompts
/bi-modelingAudit my Retail model. I want every CRÍTICO finding and a fix order before we extend it./bi-modelingAdd a Salesperson dimension to my Sales fact table and wire up the Date relationships, both order date and ship date.How it works
- 01
Connect via MCP and read tables, measures, relationships, model properties.
- 02
Triage by model size and health (empty, broken, structured).
- 03
Inspect via INFO.ANNOTATIONS and column properties.
- 04
Report findings with severity and fix CRÍTICO items first via MCP.
- 05
Build star schema step by step (grain, fact, dims, relationships, measures).
- 06
Save the model (helper or Ctrl+S) before any process kill.
- 07
Suggest a Git commit once TMDL on disk reflects the changes.
Ready to use /bi-modeling?
Install bi-superpowers and your agent gets this skill (and the other five) in one command.