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/readonly_check.py
View on GitHub#!/usr/bin/env python3
"""
Verify a .sql file contains only read-only statements.
Usage:
python3 readonly_check.py <path.sql>
Exit 0 with {"ok": true, "rejected": null} if safe.
Exit 1 with {"ok": false, "rejected": "<KEYWORD>"} if not.
Rejects any write-like keyword: INSERT, UPDATE, DELETE, MERGE, CREATE, DROP,
TRUNCATE, ALTER, COPY, PUT, GET, LIST, REMOVE, UNLOAD, GRANT, REVOKE, CALL,
EXECUTE, USE, SET.
Multi-statement files (several SELECTs separated by `;`) are accepted —
the keyword scan catches a rogue write statement regardless of how many
statements share the file. The caller is expected to split statements in
memory and send them to the warehouse one at a time.
"""
import argparse
import json
import re
import sys
from pathlib import Path
REJECTED_KEYWORDS = [
# Most-specific first: MERGE before UPDATE so "MERGE ... UPDATE SET" reports MERGE.
"INSERT", "DELETE", "MERGE", "UPDATE", "CREATE", "DROP", "TRUNCATE",
"ALTER", "COPY", "PUT", "GET", "LIST", "REMOVE", "UNLOAD",
"GRANT", "REVOKE", "CALL", "EXECUTE", "USE", "SET",
]
_LINE_COMMENT_RE = re.compile(r"--[^\n]*")
_BLOCK_COMMENT_RE = re.compile(r"/\*.*?\*/", re.DOTALL)
def _strip_sql(src: str) -> str:
"""Remove comments and string literals so keyword scan is false-positive-free."""
no_block = _BLOCK_COMMENT_RE.sub(" ", src)
no_line = _LINE_COMMENT_RE.sub(" ", no_block)
no_strings = re.sub(r"'(?:[^'\\]|\\.)*'", "''", no_line)
no_strings = re.sub(r'"(?:[^"\\]|\\.)*"', '""', no_strings)
return no_strings
def check(sql: str) -> tuple[bool, str | None]:
cleaned = _strip_sql(sql)
upper = cleaned.upper()
for kw in REJECTED_KEYWORDS:
if re.search(rf"\b{kw}\b", upper):
return False, kw
return True, None
def main() -> int:
p = argparse.ArgumentParser(
description="Verify a .sql file contains only read-only statements."
)
p.add_argument("path", type=Path, help="Path to the .sql file to check")
args = p.parse_args()
if not args.path.exists():
print(f"error: file not found: {args.path}", file=sys.stderr)
return 1
ok, rejected = check(args.path.read_text())
print(json.dumps({"ok": ok, "rejected": rejected}))
return 0 if ok else 1
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 |