generate CREATE TABLE and INSERT statements from CSV or JSON

Paste a file, get production-shaped SQL for PostgreSQL, MySQL, SQL Server, or SQLite - with column types suggested from your actual data, not guessed from headers: VARCHAR sized to the longest value, INT vs BIGINT by observed magnitude, DECIMAL precision from real scale, DATE vs TIMESTAMP, NOT NULL only where the file truly has no nulls.

how to use it

1. Drop your file. The full-file scan reads every column before anything is generated.
2. Open </> code. Types come from real sizes, ranges, and decimal scales - not from the header names.
3. Pick your dialect and copy CREATE TABLE, the INSERTs, SELECT, or UPDATE.
4. Or choose export → sql for the complete INSERT script, streamed over every row.

• A PRIMARY KEY is suggested only when a column is provably unique across the whole file.
• SELECT and UPDATE templates, a TypeScript interface, and JSON Schema come from the same profile.
• INSERT preview in the panel; the export streams your entire file as batched INSERTs in a .sql script.
• Dialect quoting done right: double quotes, backticks, or brackets per backend.

"CSV" is a loose term here, and paste means paste anything: TSV, semicolon and pipe delimited files, ranges copied from Excel or Google Sheets, SQL client result grids, even tables copied off a web page (they arrive tab-separated) - the delimiter is detected automatically. One delimiter is chosen for the whole file; if a column turns out to carry its own separator inside it, click that column's header and choose split at delimiter to break it into real columns.

every tool in the box

• data workbench - profile, clean, transform, and export CSV, JSON, and SQLite - the full suite
• JSON flattener - nested JSON or NDJSON to flat columns, arrays and objects unrolled
• CSV PII scrubber - find emails, phones, SSNs, and card numbers - mask, hash, or drop them
• JSON to CSV - convert JSON or NDJSON to CSV with full column control
• CSV to JSON - convert CSV to JSON or NDJSON, streamed at any size
• Excel to CSV - read .xlsx workbooks and export CSV, sheets and all
• CSV to Excel - write a real .xlsx where leading zeros and dates survive
• SQL on CSV - real SQL over your files: joins, GROUP BY, a read-only console
• CSV to SQLite - drop several files, get one .sqlite database with discovered foreign keys
• CSV to SQL - CREATE TABLE and INSERT statements for Postgres, MySQL, SQL Server, SQLite (this page)
• JSON to TypeScript - TypeScript interfaces and JSON Schema derived from your real data
• large CSV viewer - open files past Excel's 1,048,576-row limit without loading them into RAM
• regex painter - highlight example matches, get a verified regular expression back
• encoding fixer - detect windows-1252/UTF-16 and repair garbled text (José → José)
• log parser - read log files as events: layouts detected, stack traces kept whole, timestamps normalized, and a volume-over-time strip drawn in SQL across every row
• visualize - chart any table you have open - bar, line, area or point - drag across it to filter, and export svg, png, or the vega-lite spec that drew it
• theme builder - design, test, and export custom color themes with live previews, palette derivation, and contrast diagnostics

Like every unfckr tool, this runs 100% in your browser: no upload, no servers, no signup, no analytics. A Content-Security-Policy header blocks every programmatic network channel, so not even malicious code could phone home - and you can watch it happen: the privacy page runs six live escape attempts and shows the browser refusing each one.

↑ back to the tool