SQL Minifier
Collapse a SQL query to one line and strip its comments.
Explore a JSON document as a collapsible tree with paths you can copy.
The JSON Viewer turns a document into a collapsible tree. Every branch shows how many keys or items it holds, every leaf shows its value with the type colour-coded, and clicking any node copies its full dot-notation path.
A large API response is unreadable as raw text and only slightly better pretty-printed. The viewer turns it into a tree you can walk: every object and array is a branch you can collapse, and every leaf shows its value with the type colour-coded.
The part that saves the most time is the path. Click any node and its full path is copied in dot notation — data.items[0].price — ready to paste into your code, a JSONPath expression or a test assertion. Branch headers show how many keys or items they hold, so you can see the shape of a thousand-item array without expanding it. There is also a filter box that hides everything except the branches matching your search.
One click puts data.items[0].price on your clipboard, ready for your code, a test assertion or a JSONPath expression.
Branches fold away with their child count still visible, so a thousand-item array takes one line until you want it.
Type in the filter box to hide everything except the nodes whose key or value matches your search.
Strings, numbers, booleans and nulls are colour-coded, so a number that arrived as a string is obvious immediately.
Two buttons open or close the whole tree, which is the fastest way to get a feel for an unfamiliar payload.
Any valid document, from a two-key object to a deeply nested API response.
Click a branch to open or close it, or use the buttons to expand and collapse everything at once.
Type in the filter box to show only the nodes whose key or value matches.
Click the path chip beside any node to copy its full dot-notation path to the clipboard.
Documents of a few megabytes render fine. Very large arrays are collapsed by default so the page stays responsive, and you expand only the branches you need.
Dot notation with bracketed array indexes, such as data.users[2].email. That is the form JavaScript, JSONPath and most assertion libraries accept.
No, the viewer is read-only. Edit the text in the input box and the tree redraws instantly, which keeps the source of truth in one place.
Never. The tree is built in your browser from the text in the box, so production payloads stay on your machine.
What people who use the JSON Viewer think of it. Reviews come from visitors and are posted as written.
No ratings yet
Yours would be the first.
0 reviews
Newest first
No reviews yet
Be the first to rate the JSON Viewer. It takes half a minute and no account.
Write the first reviewCollapse a SQL query to one line and strip its comments.
Stack CSS filters on a real image and copy the declaration.
Check any number against the Luhn checksum and see the working.
Convert a start and end address into the smallest set of CIDR blocks.
Convert HTML back into clean Markdown, keeping lists, tables and code.
Convert between px, rem, em, pt, %, vw and vh with the right context.
Reformat a MAC address between every notation, and decode what it means.
Build a cron schedule from controls and see the next times it runs.