SQL Insert Generator

Output

About this tool

Paste a JSON array of objects or simple CSV and get SQL INSERT statements. Column names are collected from the rows, values are quoted per dialect, and you can emit one statement per row or a single multi-row INSERT.

Questions

How are objects and arrays stored?
Nested objects and arrays are serialised to JSON text and escaped as a string, which is the safe default across dialects.