Data Safety Suite
Three local auditors that catch data disasters before they reach production. SQL Migration Safety Doctor flags destructive or locking migration operations (DROP, TRUNCATE, non-concurrent index builds, NOT NULL without a default) and offers safer rewrites. dbt Test & Quality Auditor finds untested models, sources without freshness, and undocumented keys, with suggested tests YAML to drop into schema.yml. PII & Data-Leak Scanner finds personal data (emails, SSNs, card numbers, phones) in schemas, seed data, and logs before it leaks. For data and backend engineers who want migrations that won't lock the table, dbt projects that actually test their data, and seed files that aren't quietly shipping real PII. Read-only and evidence-first; nothing connects to your database or leaves your machine.
Works with every agent that reads SKILL.md — Claude Code, Cursor, Codex CLI, Gemini CLI, GitHub Copilot, Windsurf, OpenClaw, and more.
One payment, lifetime access. 3 skills unlock instantly in your library.
30-day refund guarantee
Instant unlock in your library
Free updates from the creator
What's included
3 skills
Audit local dbt SQL and YAML for missing model tests, source freshness and test gaps, likely-key coverage, missing model descriptions, SELECT *, and raw table references. Get severity-ranked findings plus starter tests YAML for model/key gaps without running dbt or querying a warehouse.
Scan local SQL, CSV, JSON, seed, fixture, and log files for PII-indicating names plus email-, SSN-, card-, and phone-like values. Get file/line findings with matched values redacted by default—no network, writes, database connection, or compliance claim.
Catch the dangerous migration before it locks or wrecks your production database. Scans SQL migration files for destructive and risky operations: DROP and TRUNCATE, drops without IF EXISTS, lossy column-type changes, NOT NULL added without a default, DELETE or UPDATE with no WHERE, non-concurrent index builds, dropped constraints, renames, and data backfills mixed into schema changes. Each finding is ranked by severity with a safer rewrite. Postgres, MySQL, and SQLite.
See it in action
You say
Audit the dbt models in my analytic_models/ warehouse folder for test coverage and quality issues.
Your agent does
dbt Test Quality Auditor Scan Report
Files scanned: 2 Findings: 8
[MEDIUM] DBT005 - models/orders.sql:1
Model uses SELECT *. Remediation: Select explicit columns to stabilize model contracts.
[HIGH] DBT006 - models/orders.sql:2
Model references a raw table instead of ref() or source(). Remediation: Use ref() or source().
[HIGH] DBT001 - schema.yml:1
Model orders has no unique/not_null tests. Suggested tests YAML: a starter version: 2 model/key template for review.
How to install
Drop the file into your AI Agent. Works with Claude, Cursor, ChatGPT, and 20+ more.