Skip to main content

​
JSON Viewer

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

​
Open

  • JSON-typed column: click the chevron in the cell. Double-click or Enter edits the value inline instead.
  • TEXT or VARCHAR column holding JSON: right-click the header and pick Display as > JSON. Double-click or Enter then opens the viewer.
The viewer opens as a popover anchored to the cell. To stop treating a column as JSON, right-click the header and pick Display as > Raw Value.

​
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.