JSON Parser
Online JSON Parser
OnlinePaste a JSON array of objects, set the table name, and click Generate. The tool produces one INSERT INTO statement per row with properly quoted values. Useful for seeding a database from API data, migrating records, or generating test fixtures.
Free, fast, runs in your browser. No login needed.
users)..sql file.The generator takes the first row's keys as the column list and produces one INSERT INTO table (cols) VALUES (vals); statement per row. The column list is fixed to the first object's keys — if later rows have additional keys, those extra fields are silently omitted.
Value quoting rules:
'' (SQL standard doubling).42, true, false).NULL.Auto-detection. If your input is a JSON object containing an array (e.g., {"users": [...]}), the generator finds and uses that array automatically.
Note on SQL dialects. The output uses standard SQL syntax compatible with PostgreSQL, MySQL, SQLite, and most other relational databases. Boolean literals (true/false) are standard SQL but some databases (e.g., older MySQL) prefer 1/0 — adjust if needed.
An array of objects where each object represents a row. All objects should share the same keys. The column list is derived from the first object — keys present in later rows but absent from the first are ignored.
Strings are wrapped in single quotes and internal single quotes are doubled to '' — standard SQL escaping. Other special characters are not escaped, so be cautious with data containing backslashes in MySQL (which uses \' as an alternative escape).
Nested objects and arrays are serialized as a JSON string and placed in a single-quoted string value. This works well for PostgreSQL JSONB columns. For other databases, flatten the data first.
Yes. Enter any table name in the text field before clicking Generate. The name is used verbatim in each INSERT statement.
No. Generation runs entirely in your browser.