SQL to JSON Converter

Convert SQL query results, tabular exports, and simple INSERT SQL into typed JSON with editable column mapping, manual nesting, and local-only browser processing.

Mode: Result rowsFormat: autoOutput: flat rowsInput: 76 B
All processing happens locally in your browser. No data is uploaded or stored.
Paste query results, CSV/TSV rows, or simple INSERT SQL to generate JSON.

How to Use

  1. Paste query results, upload a tabular export, or switch to INSERT SQL mode for simple SQL dumps.
  2. Optionally add SQL query text for alias hints when your result columns need better output names.
  3. Review the parsed rows, adjust the column mapping, and switch to grouped output if you need nested child arrays.
  4. Copy the generated JSON, download it as a `.json` file, or hand it off directly to the JSON Viewer or Grid Viewer.

Related Tools

JSON to SQL ConverterJSON Pretty Print & ViewerJSON Grid ViewerCSV to JSON

Frequently Asked Questions

Does this tool execute SQL queries?

No. The tool never connects to a database or executes SQL. It only parses pasted result rows, uploaded tabular data, or simple INSERT SQL text locally in your browser.

What SQL input does v1 support?

V1 supports result-row inputs such as CSV, TSV, pipe-delimited text, MySQL-style result tables, psql-style result tables, and simple INSERT INTO ... VALUES statements. Full SELECT query parsing is out of scope for this release.

Can I turn joined rows into nested JSON?

Yes. The default output stays flat and predictable, but you can switch to grouped output and explicitly choose parent keys, child keys, and child columns to assemble nested collections.

Can I rename keys or force value types?

Yes. The mapping grid lets you include or exclude columns, change the output key path, and override detected value types before copying or downloading the JSON.

Is my SQL or result data uploaded anywhere?

No. All parsing, mapping, nesting, and JSON generation happen locally in your browser. No data is uploaded or stored.