SQL Diff

Compare two pieces of SQL as SQL: both sides are formatted the same way first, so only real changes show. When both define tables, you also get a list of schema changes and the migration that turns one into the other.

Features

Ignores formatting, line breaks and keyword case (both sides formatted with sql-formatter for 12 dialects); comments optional
Side-by-side line diff of the formatted SQL
Statement view: added, removed and changed statements, matched by what they are about (CREATE TABLE users, UPDATE orders…), with moved statements treated as unchanged
Schema view for CREATE TABLE scripts: tables and columns added or removed, and per column the type, NULL, default, primary key, unique and reference changes
Migration SQL from the original schema to the modified one for PostgreSQL, MySQL, SQLite or SQL Server
Copy the change list or the migration

How to use it

Paste the original SQL on the left and the modified SQL on the right.
Pick the dialect; formatting differences disappear.
Read the side-by-side diff, the statement list, or for schemas the changes and the migration.

FAQ

Why compare SQL instead of plain text?

Two queries can be the same with different spacing, line breaks or keyword case. Reformatting both sides first leaves only the differences that change what the SQL does.

Can it generate a migration?

Yes, when both sides contain CREATE TABLE statements: it writes CREATE TABLE, ALTER TABLE ADD/DROP/ALTER COLUMN, foreign keys and DROP TABLE statements for the chosen dialect. Renames look like a drop plus an add, and SQLite gets comments where it can’t alter a column, so review it before running.

Is my SQL uploaded?

No. Everything runs in your browser.

More developer tools

API Studio

Build, test and automate HTTP requests right in your browser.

API Studio: Build, test and automate HTTP requests: collections, environments, tests and a runner.

Diagrams

Draw cloud architectures and watch the data flow.

Architecture Builder: Draw cloud architectures and data flows with AWS, Azure, GCP and 1,000+ components.

CI/CD

See, edit and check your CI/CD pipelines.

Pipeline Studio: See and edit your Bitbucket pipelines as a metro map, with checks for mistakes Bitbucket would reject.

Data

Query, browse and edit data files and SQLite databases.

Database Studio: Query, browse and edit CSV, Excel, Parquet and SQLite files with SQL, right in your browser. Nothing is uploaded.

System Design

Simulate traffic through a system design and find its limits.

System Design Simulator: Design a system, send it traffic and watch where it melts: latency, errors and the bottleneck.

Team Knowledge

Every error your team has hit, and how it was fixed.

Error Memory: Search every error your team has hit and how it was fixed; log new ones with their fix.

Codebase

How your services and flows really work.

Code Flow Map: See how your codebase works: services and business flows, every step linked to its code.

Formatters & Beautifiers

Make messy payloads, queries and markup readable.

JSON & Log Formatter: Repair, beautify and deep-decode JSON, Python dicts and log lines.
SQL Formatter: Pretty-print queries for 12 SQL dialects.
XML / HTML Beautifier: Beautify or minify HTML and XML, with validation.
JSON Diff: Compare two payloads side by side or as a change list.
SQL Diff: Compare queries, scripts or schemas as SQL, with schema changes and the migration.
JQ / JSONPath: Filter JSON with jq or JSONPath expressions.

Encoders & Decoders

Look inside tokens, encodings and escaped text.

JWT Debugger: Decode tokens, check expiry and verify HMAC signatures.
Base64 / Hex / Binary: Convert text and files between Base64, hex and binary.
URL / Query Parser: Split, edit and rebuild URLs and query strings.
HTML & Unicode Entities: Encode and decode HTML entities and Unicode escapes.

Generators

IDs, hashes, keys, placeholder text and typed code.

UUID / ULID / Hash: Generate UUIDs and ULIDs; hash text or files.
Lorem Ipsum: Placeholder paragraphs, sentences or words.
RSA / EC Key Pair: RSA and EC key pairs as PEM or JWK, via WebCrypto.
Schema & Code Generator: Turn sample JSON into TypeScript, Zod, Go, Rust, SQL and more.

Converters

Move data between formats, times and color spaces.

Unix Timestamp ↔ Date: Convert Unix timestamps to dates and back.
Color Converter: HEX, RGB, HSL and OKLCH with WCAG contrast checks.
Cron Parser: Explain cron expressions and list upcoming runs.
Format Converter: Convert between JSON, YAML, TOML, XML and CSV.

API & Debugging

Reproduce requests, read errors and sanitise logs.

Log → cURL: Rebuild a runnable cURL from logs, HAR or fetch calls.
HTTP Status Codes: Status codes with causes and fixes.
Payload Redactor: Strip secrets and personal data before you share.
Regex Tester: Test patterns live and explain them token by token.