SQL Tools

Format, parse, analyse and convert SQL and DDL across dialects, in the browser.

CSV Header to CREATE TABLE Generates a CREATE TABLE skeleton from a CSV header row, with cleaned identifier names.
DDL to ERD Generates Mermaid ER diagram source from CREATE TABLE statements and their declared foreign keys.
Schema Diff Compares two DDL scripts and lists every structural difference between them.
SQL Comment Remover Strips line and block comments without disturbing comment characters inside string literals.
SQL DDL Parser Reads CREATE TABLE statements and lists every column with its type, nullability, key role and default.
SQL Formatter Re-prints a query with one clause per line, consistent keyword case and readable indentation.
SQL IN Clause Builder Turns a pasted list of values into a quoted, de-duplicated, line-wrapped IN clause.
SQL Lineage Extractor Reads write statements and lists which source tables feed which target tables.
SQL Merge Generator Builds an upsert statement from a table definition and the key columns you nominate.
SQL Minifier Collapses a statement to a single line and removes comments, keeping literals intact.
SQL String Escaper Escapes text as a SQL string literal for standard SQL or MySQL quoting rules.
SQL Table Extractor Lists every table a statement references and whether it is read from or written to.
Processing happens locally in your browser. What you paste or load is processed by this page and is not uploaded to a server. Nothing is stored unless you use a control that says it stores something, and you can clear anything this site has kept from the privacy page.