ada-data-migration-delivery-audit

Verify data migration refactor delivery through read-only database forensics and evidence checks.

Updated Jul 23, 2026
One-click install
npx skills add https://github.com/wubing7755/Ada --skill ada-data-migration-delivery-audit-wubing7755
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: ada-data-migration-delivery-audit
Source: https://github.com/wubing7755/Ada/tree/main/skills/software-development/ada-data-migration-delivery-audit
Command: npx skills add https://github.com/wubing7755/Ada --skill ada-data-migration-delivery-audit-wubing7755

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Refactors that promise "data moved from XML/files/legacy store to a database" often ship without proof: the migration tool may never have run against the real DB, tables may be silently empty, or deletion commits may destroy the only recovery path. This Skill verifies delivery with direct evidence instead of trusting commit messages, tool docstrings, or plan checkboxes. ## Core Features & Use Cases - DB Forensics: Read-only inspection of the real database — table lists, per-table row counts, and __EFMigrationsHistory — to distinguish "migration applied" from "data actually imported". - Timestamp & Connection-String Forensics: Detects importers that never ran (original dates preserved) and the CWD-relative connection-string trap that silently creates fresh empty databases. - Data-Loss Path Detection: Finds latent bugs like derived-field re-render wipes, empty-table fallback failures, and non-idempotent importers before merge. - Use Case: Before merging a multi-phase refactor that claims "DB is the single source of truth, old XML files deleted", run this audit to confirm every migrated table has data, recovery paths survive, and no admin save path can wipe imported content. ## Quick Start Ask the agent to verify that the data migration refactor actually delivered data into the database before merging the deletion commits.

Frequently Asked Questions about ada-data-migration-delivery-audit

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I verify a data migration actually populated the database?

Connect to the real database read-only and run per-table row counts plus a check of __EFMigrationsHistory. A full schema with zero rows means the migration ran but the import never completed, which commit messages alone will not reveal.

How to audit a refactor that deletes old data files after migration?

Use git show <del-commit>^:<path> to inspect what the deleted source contained and identify what recovery path remains. Then confirm the target DB tables hold equivalent data before approving the deletion commits.

Why does the migration tool report success but tables are empty?

A common cause is a CWD-relative connection string like Data Source=portfolio.db, which silently creates a fresh empty database wherever the tool runs. Search for stray DB files and check whether the tool prints the absolute DB path.

Can this audit run while tests are executing in parallel?

Yes, the audit is strictly read-only by design. It uses targeted read-only queries and small directed checks, and explicitly avoids running full test suites that a parallel process may be executing.

What are the limitations of migration delivery audits?

The audit verifies evidence at a point in time and cannot prove future behavior, such as admin save paths that re-render derived fields and wipe imported content later. Latent data-loss paths must be traced in code, not just observed in current rows.