db-sanitization

What problem does it solve?

This Skill provides guidelines and implementation patterns for building robust database sanitization logic in Python, enabling deterministic masking of PII while preserving referential integrity across SQL Server databases and ensuring rollback safety.

Core Features & Use Cases

• Deterministic masking for emails, names, phones, SSNs, and other PII to generate realistic test data without exposing sensitive information.
• Referential integrity preservation through foreign key aware updates and batched processing to maintain data relationships.
• Production-grade safeguards including data backups, safe rollback mechanisms, and post-sanitization validation to ensure data quality.

Quick Start

Provide a concrete sanitization task (e.g., mask emails and names in the Users table) and specify your target tables, columns, and determinism preferences to generate a complete Python sanitization script.