Disclosure: I build Schemity, a desktop ERD tool - this post is from our blog and uses it for the examples.


TL;DR: Most diagram tools force manual translation: retyping SQL dumps into boxes, then hand-writing ALTER statements from diagram edits. Schemity imports SQL to generate the ERD and turns diagram edits into a reviewed migration SQL diff -...