monte-carlo-data/mc-agent-toolkit / skills/prevent
monte-carlo-prevent
VerifiedShift-left safety net for dbt/SQL model edits. Runs change impact assessment before edits, generates SQL validation queries after, and executes them via `/mc-validate run`. Delegates health and monitor creation to peer skills.
| File | Kind | Size |
|---|---|---|
| README.md | markdown | 8.3 KB |
| SKILL.md | skill md | 19.0 KB |
| references/TROUBLESHOOTING.md | markdown | 1.5 KB |
| references/parameters.md | markdown | 1.0 KB |
| references/workflows.md | markdown | 36.6 KB |
| scripts/sandbox/classify_sandbox.py | script | 1.5 KB |
| scripts/sandbox/detect_hardcoded_db.py | script | 1.2 KB |
| scripts/sandbox/parse_profiles.py | script | 3.3 KB |
| scripts/sandbox/readonly_check.py | script | 2.3 KB |
| scripts/sandbox/substitute_placeholders.py | script | 3.7 KB |
| scripts/sandbox/tests/conftest.py | script | 256 B |
| scripts/sandbox/tests/test_classify_sandbox.py | script | 1.1 KB |
| scripts/sandbox/tests/test_detect_hardcoded_db.py | script | 1.6 KB |
| scripts/sandbox/tests/test_integration_smoke.py | script | 2.8 KB |
| scripts/sandbox/tests/test_parse_profiles.py | script | 3.1 KB |
| scripts/sandbox/tests/test_readonly_check.py | script | 3.9 KB |
| scripts/sandbox/tests/test_substitute_placeholders.py | script | 3.7 KB |
scripts/sandbox/parse_profiles.py
View on GitHub#!/usr/bin/env python3
"""
Parse a dbt profiles.yml and emit the active target's resolved context.
Usage:
python3 parse_profiles.py <profiles.yml path> [--profile <name>] [--target <name>]
On success prints JSON:
{
"profile": "default",
"target_name": "prod",
"database": "personal_alice",
"schema": "prod",
"role": "DATA_ANALYST",
"warehouse": "research",
"account": "dka87615.us-east-1"
}
On error: exits 1 with a human message on stderr; stdout is empty.
"""
import argparse
import json
import sys
from pathlib import Path
try:
import yaml # type: ignore
except ImportError:
print("error: pyyaml not installed; run `pip3 install pyyaml`", file=sys.stderr)
sys.exit(1)
def _select_profile(doc: dict, name: str | None) -> tuple[str, dict]:
"""Return (profile_name, profile_doc).
If *name* is given it must match a top-level profile key; otherwise
the first profile in the file is selected.
"""
if not isinstance(doc, dict) or not doc:
raise ValueError("profiles.yml has no profiles defined")
first = next(iter(doc))
if name:
if name in doc:
return name, doc[name]
raise ValueError(f"profile '{name}' not found in profiles.yml")
return first, doc[first]
def _select_target(profile: dict, target: str | None) -> tuple[str, dict]:
outputs = profile.get("outputs") or {}
if not outputs:
raise ValueError("profile has no 'outputs' defined")
target_name = target or profile.get("target")
if not target_name:
raise ValueError("profile has no 'target' and --target not given")
if target_name not in outputs:
raise ValueError(f"target '{target_name}' not defined in profile outputs")
return target_name, outputs[target_name]
def parse(profiles_path: Path, profile: str | None, target: str | None) -> dict:
if not profiles_path.exists():
raise FileNotFoundError(f"profiles.yml not found: {profiles_path}")
try:
raw = yaml.safe_load(profiles_path.read_text())
except yaml.YAMLError as exc:
raise ValueError(f"could not parse yaml: {exc}") from exc
profile_name, profile_doc = _select_profile(raw, profile)
target_name, target_doc = _select_target(profile_doc, target)
return {
"profile": profile_name,
"target_name": target_name,
"database": target_doc.get("database"),
"schema": target_doc.get("schema"),
"role": target_doc.get("role"),
"warehouse": target_doc.get("warehouse"),
"account": target_doc.get("account"),
}
def main() -> int:
p = argparse.ArgumentParser(
description="Parse a dbt profiles.yml and emit the active target's resolved context as JSON."
)
p.add_argument("profiles_path", type=Path, help="Path to profiles.yml")
p.add_argument("--profile", default=None, help="Profile name (default: first profile in file)")
p.add_argument("--target", default=None, help="Target name (default: profile's 'target' field)")
args = p.parse_args()
try:
result = parse(args.profiles_path, args.profile, args.target)
except (FileNotFoundError, ValueError) as exc:
print(f"error: {exc}", file=sys.stderr)
return 1
print(json.dumps(result))
return 0
if __name__ == "__main__":
sys.exit(main())
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code. | Stars: 119k | Updated | Claude CodeCodex | Verified | Install |
| performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks. | Stars: 119k | Updated | Claude CodeCodex | Verified | Install |
| agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |
| agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |