Agent skill · data analytics · sickn33
monte-carlo-validation-notebook
Generates SQL validation notebooks for dbt PR changes with before/after comparison queries.
Why this skill is useful
Adds two executable helper scripts for generating SQL validation notebooks that are not commonly found in public documentation.
What it needs
Requires gh, python3, pyyaml installed locally. About 2k tokens when loaded. Last updated 2026-08-07. 44,571 stars on the source repository.
What this skill does
Tip: This skill works well with Sonnet. Run /model sonnet before invoking for faster generation. Generate a SQL Notebook with validation queries for dbt changes. Arguments: $ARGUMENTS Detailed Guide Read the detailed guide before executing this skill. It retains the complete procedure and reference material. Treat its safety, prerequisites, and validation requirements as mandatory. For focused work, load the relevant sections; for end-to-end work, read the guide completely. When to Use Use this skill when the user wants to validate dbt model or snapshot changes with Monte Carlo SQL Notebook queries, either from a GitHub PR or a local dbt repository. Parse the arguments: Target (required): first argument — a GitHub PR URL or local dbt repo path MC Base URL (optional): --mc-base-url <URL> — defaults to https://getmontecarlo.com Models (optional): --models <model1,model2,...> — comma-separated list of model filenames (without .sql extension) to generate queries for. Only these models will be included. By default, all changed models are included up to a maximum of 10. --- Setup Prerequisites: gh (GitHub CLI) — required for PR mode. Must be authenticated (gh auth status). python3 — required for helper scripts. pyyaml — install with pip3 install pyyaml (or pip install pyyaml, uv pip install pyyaml, etc.) Note: Generated SQL uses ANSI-compatible syntax that works across Snowflake, BigQuery, Redshift, and Athena. Minor adjustments may be needed for specific warehouse quirks. This skill includes two helper scripts in ${CLAUDEPLUGINROOT}/skills/monte-carlo-validation-notebook/scripts/: resolvedbtschema.py - Resolves dbt model output schemas from dbtproject.yml routing rules and model config overrides. generatenotebookurl.py - Encodes notebook YAML into a base64 import URL and opens it in the browser. …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills sickn33/monte-carlo-validation-notebook