danfengcao/binlog2sql

Health v2 · maintenance only

Flags: no_releases

Adoption not part of the score

3553 stars · 1062 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded

A Python CLI tool that parses MySQL row-format binary logs and converts them into standard SQL, rollback (flashback) SQL, or INSERT statements without primary keys. It is used for fast data recovery after accidental DML and for repairing data loss after master-slave failover.

Use cases

• recover accidentally deleted rows in mysql
• generate rollback sql from mysql binlog
• flashback a database after a bad update
• repair data loss on new master after failover
• extract insert update delete statements from binlog
• audit who changed data in mysql

When to choose

• you need to undo accidental DML on MySQL 5.6/5.7 with row-based binlog
• you want human-readable SQL from binlog events instead of raw binlog output
• you need point-in-time rollback SQL filtered by database, table, or SQL type

When to avoid

• your MySQL uses statement-based binlog format or binlog_row_image is not full
• you run MySQL 8.0+ and need guaranteed compatibility or official support
• you need a GUI or continuous replication tool rather than one-off binlog parsing

Facets

cli-tool · maturity maintenance

database parser backup developer-tools databases developer-tools python cli windows mysql binlog flashback data-recovery rollback sql-generation data-engineering linux macos

Member repositories

For agents

markdown · JSON · MCP: product_card(name="danfengcao/binlog2sql")