← Blogby Marcell Almeida

How to generate CREATE TABLE SQL from JSON

Paste JSON objects — get CREATE TABLE DDL with inferred column types.

Prototyping a schema from sample data is faster than writing DDL by hand. The CREATE TABLE Generator inspects JSON keys and values to infer VARCHAR, INT, BOOLEAN, and other column types.

Try it — paste JSON sample rows

Open full tool →

How it works

  1. Paste JSON — one object or an array of sample rows.
  2. Table name — name for the generated table.
  3. Copy DDL — CREATE TABLE statement ready to run.

Type inference

Types are guessed from JavaScript typeof and value patterns. Review before production — dates and decimals may need manual adjustment.

Seed data

After creating the table, populate it with the SQL INSERT Generator.

The How to generate CREATE TABLE SQL from JSON is free, runs locally, and never sends your data to a server. More developer tools at maratool.com.