Generate SQL INSERT and CREATE TABLE statements
Turn a CSV file into ready-to-run SQL. The tool generates CREATE TABLE statements with appropriate column types and INSERT statements for every row, compatible with MySQL, PostgreSQL, SQLite, SQL Server, and Oracle. Just upload, configure, and paste the output into your database client.
Initializing in your browser…
You need to load a CSV into a database and want a ready CREATE TABLE plus INSERT statements with sane types.
CSV
id,name,active 1,Dana,true 2,Sam,false
SQL
CREATE TABLE data ( id INTEGER, name TEXT, active BOOLEAN ); INSERT INTO data VALUES (1,'Dana',true),(2,'Sam',false);
Types are inferred from the data and string values are properly escaped, so the generated SQL runs without the quoting and type errors hand-conversion introduces. You can choose the dialect and batch size for large files.
Turn a CSV file into ready-to-run SQL. The tool generates CREATE TABLE statements with appropriate column types and INSERT statements for every row, compatible with MySQL, PostgreSQL, SQLite, SQL Server, and Oracle. Just upload, configure, and paste the output into your database client.
Importing CSV data into a relational database usually means writing a CREATE TABLE statement by hand, guessing column types, and then either using COPY/LOAD DATA or writing INSERT statements. This tool automates the entire process. It detects column types (integer, decimal, varchar, date, boolean), picks sensible lengths for varchar columns based on actual data, and generates standards-compliant SQL. Besides plain INSERT, it can emit CREATE TABLE only, CREATE plus INSERT, UPDATE, or UPSERT statements.
Dialect differences are handled per target: MySQL gets backtick-quoted identifiers and AUTO_INCREMENT, PostgreSQL gets double-quoted identifiers and SERIAL, SQLite gets simplified TEXT/INTEGER types and AUTOINCREMENT, SQL Server gets square-bracket identifiers and IDENTITY, and Oracle gets GENERATED ALWAYS AS IDENTITY. Batch INSERT mode groups rows into multi-value inserts for faster execution on the dialects that support it.
Generate INSERT statements from a CSV to populate a development or staging database.
Let the tool draft a CREATE TABLE statement based on real data, then refine it.
Convert exported CSV data into SQL scripts that can be version-controlled and replayed.
See how your data would be structured in SQL to understand table design and data types.
MySQL, PostgreSQL, SQLite, SQL Server, and Oracle. Each dialect uses its own quoting, type names, and auto-increment syntax.
Yes. The tool auto-detects types but you can override any column to a different type before generating SQL.
Values are properly escaped for the selected dialect, preventing SQL injection and syntax errors.
No hard limit. For very large files, consider using your database's native COPY or LOAD DATA command instead of INSERT statements for better performance.
Rows and columns are parsed and transformed in memory in your browser. No record ever reaches a server.