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
- JSON to YAML: Convert JSON to YAML or YAML to JSON. Use Swap to go the other way.
- JSON to TOML: Convert JSON to TOML or TOML to JSON.
- JSON to CSV: Turn a JSON array into a CSV table, or a CSV file into JSON.
- XML to JSON: Convert XML to JSON or JSON to XML. Errors show the exact line.
- All DataMint 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.