SQL INSERT Generator — JSON to INSERT

Enter a table name and paste a JSON array of objects to generate INSERT INTO statements with escaped values.

How to use
  1. Enter the target table name.
  2. Paste a JSON array of row objects in the textarea.
  3. Copy the generated INSERT statement from the output.
Frequently asked questions
What JSON format is expected?
A JSON array of objects where each object is one row, e.g. [{"id":1,"name":"Alice"}].
How are strings escaped?
Single quotes in string values are doubled per standard SQL escaping.
Does it support NULL values?
Yes. JSON null becomes SQL NULL in the generated statement.
Is my data sent to a server?
No. Generation happens entirely in your browser.
 Last updated 
Powered by maratool