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 60 JSON tools in one page. Related ones:
Runs entirely in your browser. Nothing you paste is uploaded. Privacy policy