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/classify_sandbox.py
View on GitHub#!/usr/bin/env python3
"""
Classify a database name as personal / dev / shared-dev / prod / unknown.
Usage:
python3 classify_sandbox.py <database_name>
Prints JSON: {"database": "<name>", "classification": "<label>"}
Exits 0 always; caller decides how to handle 'prod' / 'unknown'.
Rules (uppercase-insensitive):
personal -> starts with PERSONAL_
dev -> starts with DEV_ / SANDBOX_ / ends with _DEV
shared-dev -> starts with DBT_
prod -> exact match of any of: ANALYTICS, RAW, INGEST, MONTECARLODATA_SHARED
unknown -> everything else (empty string included)
"""
import argparse
import json
import sys
PROD_NAMES = {"ANALYTICS", "RAW", "INGEST", "MONTECARLODATA_SHARED"}
def classify(database: str) -> str:
if not database:
return "unknown"
name = database.upper()
if name in PROD_NAMES:
return "prod"
if name.startswith("PERSONAL_"):
return "personal"
if name.startswith("DEV_") or name.startswith("SANDBOX_") or name.endswith("_DEV"):
return "dev"
if name.startswith("DBT_"):
return "shared-dev"
return "unknown"
def main() -> int:
p = argparse.ArgumentParser(
description="Classify a database name as personal / dev / shared-dev / prod / unknown."
)
p.add_argument("database", help="Database name to classify")
args = p.parse_args()
print(json.dumps({"database": args.database, "classification": classify(args.database)}))
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 |