CSV / JSON to PostgreSQL INSERT
Map local CSV or JSON records to PostgreSQL INSERT statements with explicit types, quoted identifiers and precise string handling.
Enabling local controls…
1. Parse source
PostgreSQL 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, 200 columns, strict quotes and row shape. JSON: 1 MiB, 50,000 nodes, nonempty object array with identical keys per row. 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.
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
PostgreSQL only; SQL is never executed. Text is the default and empty CSV text is not NULL unless explicitly selected. No CREATE TABLE, arbitrary SQL expressions or assurance that a target schema accepts the statements.
Read the guide →