Why convert SQL INSERT dumps?
Developers often receive SQL seed dumps but need JSON for frontends, mocks, or tests. Conversely, JSON fixtures need to become INSERT statements for database bootstrapping.
This converter parses INSERT INTO … VALUES tuples into structured rows (and CSV), and can emit INSERT SQL from a JSON array — entirely in the browser.
How to use this tool
- Paste INSERT SQL and convert to JSON/CSV.
- Or paste a JSON array, set a table name, and generate INSERT statements.
- Use the CSV tab to round-trip tabular data.
Frequently asked questions
Which SQL dialects are supported?
Best-effort parsing of common INSERT INTO … VALUES forms (quoted identifiers, multiple tuples). Complex expressions, SELECT-based inserts, and vendor-specific syntax may need cleanup.
Is my data sent to a server?
SQL ↔ JSON / CSV Converter runs 100% in your browser. Inputs stay on your device and are not logged or stored by stbox servers.