TextCompareLabCompare SQL queries online

Find changed SQL clauses and values with a browser-based text diff.

Compare two SQL queries before running them

When a query changes, start with the clauses that decide which rows it reads or changes. Paste the original SQL on the left and the revised query on the right. The text comparison marks added and removed lines and highlights changed words within a line. It can help you spot a renamed column, a different filter or a missing condition while both versions are still visible.

Worked example

SELECT id, total
FROM orders
WHERE status = 'paid'
LIMIT 100;
SELECT id, total
FROM orders
WHERE status = 'refunded'
LIMIT 100;

Only the status filter changed. The selected columns, table and limit are the same, but the query now asks for a different set of orders.

How to review the result

For a readable review, put SELECT, FROM, JOIN, WHERE and ORDER BY clauses on separate lines. Use the same formatting on both sides. Leave Ignore case off if capitalization inside string literals matters: a general text comparison cannot distinguish keywords from quoted data. When reviewing an UPDATE or DELETE statement, read the full WHERE clause rather than relying only on the highlighted words.

Use the arrows to move between changes, or select Changed lines only to hide unchanged lines. Copy or download the result when you need a separate record. Recent comparisons can remain in this browser's History, so clear them when using a shared device.

What this comparison does not check

The tool never connects to a database or executes SQL. It does not validate a database dialect, compare query plans or prove that two queries return the same rows. Test the final query in the right database environment with suitable safeguards.

Privacy and sharing

The comparison runs on your device. Your input is not uploaded to run the diff. If you choose Share, the texts are included in the generated link; keep password protection on and send the password separately. A shared link cannot be revoked.

Related guides and tools

Frequently asked questions

Does this run my SQL queries?

No. It only compares query text in your browser. It does not connect to a database, execute SQL or check query results.

Is this tool free and private?

Yes. It is free with no sign-up. The comparison runs in your browser. Recent text comparisons may be saved in History on this device; clear History on a shared computer.

Compare text in your browser

Your pasted text and opened files are processed on your device for comparison. They are not uploaded to a server to run the comparison.

Free, with no sign-up

Paste two versions, review the differences and copy or download the result. Recent comparisons are saved in this browser's History. Clearing site data removes them.

English Español Deutsch 日本語 Français Português Русский Italiano Nederlands Polski Türkçe हिन्दी 简体中文