Micro Tools
Advertisement

SQL Insert to JSONL converter

Convert SQL Insert to JSONL free, right in your browser. Paste your SQL Insert input below and press Convert. You get one JSON object per line, ready for data pipelines. No sign-up, and nothing is ever uploaded.

SQL Insert input

Paste your SQL Insert below, then press Convert.

Runs 100% in your browser. Nothing is uploaded.

Waiting for input.

Advertisement

How the conversion works

Paste your SQL Insert on the left and press Convert. The tool first parses the SQL Insert (tokenizing each INSERT INTO statement and decoding quoted strings, NULLs and numbers) into an internal table of rows and columns, then writes it out as JSONL (writing one compact JSON object per line). If the input cannot be parsed you get a plain-English error instead of a broken file.

Where this comes in handy

People reach for this converter when migrating database dumps or seed data and line-delimited JSON is needed for data pipelines. Because everything runs locally in your browser, it is also handy for quick one-off migrations without installing database tools or writing throwaway scripts.

Related tools

JSON formatterFormat and validate JSON, privately. Regex testerTest regex live with highlighting. Base64 encoderBase64 encode and decode, plus URL encoder and JWT decoder.

SQL Insert to JSONL FAQs

Can it parse several INSERT statements at once?
Yes. Every INSERT INTO ... VALUES statement in your paste is parsed, and the rows of the first statement's table are converted.
How are quoted strings and NULL handled?
Single-quoted strings with '' escapes, double-quoted identifiers, TRUE/FALSE and NULL are all understood, and numbers stay numeric in the output.
Is there a trailing newline at the end?
No. Lines are joined with newlines and there is no extra blank line at the end of the file.
How is each line structured?
Each line is one compact JSON object. For table inputs the keys are the column names; for document inputs like TOML each line holds one nested object.
Is my data uploaded anywhere?
No. Parsing and conversion run entirely in your browser with JavaScript. Your data never leaves your device.
Advertisement