CSV → SQL Schema

Infer a CREATE TABLE statement from a CSV by detecting column types.

Table

Dialect

Make first column PRIMARY KEY

CSV input

CREATE TABLE

CREATE TABLE "users" (
  "id" INTEGER NOT NULL PRIMARY KEY,
  "name" VARCHAR(7) NOT NULL,
  "email" VARCHAR(19) NOT NULL,
  "age" INTEGER NOT NULL,
  "joined" VARCHAR(20) NOT NULL,
  "active" BOOLEAN NOT NULL,
  "balance" NUMERIC NOT NULL
);