Query JSON with SQL

Input

Output

Query JSON with SQL

Write a SELECT query against your JSON as if it were a database table. FROM data is the whole input, and FROM data.items queries a nested array.

How to use it

Paste JSON with an array of records.
Write a query such as SELECT name, price FROM data.items WHERE price > 500.
See the result as a table or JSON.

What it does

WHERE, GROUP BY, HAVING, ORDER BY and LIMIT
LIKE, IN and CASE
COUNT, SUM, AVG, MIN and MAX

Questions

Do I need a database?: No. The query runs in your browser against the JSON you paste.
Is my data uploaded?: No. Bracely runs entirely in your browser, so nothing you paste or open leaves your device.

More JSON tools

Bracely has more than 65 JSON tools in one page. Related ones:

Runs entirely in your browser. Nothing you paste is uploaded. Made by Saurabh Pagrut. About · Privacy policy
Saurabh Pagrut on GitHub · LinkedIn · X · YouTube · Instagram