SQL result comparator
Compare exported query results by key, with exact text checks and configurable numeric tolerances.
A numeric pair matches when abs(a-b) is at most absolute plus relative times the larger magnitude. Other fields compare exact strings. CSV cannot distinguish a SQL NULL from an exported empty string. No database connection is made. Up to 1,000,000 characters, 10,000 data records, 100 columns and 100,000 cells across the sources. Files for multi-source tools are limited to 4,000,000 bytes total. Reports retain at most 500 diagnostic findings and state any omitted count. CSV and JSON outputs are limited to 4,000,000 characters. Output is budgeted incrementally before retaining each row; expanded decimal output counts toward the same 4,000,000-character limit even when input uses short exponent notation. Paste exported query results as CSV, including the header row. This tool compares the results; it does not execute SQL. Results update as you type. Up to 1,000,000 characters.
Your result
How to use SQL result comparator
- Export each query result as a CSV and paste both tables.
- Select unique row keys, numeric columns and absolute or relative tolerance.
- Review changed values, missing rows and schema changes in the download.
Useful next steps
Prepare the source
Export each query result as a CSV and paste both tables.
Choose the matching rules
Select unique row keys, numeric columns and absolute or relative tolerance.
Review and keep the result
Review changed values, missing rows and schema changes in the download. A numeric pair matches when abs(a-b) is at most absolute plus relative times the larger magnitude. Other fields compare exact strings. CSV cannot distinguish a SQL NULL from an exported empty string. No database connection is made.