a5c-ai/babysitter / library/specializations/code-migration-modernization/skills/data-migration-validator
data-migration-validator
VerifiedValidate data integrity during and after migration with comprehensive verification checks
README.md
View on GitHub# Data Migration Validator Skill
## Overview
The Data Migration Validator skill ensures data integrity during migration. It performs comprehensive validation checks and generates audit-ready reconciliation reports.
## Quick Start
### Prerequisites
- Source and target database access
- Validation rules defined
- Comparison tooling
### Basic Usage
1. **Run row counts**
```sql
-- Compare counts
SELECT 'source', COUNT(*) FROM source.table
UNION ALL
SELECT 'target', COUNT(*) FROM target.table;
```
2. **Verify checksums**
- Calculate per-table hashes
- Compare values
- Investigate differences
3. **Generate report**
- Document all checks
- Note exceptions
- Provide sign-off
## Features
### Validation Types
| Type | Method | Confidence |
|------|--------|------------|
| Row Count | Full count | High |
| Checksum | Hash comparison | High |
| Sampling | Statistical | Medium |
| Business Rules | Custom queries | High |
### Reporting
- Pass/fail summary
- Detailed discrepancies
- Audit trail
- Sign-off documentation
## Configuration
```json
{
"validation": {
"rowCounts": true,
"checksums": true,
"sampling": {
"enabled": true,
"rate": 0.01
},
"businessRules": "./rules/*.sql"
},
"reporting": {
"format": "html",
"includeDetails": true
}
}
```
## Related Documentation
- [SKILL.md](./SKILL.md) - Full skill specification
- [Great Expectations](https://greatexpectations.io/)
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack." | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |