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. validate-sql reviews the SQL itself: OSS runs 17 migration-safety rules in console or JSON. Pro adds a rules file, the security and schema packs, the performance analyser, and CI formats. Enterprise adds named profiles, the best_practices, performance and naming packs, and individual rule IDs.
SQL review command referenceFind 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. Pro compares the live database or the stored snapshot and can generate SQL with impact annotations. Enterprise adds --desired-model and, on generated SQL, --fail-on, --impact-format, and --impact-output.
Schema comparison and supported optionsGive 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. DBLift does not keep a copy of the rows. To change them again, write a new correction.
Audited data correction workflow