Which SQL client formats are supported?

Any client that outputs a header row followed by data rows works — psql (pipe-delimited), MySQL CLI (pipe-delimited), DBeaver, DataGrip, or a simple TSV export. Select the matching delimiter in the options.

Are numeric values kept as numbers in the JSON?

Yes. The tool auto-detects integers and decimals and emits them as native JSON numbers, not quoted strings. Booleans (true/false) are also detected.

What happens with NULL values?

Cells that contain NULL (case-insensitive) or are completely empty are converted to JSON null.

Does the tool send my data to a server?

No. All processing runs entirely in your browser with JavaScript. Your data never leaves your machine.

What about the separator line psql prints (e.g. ------+------)?

Lines composed entirely of dashes and plus signs are automatically skipped — they are treated as decorative dividers, not data rows.

SQL Result to JSON Converter

Paste a SQL SELECT result (pipe or tab delimited) and get a clean JSON array of objects.

SQL Result Input

Delimiter:

Indent:

Try a sample:

JSON Output

Copied!

Summary

This tool converts a SQL SELECT result set — the text output you copy from a database client like psql, MySQL CLI, or DBeaver — into a properly typed JSON array of objects. Paste the table including its header row, choose the delimiter, and the converter handles quoting, type detection, and formatting automatically. Numbers and booleans are emitted as native JSON types, not strings.

How it works

Copy the result set from your SQL client, including the header row.
Paste it into the input area on the left.
Select the delimiter that matches your output (pipe | or tab).
The tool parses each column header as an object key.
Each data row becomes a JSON object, with numbers and booleans auto-typed.
Copy the JSON output with one click.

Use cases

Convert a quick SQL query result into a JSON fixture for unit tests.
Transform exported database data for use in a REST API response.
Feed SQL output into a JavaScript or Python script that expects JSON.
Share structured data with a front-end developer who does not have database access.
Prototype API responses without writing a full backend layer.
Convert reporting query results for import into charting tools.

Frequently Asked Questions

Last updated: 2026-05-23 · Reviewed by Nham Vu