Everything runs on your machine — your file is processed right here in your browser and never uploaded to any server.
Input
JSON
Loading...
Output
MySQL
Loading...

About this tool

Getting JSON data into a relational database usually means writing a table definition and a pile of INSERT statements by hand. This converter does both for you: give it a JSON array of objects and it produces MySQL-compatible SQL — a CREATE TABLE statement derived from your keys plus INSERT rows for every record.

Backend developers use it to seed a local development database from a production API export, and teams migrating away from document stores use it to move JSON dumps into MySQL tables. Instead of a custom import script, you get runnable SQL in the time it takes to paste.

How to use

  1. Paste a JSON array of objects into the left editor, or open one from disk with the Load File button.
  2. The SQL statements are assembled on the right as you type, updating live with each change to the input.
  3. Review the generated CREATE TABLE column types and adjust names or types in the output if your schema differs.
  4. Use Copy to run the SQL in your database client, or Download to keep it as a .sql migration file.

Database contents are exactly the kind of data you should never paste into a site that phones home. This page does not: SQL generation is handled by in-browser code, and your records never travel beyond your own device.

Frequently asked questions

How are column types chosen?

Types are inferred from the values in your JSON: numbers map to numeric columns, text maps to string columns, and booleans map accordingly. Treat the result as a starting point and review it before running against anything important.

Are quotes and special characters in my values escaped?

Yes. String values are escaped so that apostrophes and similar characters do not break the INSERT statements. It is still good practice to run generated SQL against a development database first.

Does the tool connect to my database?

No. It never touches a database or any server at all — it only writes SQL text in your browser. You copy the output and execute it yourself in MySQL Workbench, the mysql CLI, or your usual client.