🚀 Drizzle Schema Diff

Compare Drizzle Schemas Without the CLI

Paste two Drizzle ORM schema files and get an instant visual diff. See tables, columns, relations, and indexes that changed — then generate the migration SQL. No drizzle-kit required.

Diff a Drizzle Schema → 📋 Migration Checklist

How it works

SchemaLens parses your Drizzle schema (TypeScript or SQL output), compares it against another version, and shows you exactly what changed — just like drizzle-kit generate, but in your browser with a visual UI.

📋 Table Diff

See which tables were added, removed, or renamed. Catch accidental table deletions before they drop production data.

🔤 Column Changes

Spot type changes, not-null vs nullable updates, default value changes, and $defaultFn modifications at a glance.

🔗 Relation Detection

Visualize added or removed relations and foreign key constraints that affect your data integrity.

📊 Index & Unique

Compare index, uniqueIndex, and primaryKey declarations. Missing indexes can kill query performance.

📝 Generate SQL

Export migration scripts in PostgreSQL, MySQL, SQLite, SQL Server, or Oracle dialects — ready to run with drizzle-kit migrate.

🔗 Shareable Links

Share a diff URL with your team or paste it in a PR review. No screenshots, no copy-paste needed.

SchemaLens vs drizzle-kit

Both tools compare schemas. SchemaLens adds a visual layer and works without installing anything.

Feature	SchemaLens	drizzle-kit generate	Drizzle Studio
Browser-based (no install)	✅ Yes	❌ CLI only	❌ CLI + local DB
Visual diff UI	✅ Yes	❌ SQL files	❌ No diff
Compare two arbitrary schemas	✅ Paste any two	✅ Yes	❌ No
Multi-dialect SQL output	✅ 5 dialects	❌ Target only	❌ No
Shareable diff URLs	✅ Yes	❌ No	❌ No
Breaking change warnings	✅ Yes	❌ No	❌ No
Cross-dialect migrations	✅ Yes	❌ No	❌ No
View/edit live data	❌ No	❌ No	✅ Yes

When to use SchemaLens with Drizzle

SchemaLens complements your Drizzle workflow. Use it when you need speed, shareability, or a visual review layer.

🔍

Code Reviews

Paste the before/after schema into SchemaLens and drop the shareable link in your PR. Reviewers see exactly what changed without running drizzle-kit generate locally.

🏭

Staging vs Production Checks

Export your staging and production schemas, paste them both, and verify the diff before promoting to prod. Catch drift that drizzle-kit push didn't account for.

👥

Team Collaboration

Not everyone on your team has Drizzle installed or knows CLI flags. SchemaLens lets designers, PMs, and junior devs review schema changes in a familiar visual interface.

🔀

Cross-Dialect Migrations

Moving from PostgreSQL to MySQL? SchemaLens shows you the semantic differences and generates the target dialect's migration SQL — something Drizzle Kit can't do across databases.

Works with your Drizzle workflow

SchemaLens is not a replacement for Drizzle Kit. It's a visual companion for the moments when you need to see the diff, share it, or review it quickly.

1️⃣ Export your schema

Copy your schema.ts file or run drizzle-kit generate and grab the generated SQL. Paste it into SchemaLens.

2️⃣ Paste the target schema

Paste the older (or newer) version you want to compare against. SchemaLens parses both automatically.

3️⃣ Review the diff

Visual highlights show added tables, removed columns, type changes, and index modifications. Breaking changes are flagged in red.

4️⃣ Generate & share

Export migration SQL in your target dialect, or copy a shareable link to paste in Slack, Jira, or your PR description.