CSV / JSON to SQL INSERT
Map local CSV or JSON records to SQL INSERT statements for PostgreSQL, MySQL, SQLite or SQL Server with explicit types, quoted identifiers and precise string handling.
Need to prepare CSV first? Edit columns and filter once, then export CSV, JSON or SQL.
Enabling local controls…
1. Parse source
PostgreSQL, MySQL, SQLite or SQL Server CREATE / INSERT is generated in this browser only. Nothing is executed, uploaded, stored or sent as a tool analytics event.
CSV: 5 MiB, 20,000 rows, 100,000 cells including headers, 200 columns, strict quotes and row shape. Synthesized headers also count toward size/cell limits. JSON: 1 MiB, 50,000 nodes, nonempty object array with identical keys by default. SQL output: 16 MiB. Processing is cancelled after 5 seconds.
2. Map columns and generate SQL
Paste data or load a sample, then press Parse columns.
numeric: PostgreSQL preserves decimal spelling; MySQL accepts only values exact in DECIMAL(65,30); SQL Server requires DECIMAL(38,18); SQLite accepts only signed 64-bit integers. Choose text for other values. jsonb maps to MySQL JSON or JSON text in SQLite and SQL Server. MySQL text uses UTF-8 hex literals independent of backslash SQL mode.
How to use this tool
Parse CSV or a JSON array of objects, select and rename columns, choose text, numeric, boolean or jsonb, then enter the schema and table separately. Review the preview before copying or downloading complete SQL.
When not to use it
SQL is generated for review. Text is the default and preserves leading zeros. You can infer types, fill missing JSON keys with NULL, export CREATE TABLE or group rows into batches.
Read the guide →