JSON Viewer

Open and edit JSON cell values with text and tree view modes, including a pop-out window for large payloads.

JSON Viewer

Open JSON values from cells in two view modes: Text and Tree.

Open

• Double-click a cell whose value parses as JSON, or
• Click the chevron in a JSON-typed column.

The viewer opens as a popover anchored to the cell. JSON values stored in a TEXT or VARCHAR column open the viewer the same way; double-click runs a parse and routes to the structured viewer when the value parses cleanly.

To opt out for a specific column, right-click the column header and pick Display as > Raw Value. Pick Display as > JSON to force JSON routing on a column whose values do not start with { or [.

Modes

Switch with the segmented control in the viewer toolbar.

• Text: syntax-highlighted JSON, pretty-printed by default. Editable when the cell is editable. Press Cmd+F to find within the value.
• Tree: collapsible tree with a search field. Read-only navigation.

Both modes keep your original key order and exact number values, including integers larger than JavaScript can represent. Formatting is display only: it never reorders keys or changes the stored value.

The default mode is set in Settings (Cmd+,) > Editor > JSON Viewer > Default view.

If the document is too large to render as a tree, the tree mode shows an unavailability message and you stay in Text mode.

Open in Window

Click the pop-out button in the toolbar to detach the viewer into its own resizable window. Useful for large payloads or side-by-side reading. The window supports fullscreen.

Editing

Opening a value and viewing it pretty-printed is not an edit. The row is marked changed only when you alter the content. Reindented whitespace and a different layout on screen do not count, so browsing JSONB row by row stays clean.

In the pop-out and cell editors, click Save to commit through the standard change-tracking flow: the edit becomes a pending change in the data grid, previewed and applied via Save Changes. Click Cancel to drop the edit. The saved value is compact, with your key order and numbers preserved.

If the edited text is not valid JSON when you save, the viewer prompts for confirmation before committing.

See also: the JSON tab in the results status bar (Data / Structure / JSON) for whole-row JSON inspection.