PlanetScale Schema Diff.
Generate migrations.
Zero setup.

Branch-to-Branch Diff

Compare schemas across PlanetScale branches. Export from your main branch and a feature branch to see exactly what schema changes a deploy request introduces.

Deploy Request Aware

Validate schema changes before opening a PlanetScale deploy request. Catch missing indexes, column type mismatches, and breaking changes before they reach production.

Online Schema Change Safe

Generates MySQL-compatible ALTER TABLE scripts that work with PlanetScale's online schema change workflow. No table locks, no downtime.

Constraints & Indexes

Primary keys, unique constraints, and CHECK constraints — all compared semantically. Note: PlanetScale does not support foreign keys; SchemaLens flags their absence.

Views & Triggers

Detects CREATE VIEW changes. Understands PlanetScale's supported trigger syntax. Essential for projects using views for computed data.

Privacy First

Your schema never leaves the browser. Compare production PlanetScale schemas safely without uploading sensitive table structures to a third-party server.

Column type change

ALTER TABLE `users`
  MODIFY COLUMN `bio` VARCHAR(500);

Add a new column

ALTER TABLE `orders`
  ADD COLUMN `shipped_at` DATETIME;

Add a unique constraint

ALTER TABLE `users`
  ADD CONSTRAINT `uq_users_email`
  UNIQUE (`email`);

Create index for performance

CREATE INDEX `idx_orders_user_id`
  ON `orders`(`user_id`);

✅ SchemaLens

• Browser-based — zero install
• Works with any schema export or dump
• Visual diff with color highlighting
• Branch-to-branch comparison support
• Shareable diff URLs
• Export to SQL, Markdown, PDF, Prisma, Drizzle

❌ PlanetScale CLI db dump

• Requires CLI installation and login
• Requires service token or OAuth
• Text-only output
• No visual branch comparison
• No shareable links
• SQL output only