CREATE TABLE Generator — JSON to SQL

Enter a table name and paste JSON sample rows or a column type map to generate a CREATE TABLE statement.

How to use
  1. Enter the table name.
  2. Paste JSON sample rows or a column-name-to-type object.
  3. Copy the generated CREATE TABLE SQL.
Frequently asked questions
How are column types inferred?
From the first row in a JSON array: numbers become INTEGER/REAL, booleans BOOLEAN, dates TIMESTAMP, objects JSON.
Can I pass explicit column types?
Yes. Paste a JSON object like {"id":"INTEGER","name":"TEXT"} instead of sample rows.
Which SQL dialect is generated?
Portable SQL similar to SQLite/PostgreSQL with quoted identifiers.
Is my data sent to a server?
No. Generation happens entirely in your browser.
 Last updated 
Powered by maratool