Schema Compare

Compare schema across two connections and generate a review-only migration script.

Compare schema across two connections. Pick a source and target profile and database, press Compare, and the differences land in a grid - one row per object with its change status: Missing in target, Extra in target, Definition changed, Renamed, or Manual review. Selecting a row opens a line-by-line definition diff. The comparison covers tables, views, indexes, foreign keys, check / default / primary / unique constraints, routines, and triggers.

• Suggested renames - likely renames are detected with a similarity score and offered as checkboxes, so a renamed table becomes one rename instead of a drop-and-create pair.
• Risk grading - every difference is graded data loss, breaking, review, safe, or cosmetic, with the riskiest rows sorted to the top so a drop never hides among hundreds of harmless differences. The Risk column says what each change can hurt.
• Drops are opt-in - Include DROP for target-only objects is off by default.
• Two scripts - a dependency-ordered deploy script and a matching rollback script, each sent to an editor tab, review-only.

There is also an in-app Deploy path for when you have reviewed enough: a Review → Progress → Summary dialog with an optional single-transaction wrapper (disabled on MySQL and MariaDB, whose DDL commits implicitly), a danger confirm, live step progress with cancel, and a done / failed / skipped tally at the end.

How risky is each change?

Target-only drops, renames, and unsupported objects are graded instantly on your machine. Only when you enable the optional decision model and press Assess risk are the object names and the changed definitions sent to TypeSafe AI to grade what changed inside each definition - and a low-confidence answer is marked for review rather than trusted.