Paste two versions of SQL code, or drop .sql files, to see every change highlighted. Use it to compare two versions of a query, a migration or a schema dump. Diffspot highlights SQL syntax, marks changed words inside each line and recognizes moved blocks. Press Try an example to see it on a real SQL change.
How to compare SQL files
- Paste or drop the original SQL code on the left.
- Paste or drop the changed version on the right. The diff updates as you type.
- Jump between changes with F7 and Shift+F7, or switch to Unified view to read it like a pull request.
- Copy or export a unified diff, a .patch file or an HTML report.
SQL comparison tips
- Comparing SQLSQL keywords aren't case-sensitive. If one query uses
SELECTand the otherselect, turn on Ignore case. - Cut the noiseComparing two schema dumps? Mask out timestamps and generated IDs under Ignore → Ignore inside lines.
- Your code stays privateThe comparison runs on your device in WebAssembly. Proprietary code is never uploaded or stored.
- Fast on large filesFiles with hundreds of thousands of lines compare in about a second.
Advertisement
Frequently asked questions
Is SQL detected automatically?
Yes. Diffspot recognizes SQL from the file name (.sql) or from the code itself. You can also choose it in the Syntax menu.
Is my code uploaded?
No. The page loads the diff engine once; after that your code stays in the browser tab. How Diffspot works explains how you can check this yourself.
Can I get a patch file?
Yes. Export → Download .patch creates a standard unified diff that git apply or patch can apply.