Home / Data / SQL Table Generator

SQL Table Generator

Create CREATE TABLE and INSERT statements for PostgreSQL, MySQL, SQLite or SQL Server from a CSV or JSON file.

Free, no uploads, no sign-up. Runs 100% in your browser.

How SQL Table Generator works

Every column is checked to pick the best type (integer, decimal, boolean, date, timestamp, UUID, JSON or text), whether it allows empty values, and whether it could be a primary key. The SQL uses the quoting and types of the database you pick, and inserts are grouped in batches.

Input: CSV, TSV, JSON. Output: SQL.

How to use SQL Table Generator

1. Open SQL Table Generator and add your file or input.
2. Pick the options you need. Everything runs on your device.
3. Press the main button and download the result.

Tips

• Nothing is uploaded. Your files stay in this browser tab.

SQL Table Generator FAQ

Are my files uploaded?

No. This tool runs entirely in your browser tab. Files are read from your disk into memory and the result is generated locally.

Is it free? Are there limits or watermarks?

Free and open source (MIT). There are no file-size caps, daily quotas, accounts or watermarks.

Does it work offline?

Yes, once the page (and any engine it needs) has loaded, it keeps working without a connection thanks to the service worker cache.

Related tools

• SQLite Browser: Open .db and .sqlite files, browse tables, run SQL and export results to CSV or JSON.
• SQL Formatter: Beautify SQL for many dialects.
• CSV & Spreadsheet Editor: Edit CSV and Excel files in a fast grid: sort, filter, dedupe, find and replace, split and merge.
• Data Format Converter: Convert between JSON, YAML, XML, TOML, INI, CSV, NDJSON, MessagePack, CBOR and BSON.