Paste two SQL CREATE TABLE dumps and see exactly what changed. Generate ready-to-run migration and rollback scripts for PostgreSQL, MySQL, SQLite, SQL Server, and Oracle.
SchemaLens understands real SQL structure, not just text lines. It detects semantic changes that manual diffing misses.
Added, dropped, or renamed tables. See the full CREATE TABLE side-by-side with highlights.
New columns, removed columns, type changes, default values, nullable constraints, and collation changes.
Primary keys, foreign keys, unique constraints, and index additions or removals.
Dropped columns, type narrowing, and NOT NULL additions are flagged with risk scores.
Get ALTER TABLE scripts in your target dialect, plus rollback SQL to reverse the change.
Export the diff as Prisma, Drizzle, TypeORM, or Sequelize schema snippets.
From paste to migration SQL in three steps.
Copy your CREATE TABLE dumps from any database or ORM into the before/after inputs. SchemaLens auto-detects the SQL dialect.
See tables, columns, indexes, and constraints color-coded by added, removed, or modified. Risky changes are highlighted.
Grab the generated ALTER TABLE script, rollback SQL, or ORM export. Use it in your migration file or PR.
SchemaLens parses and generates migration SQL for the databases teams actually use.
Stop breaking changes from reaching production. Add SchemaLens to your pull-request workflow in 60 seconds.
PR comments, Check Run status, and HTML report artifacts. Learn more →
MR comments, smart skip, and breaking-change gates. Learn more →
PR comments and pipeline gates for schema changes. Learn more →
Console reports, build descriptions, and artifact archiving. See all integrations →
The web diff is free forever. Upgrade when you need power features or team workflows.
| Feature | Free | Pro — $39 lifetime | Team — $29/mo |
|---|---|---|---|
| Unlimited schema diffs | ✓ | ✓ | ✓ |
| Migration + rollback SQL | ✓ | ✓ | ✓ |
| Visual diff | ✓ | ✓ | ✓ |
| ORM export | ✓ | ✓ | ✓ |
| Export Markdown / PDF / JSON | — | ✓ | ✓ |
| Diff history & saved links | — | ✓ | ✓ |
| 80+ micro-tools | — | ✓ | ✓ |
| Shared team workspace | — | — | ✓ |
| Slack/Teams drift alerts | — | — | ✓ |
Quick answers about how SchemaLens compares database schemas.
Yes. The browser-based diff, migration generation, rollback SQL, and ORM export are free forever with no account required. Pro adds exports, history, and micro-tools.
No. The core diff runs entirely in your browser. Your SQL is never sent to our servers unless you explicitly use a server-side feature like the live GitHub PR diff viewer.
You can paste CREATE TABLE dumps from pg_dump, mysqldump, or any ORM. For live connections, use our GitHub Action or CLI in your CI/CD pipeline.
Dropped columns or tables, type narrowing, adding NOT NULL without a default, and removing indexes are common breaking changes. SchemaLens flags each with a risk score.
Text diff shows changed lines. SchemaLens parses SQL into tables, columns, and constraints and tells you what changed semantically — so a column rename looks like a rename, not a delete + add.
Paste two SQL schemas and see the diff in seconds. No signup, no install, no data sent to a server.