SQLite Schema Diff.
Generate migrations.
Zero setup.

Limited ALTER TABLE Support

SQLite can't drop columns or alter types natively. SchemaLens generates clear workarounds: rename → create → copy → drop.

Type Affinity Awareness

Understands SQLite's flexible type system (INTEGER, REAL, TEXT, BLOB, NUMERIC) and warns about meaningful type changes.

Constraints & Indexes

Primary keys, unique constraints, foreign keys, CHECK constraints, and indexes — all compared semantically, not by raw text.

Backtick & Bracket Identifiers

Handles backtick-quoted identifiers and double-quoted names exactly like SQLite does.

Auto-Increment Detection

Recognizes INTEGER PRIMARY KEY auto-increment behavior and warns when rowid semantics change.

Privacy First

Your schema never leaves the browser. Compare local SQLite schemas safely without uploading to any server.

Add a new column

ALTER TABLE users
  ADD COLUMN bio TEXT;

Drop column (workaround)

-- SQLite does not support DROP COLUMN directly.
-- Workaround: create new table without column,
-- migrate data, drop old table, rename new table.

Rename a table

ALTER TABLE old_users
  RENAME TO users;

Add a foreign key

-- SQLite does not support ADD CONSTRAINT on existing tables.
-- Workaround: create new table with FK, migrate data,
-- drop old table, rename new table.