Go from a sample payload to a typed table definition without eyeballing every field.
Paste sample JSON and get a CREATE TABLE statement with inferred types, nullability and keys — dialect-aware for Postgres, MySQL, BigQuery, Snowflake and DuckDB.
Free tier: 5 schema generations per month · or unlock forever for $4.99
DDL inferred from orders.json
Illustrative — paste JSON and get CREATE TABLE DDL in your dialect.
Every card is something members actually do inside Datamata — not a vague promise.
Hand it a sample row and get a typed CREATE TABLE instead of guessing every column type.
Objects and arrays are flattened or modelled with a clear note on each choice we made.
Types and syntax match the warehouse you target so the statement runs without edits.
Infers column types, nullability and likely primary keys from your sample rows
Feature deep-dives
See it work
Hand it a sample row and get a typed CREATE TABLE instead of guessing every column type.
Try JSON to SQLDDL inferred from orders.json
Illustrative — paste JSON and get CREATE TABLE DDL in your dialect.
Go deeper
Objects and arrays are flattened or modelled with a clear note on each choice we made.
Browse all premium toolsIn practice
Types and syntax match the warehouse you target so the statement runs without edits.
Try JSON to SQLBuilt for Premium outcomes
Real decisions, not generic templates. Every workflow runs on live market data so your moves are backed by what employers are asking for now.
Infers column types, nullability and likely primary keys from your sample rows
Generates dialect-correct DDL for Postgres, MySQL, BigQuery, Snowflake and DuckDB
Flattens nested objects and arrays with a clear note on each modelling choice
Quick start guide
Generate a table in three steps — paste a representative JSON sample, pick the dialect then review the inferred types.
Use a real row or two so the type inference reflects your actual data.
Choose Postgres, MySQL, BigQuery, Snowflake or DuckDB for correct syntax.
Check the inferred types and key choices then copy the CREATE TABLE statement.
Need quality checks next? Send the table into the Data Quality Rule Generator for tests.
What's included
Infers column types, nullability and likely primary keys from your sample rows
Generates dialect-correct DDL for Postgres, MySQL, BigQuery, Snowflake and DuckDB
Flattens nested objects and arrays with a clear note on each modelling choice
Free tier includes monthly generations; Pro unlocks unlimited DDL output
Start free, upgrade when you need more.
Pro
$9.99/moUnlimited DDL generation across every supported dialect
All 47 premium tools · Cancel anytime
Get ProDatamata Premium
Full depth across tools, higher limits where they apply and a single member hub tied to the same live posting engine.
Get Pro — $9.99/moCancel anytime · No lock-in
Salary, skills, employers and the Match Engine all read the same live posting feed — so you are not comparing a benchmark from 2022 against jobs from this week.
Get started free
Open the tool in your browser — no setup, no credit card. Upgrade to Pro when you want full depth across every Datamata tool.