JSON to SQL Converter

How to use the JSON to SQL Converter

1. Paste a JSON array of objects, or open a .json file.
2. Choose your database and, optionally, a table name.
3. Check the inferred column types in the CREATE TABLE statement.
4. Copy the SQL or save it as a .sql file and run it in your database tool.

Examples

[
  {"id": 1, "name": "Mira Okafor", "email": "mira@example.com", "joined": "2025-11-02", "vip": true, "address": {"city": "Leeds", "postcode": "LS1 4AB"}},
  {"id": 2, "name": "Tomás Ruiz", "email": "tomas@example.org", "joined": "2026-01-15", "vip": false, "address": {"city": "Porto", "postcode": null}},
  {"id": 3, "name": "Jun O'Neil", "email": null, "joined": "2026-02-20", "vip": false, "address": {"city": "Cork"}}
]

{"orders": [{"orderId": 501, "total": 42.5, "paidAt": "2026-03-01T09:30:00Z", "items": ["mug", "tea"]}, {"orderId": 502, "total": 18, "paidAt": null, "items": []}]}

[{"code": "GB", "label": "United Kingdom", "eu": false}, {"code": "IE", "label": "Ireland", "eu": true}]

About this tool

Data often arrives as JSON, from an API, an export or a script, while the place you need it is a database table. This converter writes the SQL for you: a CREATE TABLE statement whose columns come from the keys of your objects, and INSERT statements for every record, batched so large files load efficiently.

Column types are worked out from the values themselves. Whole numbers become INTEGER (or BIGINT when they are large), numbers with decimals become a floating-point type, true and false become BOOLEAN or 0 and 1 depending on the database, and strings that look like dates or timestamps get date types. A column that ever holds null is left nullable, and keys missing from some records simply insert NULL.

Nested objects can be spread into separate columns, so address.city becomes address_city, or kept whole in a JSON column for databases that support it. Quotes and backslashes in your text are escaped correctly for the chosen database, which avoids the broken statements that string concatenation tends to produce.