SQL CREATE TABLE Generator

Infer column types from sample data and emit CREATE TABLE for PostgreSQL, MySQL, SQLite, or SQL Server.

Table nameDialectAuto-increment PK column

Include IF NOT EXISTSSample data (CSV / TSV / JSON)

CREATE TABLE

CREATE TABLE IF NOT EXISTS users (
  id SERIAL PRIMARY KEY,
  email VARCHAR(26) NOT NULL,
  signup_at TIMESTAMP NOT NULL,
  balance DECIMAL(6, 2) NOT NULL,
  active BOOLEAN NOT NULL
);

Type inference

Each column is scanned: if every value parses as an integer, it picks INT (or BIGINT when values get large); decimals become NUMERIC; date-like strings become DATE or TIMESTAMP; everything else is VARCHAR(n) sized to the longest sample.

Dialect quirks

PostgreSQL uses SERIAL/BIGSERIAL; MySQL uses AUTO_INCREMENT; SQLite folds everything to flexible type affinity. The generator picks the right primary-key syntax for the dialect you choose.

Used in these workflows

CSV → SQL CREATE TABLE (Postgres)Parse a CSV, sniff column types from the data, and emit a Postgres CREATE TABLE.

Type inference

Dialect quirks

You might also like

Used in these workflows