JSON to SQL INSERT
Build an INSERT statement from JSON objects.
How to use JSON to SQL INSERT
JSON to SQL INSERT — Build an INSERT statement from a JSON object or an array of objects. Free to use in D2i DevTools — no account required.
Steps
- Fill in Table name. This field is required.
- Fill in JSON. This field is required.
- Click Run and copy the result under the form.
Frequently asked questions
What is JSON to SQL INSERT used for?
Use it to load a small sample into a table without writing the VALUES list by hand.
How do I use the free online JSON to SQL INSERT tool?
Fill in Table name. This field is required. Fill in JSON. This field is required. Click Run and copy the result under the form.
What can I paste or upload into JSON to SQL INSERT?
Enter a table name and paste one object or an array of objects. Column names must be identifiers.
What output does JSON to SQL INSERT give me?
One INSERT with every column found in the rows. Strings are quoted. Null becomes NULL. Numbers stay numbers.
Is JSON to SQL INSERT free, and is my input private?
Yes — Your input is processed in memory for this request only. It is not saved to disk or the database, and it is cleared after the tool finishes.
Does this run the statement?
No. It only prints SQL. Review the table name and values before you run it in a database.
Inputs are processed in memory only and are not saved to disk or the database. Data exists only for the duration of your request.