data-migration-verify

Verify database migration correctness across PostgreSQL, MySQL, and SQLite.

2|Updated Feb 16, 2026
One-click install
npx skills add https://github.com/dmzoneill/skills --skill data-migration-verify
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: data-migration-verify
Source: https://github.com/dmzoneill/skills/tree/main/data-migration-verify
Command: npx skills add https://github.com/dmzoneill/skills --skill data-migration-verify

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill ensures that data migrated between different database systems (PostgreSQL, MySQL, SQLite) is accurate and consistent, preventing data loss or corruption.

Core Features & Use Cases

  • Schema and Table Comparison: Compares database schemas and table structures between source and target databases.
  • Row Count Verification: Checks if the number of rows in tables matches after migration.
  • Database Integrity Checks: Supports various checks like table sizes and detailed table descriptions.
  • Use Case: After migrating a production database from PostgreSQL to MySQL, use this Skill to confirm that all tables and their data have been transferred correctly.

Quick Start

Verify the data migration for the 'users' table from a PostgreSQL source to a SQLite target database.

Frequently Asked Questions about data-migration-verify

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

FAQPage Schema
How do I verify database migration correctness after moving data between PostgreSQL and MySQL?

To verify database migration correctness, compare source and target schemas, table structures, and row counts. This ensures data consistency and prevents data loss or corruption across PostgreSQL, MySQL, and SQLite databases.

What is the best way to check data integrity after migrating a production database to SQLite?

Checking data integrity after migrating a production database involves comparing table structures and verifying row counts between source and target databases. This confirms all transferred data remains accurate and consistent.

Can I compare schemas and table structures across different database systems like PostgreSQL and SQLite?

Yes, you can compare schemas and table structures across different database systems like PostgreSQL and SQLite. The process introspects source and target databases to validate structural consistency after migration.

How do I validate row counts in specific tables after a database migration?

To validate row counts after a database migration, execute specific database queries on both source and target systems. Comparing these counts confirms that all records transferred correctly without data loss.

Does database migration verification support checking table sizes and detailed table descriptions?

Yes, database migration verification supports checking table sizes and detailed table descriptions. These database integrity checks help validate structural consistency and data accuracy across supported platforms.

Why do I need to verify data consistency when migrating between MySQL and PostgreSQL?

You need to verify data consistency when migrating between MySQL and PostgreSQL to prevent data loss or corruption. Comparing schemas and row counts ensures the target database accurately reflects the source.