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/substitute_placeholders.py
View on GitHub#!/usr/bin/env python3
"""
Substitute <YOUR_DEV_DATABASE> in a validation .sql file with a confirmed dev database
and report any remaining literal fully-qualified database references.
Usage:
python3 substitute_placeholders.py <path.sql> --dev-db <NAME> [--output <path>]
Writes the substituted SQL to `<input>.run.sql` by default (or `--output`) and prints JSON:
{
"output_path": "<path>",
"dev_db": "<NAME>",
"replaced_count": <int>,
"literal_databases": ["analytics", ...]
}
Exits 1 if the input file is missing.
"""
import argparse
import json
import re
import sys
from pathlib import Path
_PLACEHOLDER = "<YOUR_DEV_DATABASE>"
_FQ_RE = re.compile(
r"\b([A-Za-z_][A-Za-z0-9_]*)\.[A-Za-z_][A-Za-z0-9_]*\.[A-Za-z_][A-Za-z0-9_]*\b"
)
_LINE_COMMENT_RE = re.compile(r"--[^\n]*")
_BLOCK_COMMENT_RE = re.compile(r"/\*.*?\*/", re.DOTALL)
_SINGLE_QUOTED_RE = re.compile(r"'(?:[^'\\]|\\.)*'")
_DOUBLE_QUOTED_RE = re.compile(r'"(?:[^"\\]|\\.)*"')
def _strip_noncode(sql: str) -> str:
"""Remove comments and string literals so regex scans don't false-positive
on identifiers that happen to appear inside literal text. Mirrors
`readonly_check.py:_strip_sql` so the two scripts stay in lock-step on
what counts as "code"."""
no_block = _BLOCK_COMMENT_RE.sub(" ", sql)
no_line = _LINE_COMMENT_RE.sub(" ", no_block)
no_single = _SINGLE_QUOTED_RE.sub("''", no_line)
no_double = _DOUBLE_QUOTED_RE.sub('""', no_single)
return no_double
# Backwards-compatible alias — older callers (and tests) may import this name.
_strip_comments = _strip_noncode
def substitute(sql: str, dev_db: str) -> tuple[str, int]:
count = sql.count(_PLACEHOLDER)
return sql.replace(_PLACEHOLDER, dev_db), count
def find_literal_databases(sql: str, dev_db: str) -> list[str]:
"""Return distinct database names used in fully-qualified refs, excluding dev_db.
Strips comments AND string literals before scanning, so that a SQL like
``WHERE meta = 'analytics.prod.client_hub'`` does not falsely surface
``analytics`` in the literal-databases list — that text is data, not a
reference."""
code_only = _strip_noncode(sql)
dbs = {m.group(1) for m in _FQ_RE.finditer(code_only)}
dbs.discard(dev_db)
return sorted(dbs)
def main() -> int:
p = argparse.ArgumentParser(
description=(
"Substitute <YOUR_DEV_DATABASE> in a validation .sql file with a confirmed "
"dev database; report any remaining literal fully-qualified database references."
)
)
p.add_argument("path", type=Path, help="Path to the validation .sql file")
p.add_argument("--dev-db", required=True, help="Dev database name to substitute in")
p.add_argument(
"--output",
type=Path,
default=None,
help="Output path (default: <input_dir>/run/<input_stem>.run.sql)",
)
args = p.parse_args()
if not args.path.exists():
print(f"error: file not found: {args.path}", file=sys.stderr)
return 1
original = args.path.read_text()
substituted, replaced_count = substitute(original, args.dev_db)
literals = find_literal_databases(substituted, args.dev_db)
if args.output is not None:
out_path = args.output
else:
run_dir = args.path.parent / "run"
run_dir.mkdir(parents=True, exist_ok=True)
out_path = run_dir / (args.path.stem + ".run.sql")
out_path.parent.mkdir(parents=True, exist_ok=True)
out_path.write_text(substituted)
print(json.dumps({
"output_path": str(out_path),
"dev_db": args.dev_db,
"replaced_count": replaced_count,
"literal_databases": literals,
}))
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 |