SQL Insert/Update Generator
Generate PostgreSQL INSERT or UPDATE text from a table name, comma-separated column names and a JSON array of rows. UPDATE requires a non-null unique key and always includes WHERE. Identifiers and scalar literals are escaped, never executed. Limits: 500 KB, 1,000 rows, 100 columns, 20,000 cells; nested values are rejected.
SQL Insert/Update Generator
Generate PostgreSQL INSERT or UPDATE text from a table name, comma-separated column names and a JSON array of rows. UPDATE requires a non-null unique key and always includes WHERE. Identifiers and scalar literals are escaped, never executed. Limits: 500 KB, 1,000 rows, 100 columns, 20,000 cells; nested values are rejected. Output is limited to 2 MB. PostgreSQL identifiers are limited to 63 UTF-8 bytes each; integer values must fit JavaScript safe integers.
No data is uploaded or executed.
A QUICK WALKTHROUGH
How to use this tool
- Choose settings, generate, and review the result.
Local processing
Generate PostgreSQL INSERT or UPDATE text from a table name, comma-separated column names and a JSON array of rows. UPDATE requires a non-null unique key and always includes WHERE. Identifiers and scalar literals are escaped, never executed. Limits: 500 KB, 1,000 rows, 100 columns, 20,000 cells; nested values are rejected. Output is limited to 2 MB. PostgreSQL identifiers are limited to 63 UTF-8 bytes each; integer values must fit JavaScript safe integers.
GOOD TO KNOW
Common questions
Local processing?
No data is uploaded or executed.