SQL to JSON
Convert tab-separated result text or INSERT statements into JSON arrays.
When to use this tool
- Generating JSON fixtures from SQL query results.
- Turning `INSERT` statements into seed data for a non-SQL store.
- Producing API response mocks from a real query.
How it works
- Paste the result grid or `INSERT` statements.
- Click convert.
- Copy the JSON array.
- Use it as a fixture, mock, or import payload.
Privacy: This tool runs entirely in your browser. Your input is not sent to our servers.
Advertisement
Frequently asked questions
Are types inferred?
Numeric and boolean-looking strings are coerced. Dates and UUIDs stay as strings — safer for downstream parsing.
Can it produce nested JSON?
Output is flat. For nested structures, build them in code from the array.
Does it escape special characters?
Yes. The output is valid JSON with proper string escaping.