JSON to SQL DDL
Infer a reviewable CREATE TABLE from all local sample rows for three SQL dialects.
Enabling local controls…
1. Source and settings
Local processing only; nothing is fetched, executed, uploaded or persisted. Each field32KiB; complete output1MiB. CPU work uses a cancellable Worker:10s startup/1s processing. Editing clears old results and exports.
Model, limits and sources
One object or 1–1,000 objects, up to 100 columns/5,000 JSON nodes/depth30. Missing/null allows NULL; all-null and mixed types use TEXT. No primary key, date or length guesses. Nested values use JSONB/JSON/TEXT. Quote unsafe JSON numbers as strings. Identifiers share a63-byte bound; case-fold collisions are refused. MySQL refuses supplementary characters and trailing spaces. Decimal types use approximate floating point. No SQL executes.
Source controls inspected2026-10-19; model reviewed2026-10-19.
2. Complete result
Choose an operation and process the input.
How to use this tool
Enter local input, review the explicit options and model, then run and export the complete result.
When not to use it
One object or 1–1,000 objects, up to 100 columns/5,000 JSON nodes/depth30. Missing/null allows NULL; all-null and mixed types use TEXT. No primary key, date or length guesses. Nested values use JSONB/JSON/TEXT. Quote unsafe JSON numbers as strings. Identifiers share a63-byte bound; case-fold collisions are refused. MySQL refuses supplementary characters and trailing spaces. Decimal types use approximate floating point. No SQL executes.