JSON to SQL Converter
Convert a JSON array to SQL CREATE TABLE and INSERT statements instantly. Free, in-browser, no sign-up needed.
JSON Input
SQL Output
What Is JSON to SQL?
JSON to SQL conversion is something you end up needing whenever your data lives in JSON and your database expects SQL statements. This tool takes a JSON array and produces two things: a CREATE TABLE statement that reflects the shape of your data, and a batch of INSERT statements ready to run. Column types are inferred automatically — numbers become INT or FLOAT, booleans become BOOLEAN, and everything else gets VARCHAR(255). The JSON format is parsed fully in your browser — nothing leaves your machine. If you work with PostgreSQL, MySQL, or SQLite, the output should drop right in with minimal adjustment.
How to Use
Paste your JSON array
Drop a JSON array into the left editor — either paste it directly, load the sample, or upload a .json file. It must be an array of objects.
See the SQL generate automatically
As you type, the tool converts your JSON into a CREATE TABLE statement and INSERT rows. Column types are inferred from the values in your data.
Copy or download the SQL
Hit Copy to grab the SQL to your clipboard, or Download to save it as a .sql file. Then run it against your database.
Example
Here's a quick before/after so you know what to expect.
Users table from JSON
JSON input (3-row user array with a string that needs escaping):
Generated SQL output:
FAQ
What column types does this tool generate?
Numbers without a decimal point become INT, numbers with a decimal become FLOAT, booleans become BOOLEAN, and everything else (strings, dates, mixed) becomes VARCHAR(255). If you need more specific types like DATE or TEXT, adjust the generated SQL before running it. Most PostgreSQL data type mappings align with this output.
Does this handle special characters in strings?
Yes — single quotes inside string values are automatically escaped as '' (two single quotes), which is the standard SQL string escaping approach. You'll see this in the example above with "Carol O'Brien".
Can I use this SQL with any database?
The output uses fairly standard ANSI SQL, so it works in MySQL, PostgreSQL, SQLite, and most other relational databases with minor adjustments. For example, MySQL and PostgreSQL handle BOOLEAN slightly differently, but both accept this syntax.
What happens if my objects have different keys?
The tool collects all unique keys across every object in the array. If an object is missing a key, that column gets NULL in the INSERT. This means you can handle slightly inconsistent JSON without cleaning it up first.
Is my data sent to any server?
No. Everything runs in your browser using JavaScript. Your JSON never leaves your computer. This is especially useful when working with sensitive data like production database exports or customer records.
Can I change the table name from "data"?
Right now the tool uses data as the default table name. Just do a find-and-replace on the output to rename it to whatever your schema needs — it's two occurrences, one in CREATE TABLE and one in INSERT INTO.