monte-carlo-data/mc-agent-toolkit / skills/analyze-root-cause
monte-carlo-analyze-root-cause
VerifiedInvestigate data incidents and find root causes using Monte Carlo's observability data. Guides the agent through systematic investigation: alert lookup, lineage tracing, ETL checks, query analysis, and data profiling. Activates when a user asks about data issues, incidents, alerts, or why data looks wrong.
| File | Kind | Size |
|---|---|---|
| README.md | markdown | 4.7 KB |
| SKILL.md | skill md | 15.9 KB |
| references/common-root-causes.md | markdown | 4.0 KB |
| references/data-exploration.md | markdown | 4.8 KB |
| references/etl-failure-investigation.md | markdown | 2.7 KB |
| references/field-anomaly-investigation.md | markdown | 4.0 KB |
| references/freshness-investigation.md | markdown | 3.2 KB |
| references/intake-no-incident.md | markdown | 3.5 KB |
| references/query-change-investigation.md | markdown | 2.2 KB |
| references/schema-investigation.md | markdown | 1.8 KB |
| references/volume-investigation.md | markdown | 2.4 KB |
references/intake-no-incident.md
View on GitHub# Intake Flow: No Incident ID
Use this when the user describes a data problem but doesn't have a specific Monte Carlo alert or incident ID.
## Goal
Narrow down: **which table**, **what type of issue**, **when it started**, and whether Monte Carlo already detected it.
## Steps
### 1. Ask clarifying questions
Get the essentials from the user:
- **What table or data asset** is affected? (table name, dashboard, report)
- **What looks wrong?** (stale data, wrong numbers, missing rows, new columns, etc.)
- **When did you notice it?** (approximate timestamp helps scope the search)
- **Which warehouse?** (if they have multiple)
### 2. Find the table
Call `search(query="table_name")` to find the table's MCON and metadata.
If the user mentions a dashboard or report, search for it and then trace lineage upstream to find the source table:
- `search(query="dashboard_name")`
- `get_asset_lineage(mcons=[dashboard_mcon], direction="UPSTREAM")`
### 3. Search for existing alerts
Call `get_alerts` with a recent time range (last 7-14 days):
- Filter by the affected table if possible
- Look for alerts that match the user's description (freshness, volume, schema, field metric)
- If a matching alert exists, use its details to drive the investigation — proceed as if the user provided an incident ID
### 4. Check table health
Even without an alert, check the table directly:
- **Freshness:** `get_table_freshness` — when was it last updated? Is it overdue?
- **Volume:** `get_table_size_history` — has the row count changed unexpectedly?
- **Schema:** `get_asset(mcon=..., include=["fields"])` — check current schema
- **Query activity:** `get_queries` — are write queries still running?
### 5. Classify the issue type
Based on the evidence gathered, determine the issue type:
| Symptom | Issue Type | Next Step |
|---------|-----------|-----------|
| Table hasn't updated recently | Freshness | `references/freshness-investigation.md` |
| Row count spiked or dropped | Volume | `references/volume-investigation.md` |
| Columns added/removed/changed | Schema | `references/schema-investigation.md` |
| Data values look wrong (nulls, weird averages) | Field anomaly | `references/field-anomaly-investigation.md` |
| Pipeline failed or errored | ETL failure | `references/etl-failure-investigation.md` |
| Query was modified | Query change | `references/query-change-investigation.md` |
| Problem is about an AI agent (quality, latency, traces, conversations) | Agent issue | Hand off — read and follow `../../troubleshoot-agent-traces/SKILL.md` |
### 6. Proceed to investigation
Once you've identified the table, issue type, and approximate timeline, continue with Step 2 (Map the blast radius) from the main SKILL.md workflow.
> **TSA note.** This intake path intentionally does **not** invoke the Troubleshooting Agent (TSA), because `run_troubleshooting_agent` requires a Monte Carlo incident UUID and this path starts without one. If Step 3 above identifies a matching alert, treat the user as having provided that alert's incident ID and re-enter the main `SKILL.md` flow at Step 1 — Step 1.5 there will auto-invoke TSA. If no matching alert is found, run the manual investigation only.
## Tips
- **Users often know the symptom but not the cause.** "The dashboard shows yesterday's numbers" = freshness issue. "Revenue is way too high" = volume or field anomaly.
- **Check downstream first if the user reports a dashboard issue.** The bad data might originate several tables upstream.
- **Multiple alerts on the same table at the same time** usually have a single root cause.
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| reverse-engineer-anythingmorluto/reaReverse engineer native, managed, Electron/JavaScript, packaged, firmware, and browser targets with REA, and build agent environments (AgentEnv bundles) of web applications from a live instance or a capture, and of Linux desktop apps with a task from a request. Use shipped-artifact or requested runtime evidence to explain features, compare versions, decompile code, or guide a reconstruction. Skip REA for ordinary source-repository architecture analysis. | Stars: 472k | Updated | Claude CodeCodex | Verified | Install |
| diagnosing-superpowersobra/superpowersUse when a superpowers session went wrong and your human partner wants to know why — repeated work, ignored plans, stumbles, poor results, a skill that didn't fire, "it took too long", "why is it so expensive", "what is it doing" — or wants to build a bug report for the superpowers maintainers, for the current session or a past one identified by id or path, on any harness. | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |
| dispatching-parallel-agentsobra/superpowersUse when facing 2+ independent tasks that can be worked on without shared state or sequential dependencies | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |
| executing-plansobra/superpowersUse when executing an implementation plan in the current session as the implementer yourself — your human partner chose inline execution, or no subagent tool is available | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |