JSON to MySQL schema
CREATE TABLE statements for MySQL 8 designed from a JSON sample: column types, NOT NULL, and child tables with foreign keys for nested arrays.
Frequently asked questions
How is this different from JSON to SQL?
JSON to SQL loads rows into one flat table with INSERT statements. This tool designs the schema: it splits nested arrays into child tables linked by foreign keys, the way you would model it by hand.
Are the column sizes right?
They are guessed from your sample with headroom (VARCHAR 32/64/128/255). Check them against your real data before production.
Is JSON to MySQL schema free?
Yes. JSON to MySQL schema is free to use. You get 3 free conversions a day without an account, and unlimited use when you sign in with Google.
Are my files uploaded?
No. The conversion runs inside your browser, so your files stay on your device and are never sent to our servers.
Does it work on mobile?
Yes. PixKaro works in Chrome, Safari, Edge and Firefox on Android, iPhone, Windows and Mac.