Shortcuts:⌘ KSearch?HelpD MDark modeG TAll tools
0 rows
Frequently Asked Questions
Does this tool infer SQL data types from my CSV?
No. When Create table DDL is enabled, every generated column is VARCHAR(255).
Which databases does it target?
It can generate MySQL, PostgreSQL, SQLite, or MSSQL flavored SQL. The main differences are identifier quoting and the drop-table statement style.
Can it batch multiple CSV rows into one INSERT?
Yes. You can emit one row per INSERT or bundle 10, 50, or 100 rows into each statement.
What happens to header names with spaces, dashes, or leading numbers?
They are sanitized into SQL-safe identifiers by replacing non-alphanumeric characters with underscores and prefixing leading digits with an underscore.
How are empty CSV cells written in the SQL output?
Empty strings become NULL in the generated VALUES tuples. Non-empty values are single-quoted and internal apostrophes are doubled.