CSV → SQL generator

Generates UPDATE or INSERT statements from a CSV for MSSQL, PostgreSQL, or MySQL. For UPDATE mode, assumes the first column is the identity key (e.g., CaseNumber) and all other columns are updated per row. For INSERT mode, generates INSERT statements for all columns.

CSV file

Database type

SQL type

Table name

Identity column name (defaults to first CSV header)

Wrap in transaction

Skip setting columns with blank values (instead of SET col = NULL)

Output

Tips:
• Empty cells become NULL unless "Skip blanks" is enabled.
• Numbers are emitted as-is; true/false → 1/0; everything else is single-quoted with embedded quotes doubled.
• Identifiers are quoted according to the selected database type (MSSQL: [brackets], PostgreSQL: "quotes", MySQL: `backticks`).
• UPDATE mode uses the identity column as WHERE condition; INSERT mode includes all columns.
• In INSERT mode, enable "Exclude auto-increment ID" to omit auto-generated columns from INSERT statements.

CSV preview (rows to show)

CSV → SQL generator

Data Validation Issues