Data formats · FMT-13Submit an issue

JSON to SQL converter

Convert JSON objects into MySQL, PostgreSQL or SQLite INSERT statements.

JSON → INSERT · MySQL / PostgreSQL / SQLite
Database
Input
Output
Usage guide and examples

Work with configuration and network data

Enter a JSON object or object array, set the table and select MySQL, PostgreSQL or SQLite to generate INSERT. All keys form columns, missing values become NULL and single quotes are escaped. Check the schema before execution; generation runs no SQL.

Check the input format and options with this example before using your own data. Random values, file sizes and presentation vary with the input and settings.

Example input and settings

[{"name":"Ada"}]
users

What to check in the result

INSERT INTO … users …