Review SQL and schema changes before release.

SQL review, schema comparison and audited data fixes, on top of the free migration core.

Migrate, preview, validate and undo stay free and open source.

Catch risky SQL while it is still a pull request.

validate-sql reviews migration SQL without running it.

UPDATE users SET name = lower(name);
SELECT * FROM users;

OSS validate checks migration consistency. Pro validate-sql reviews the SQL itself.

SQL review command reference

Find the column someone added by hand.

diff compares the live schema with the snapshot DBLift recorded.

ALTER TABLE users ADD COLUMN display_name TEXT;

Depth depends on the engine. diff never applies changes.

Schema comparison and supported options

Give one-off data fixes a reviewable record.

Plan the fix, assert the row count, apply, and keep a ledger entry.

-- dblift:formatted
-- dblift: expect=1
UPDATE users SET name = 'ada' WHERE id = 1;

Data corrections are currently alpha. Pro detects triggers and cascades and enforces your allow, warn or reject policy. Enterprise adds before-image capture and data undo; trigger side effects are not restored.

Audited data correction workflow

See Pro pricing ยท Explore Enterprise release controls

DBLift is information technology / developer tools software. Contact: contact@dblift.com.