Skip to content

a5c-ai/babysitter / library/specializations/code-migration-modernization/skills/data-migration-validator

data-migration-validator

Verified

Validate data integrity during and after migration with comprehensive verification checks

FileKindSize
README.mdmarkdown1.4 KB
SKILL.mdskill md3.0 KB
# 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/)
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: 198kUpdated Claude CodeCodexVerifiedInstall
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: 194kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report.Stars: 194kUpdated Claude CodeCodexVerifiedInstall
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: 194kUpdated Claude CodeCodexVerifiedInstall