SQL to JSON Converter

Paste INSERT statements and get JSON rows. More data tools

Convert SQL INSERT statements to JSON

Paste a dump that contains INSERT INTO ... VALUES statements, with one or many rows each. Column names come from the INSERT or from the matching CREATE TABLE. Numbers, booleans and NULL become real JSON values, and escaped quotes inside strings are handled.

With one table you get a plain JSON array. With several tables you get an object with one array per table.

Features

  • Live: the result updates while you type.
  • Clear errors: the line, the reason and, where possible, a one-click fix.
  • Open and drop files, copy or download the result, and share your input as a link.
  • Send to another tool: pass the result straight to a related tool.
  • Private: Everything runs in your browser. Your data is not uploaded to any server.

Related data tools

Frequently asked questions

Does it run my SQL?

No. It only reads INSERT and CREATE TABLE text. Nothing is executed.

What if the INSERT has no column list?

The column names are taken from CREATE TABLE when it is in the same paste. Otherwise they are called column1, column2 and so on.

Is my data private?

Everything runs in your browser. Your data is not uploaded to any server. You can even use the tool offline once the page has loaded.