JSON to SQL converter — free online
You've got a chunk of JSON data and you need it in a database. Writing the table by hand, then typing out every INSERT row, is slow and easy to get wrong. We added a free tool that does it for you — JSON to SQL — right in your browser.
What it does
Paste a JSON array of objects and it instantly builds the SQL for you: a CREATE TABLE statement based on the fields it sees, plus the INSERT statements to load every row. It's aimed at MySQL, so you can take the result straight into your database.
Nothing leaves your device
It all runs in your browser. Your JSON isn't uploaded anywhere, nothing is sent to a server, and nothing is saved. When you close the tab, it's gone.
How to use it
- Open JSON to SQL and paste your JSON array of objects.
- The CREATE TABLE and INSERT statements appear right away.
- Copy the SQL and run it in your database.
It's free with no limit. There are more small tools on the Apps page.