SQL e database
Convertitore JSON in SQL online
Converti oggetti JSON in istruzioni SQL INSERT. Nulla viene eseguito.
Data preview
SQL generato
JSON to SQL guide
How do I convert JSON to SQL?
Each JSON object can become one row and its keys become SQL columns. The converter generates escaped text locally in the browser and never executes it.
Nested JSON
Nested objects can be flattened into names such as user.name, while arrays and objects can be preserved as serialized JSON text. Review the result before using it.
Conservative type detection
Numbers, booleans and dates are mapped when the values are consistent. Strings with leading zeroes remain strings to avoid losing information.
Automatic CREATE TABLE
The generated table definition is an estimate based on the supplied sample. Review types, lengths and constraints before production use.
Frequently asked questions
JSON to SQL FAQ
How do I convert JSON to SQL?
Paste an object or an array of objects, choose the table and engine, then select Convert to SQL.
Can I generate INSERT statements automatically?
Yes. You can generate one multi-row INSERT or one INSERT statement per record.
Can I generate CREATE TABLE?
Yes. Enable Generate CREATE TABLE to add a conservative definition before the INSERT.
What happens with nested JSON?
You can flatten nested objects or preserve objects and arrays as serialized JSON values.
Does it work with MySQL?
Yes. MySQL, PostgreSQL and SQLite use their appropriate identifier quoting and basic type mappings.
How are NULL values handled?
JSON null values and missing properties can be generated as SQL NULL or as an empty string according to your selection.
Does the tool execute SQL?
No. It only creates SQL text and never connects to or modifies a database.
Are my data stored?
No permanent storage is intentionally used. Avoid entering secrets or sensitive data into any online tool.
Can I load a JSON file?
Yes, .json files up to 10 MB can be loaded for the current session without executing their contents.