monte-carlo-validation-notebook

Featured

Generates SQL validation notebooks for dbt PR changes with before/after comparison queries.

AI & Automation 40,440 stars 6528 forks Updated today MIT

Install

View on GitHub

Quality Score: 99/100

Stars 20%
100
Recency 20%
100
Frontmatter 20%
70
Documentation 15%
100
Issue Health 10%
50
License 10%
100
Description 5%
100

Skill Content

> **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 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 `${CLAUDE_PLUGIN_ROOT}/skills/monte-carlo-validation-notebook/scripts/`: - **`resolve_dbt_schema.py`** - Resolves dbt model output schemas from `dbt_project.yml` routing rules and model config overrides. - **`generate_notebook_url.py`** - Encodes notebook YAML into a base64 import URL and opens it in the browser. # Mode Detection Auto-detect mode ...

Details

Author
sickn33
Repository
sickn33/antigravity-awesome-skills
Created
4 months ago
Last Updated
today
Language
Python
License
MIT

Integrates with

Similar Skills

Semantically similar based on skill content — not just same category