CSV to SQL CREATE TABLE

Paste a CSV, get a CREATE TABLE. Nothing you paste is stored.

Paste a CSV (comma, semicolon, tab or pipe delimited) and get a PostgreSQL CREATE TABLE. Types are inferred from the actual values: integers, decimals, booleans and ISO timestamps are recognized, headers are sanitized into column names, and a column with empty cells comes out nullable.

Inferred from the rows you paste, on the server, discarded after the response.

Try it on your own CSV

Example

CSV in:

sku,name,price,in_stock,created_at
A-100,Widget,9.99,true,2024-01-15T10:30:00Z
B-220,Gadget,19.5,false,2024-02-01T08:00:00Z
C-330,Doohickey,4.25,true,2024-03-11T14:45:00Z

Generated:

V1__create_record.sql

CREATE TABLE record (
    id BIGSERIAL PRIMARY KEY,
    sku TEXT NOT NULL,
    name TEXT NOT NULL,
    price DOUBLE PRECISION NOT NULL,
    in_stock BOOLEAN NOT NULL,
    created_at TIMESTAMP NOT NULL
);

Related

• CSV to Pydantic
• JSON to TypeScript
• PostgreSQL to Flyway