📦 Schema Semantic Versioning Calculator
Paste your old and new database schema. We automatically calculate the semantic version bump — breaking changes = major, new tables/columns = minor, fixes = patch.
Follows SemVer rules adapted for schemas
📄 Old Schema
📄 New Schema
Works with PostgreSQL, MySQL, SQLite, SQL Server, Oracle
📐 How Schema SemVer Works
MAJOR — Breaking changes: dropped tables/columns, type changes that lose data, removed constraints, renamed identifiers.
MINOR — Safe additions: new tables, new columns, new indexes, new constraints that don't break existing queries.
PATCH — Fixes & optimizations: added defaults, widened types, added indexes, fixed constraints, non-breaking renames.
No change — Identical schemas, whitespace-only differences, or comment-only changes.