Convert JSON to SQL for PostgreSQL, MySQL, and SQLite
Paste a JSON array of objects, or drop a .json file here.
PostgreSQL, MySQL, and SQLite quote identifiers differently and disagree on booleans, conflict handling, and bulk-loading syntax. The generator produces SQL that matches the database you selected instead of a generic middle ground.
This tool converts JSON objects with primitive values into INSERT statements for PostgreSQL, MySQL, and SQLite. Nested objects and arrays are serialized as JSON text. It does not execute SQL or connect to a database.
JSON null values become SQL NULL, empty strings can become NULL or stay empty, and tokens such as NULL or N/A can be treated as NULL. NULL is always emitted as the SQL keyword, never as the string 'NULL'.
The generated CREATE TABLE statement is a conservative starting point based on inferred types. Review the types, lengths, and nullability against your real schema before running it.
Conversion runs in your browser. File contents, key names, table names, and generated SQL are not posted to a server, written to local storage, or included in analytics events.
Guides and articles on the blog for PostgreSQL, MySQL, SQLite.