How to compare two SQL queries
Format both queries the same way first, then compare them to see which clauses, columns or conditions changed.
2 min read
Compare SQL
untitled.sql
Paste content in both editors
Original1 line
Loading editor…
Modified1 line
Loading editor…
NOTHING UPLOADED · RUNS LOCALLY · FREE TO USE
About SQL comparison
Compare SQL with confidence.
Two SQL statements can be identical except for keyword case or line breaks. Format both sides to the same layout, and turn on Ignore case to focus on the clauses that actually differ.
01
Format both sides
Format puts each clause on its own line with upper-case keywords, so differences line up.
02
Ignore case
SELECT and select are the same keyword. Ignore case hides that noise (identifiers are folded too).
03
Review migrations
Compare an old and a new schema script to see added columns and changed constraints.
Features
Quiet tools, sharp results.
01
Aligned side by side
Two editors scroll together so the line you are reading always faces its counterpart.
02
Every change, coloured
Ember marks edits and removals. Ink marks additions. No other colours to learn.
03
Jump between differences
Step forward and back through each change with a count of how many remain.
04
Ignore the noise
Switch off whitespace and letter-case differences to focus on what really matters.
05
Changes, explained
A line-by-line list says what happened to each line, such as “Friday” became “Monday” or a number went from 3 to 4. Click any entry to jump straight to it.
How it works
Three steps. No account.
i
Paste
Drop the original on the left and the new version on the right.
ii
Compare
Differences are highlighted as you type, line by line.
iii
Decide
Review the summary, swap sides or clear the editors and go again.