# SQL Insert Generator Guide

Turn JSON or CSV rows into SQL INSERT statements for MySQL, PostgreSQL, SQLite or SQL Server.

- Tool: https://ilham.dev/tools/sql-insert-generator/
- Guide URL: https://ilham.dev/guides/sql-insert-generator/
- Tool guides index: https://ilham.dev/guides/tools/
- Broader guide: SQL Formatting and Test Data (https://ilham.dev/guides/sql-formatting-and-test-data/)

## What it does

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.

## Use the tool

Open https://ilham.dev/tools/sql-insert-generator/, add the input the tool asks for, run it, and check the output before using it elsewhere.

## Input and output

- Input: text.
- Output: text.
- Category: Data.

## Privacy and processing
Processing happens locally in your browser. This tool does not upload the input to ilham.dev.

## 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.