DumpTales
Find the story between two database snapshots
DumpTales compares MySQL or MariaDB SQL dumps, experimental PostgreSQL COPY dumps, and native SQLite databases. See added, removed and modified rows by primary key without connecting to the database.
A quick comparison
dumptales old.sql.gz new.sql.gz
dumptales old.sql new.sql --format json > changes.jsonDumpTales runs locally and reads snapshots without executing their SQL. MySQL dumps in compatible primary-key order stream through; unordered data uses temporary compressed partitions. SQL dialect and gzip, bzip2 or single-file ZIP compression are detected automatically. Schema coverage varies by dialect. Read the worked example and limitations before using it with your own dumps.