SQL for JSON

SELECT * FROM jsonsql.dev

Query JSON with SQL, JSONPath & MongoDB syntax.
Plus 18 more free developer tools — all client-side.

Try SQL for JSONAll query modes
⚡ Instant
🔒 No data uploaded
☁ Works offline
🚀 No sign-up

JSON Query Tools

flagship
SQL
SQL for JSONSELECT, WHERE, GROUP BY, ORDER BY on JSON data
›
$.
JSONPath EvaluatorDot notation, wildcards, filters, recursive descent
›
{ }
MongoDB Query$eq, $gt, $in, $and, $or, $sort, $limit, $project
›
?>
JSON Query (3-in-1)All three syntaxes in one tool
›

JSON Tools

3 tools
{ }
JSON EditorFormat, tree view & validate in one tool
›
≠
JSON DiffCompare two JSON documents side-by-side
›
§
JSON SchemaGenerate schema from sample data
›

Converters

3 tools
SQL
JSON ↔ SQLConvert between JSON and SQL statements
›
⇄
JSON ↔ CSVConvert between JSON and CSV/TSV
›
⇄
JSON ↔ YAMLConvert between JSON and YAML
›

Developer Tools

6 tools
⚿
JWT DecoderDecode header, payload & signature
›
B6
Base64Encode and decode Base64 strings
›
%
URL EncodeEncode and decode URL components
›
#
Hash GeneratorMD5, SHA-1, SHA-256, SHA-512
›
id
UUID GeneratorGenerate UUID v4 and v7
›
.*
Regex TesterTest regex with live highlighting
›

Why developers choose jsonsql.dev

🛡

100% client-side

All processing happens in your browser. No data is ever sent to any server. Verify it yourself in DevTools.

⚡

Instant results

No server round-trips. Paste your JSON and get results in milliseconds, even with large files.

🌐

Works offline

Once loaded, every tool works without internet. Perfect for air-gapped environments.

🔓

No sign-up, no limits

No account required. No usage caps. No ads. Just open and use — forever free.

Frequently asked questions

Is jsonsql.dev free?

Yes, all tools are completely free with no usage limits, no sign-up, and no ads.

Is my data safe?

Absolutely. All processing happens in your browser using JavaScript. No data is ever sent to any server. You can verify this by checking the Network tab in your browser's developer tools.

Does it work offline?

Yes. Once the page is loaded, all tools work without an internet connection.

What browsers are supported?

jsonsql.dev works in all modern browsers: Chrome, Firefox, Safari, Edge, and Brave.

Can I use these tools for commercial projects?

Yes. There are no restrictions on how you use the tools or the output they produce.