JSON Editing


Cells in a json column can open a tree editor directly: objects and arrays expand level by level, and strings, numbers, and booleans are colored by type.

▶ Tutorial

Expand the structure → change values → add or remove properties → filter

Tree view

JSON value editor

Full-window view; the red box marks the JSON value editor

  • Keys are shown in bold, and values are colored by type: strings green, numbers blue, booleans purple, null gray.
  • Objects and arrays expand level by level, and a collapsed array shows its element count, for example users: Array(2).
  • The top line shows the path of the selected node, for example {"0": {name: "Alice", age: 25}}.
  • The CELL tab at the bottom contains the same editor, so you can edit directly in the panel.

Edit a value

  1. Click the node you want to change; the input at the top loads that node’s fragment, for example { number: 42 }.
  2. Edit the value directly; strings need quotes: { number: 43 }.
  3. Press Enter or click outside the input to submit; the tree refreshes as soon as parsing succeeds.

The change is written to the cell only; you still need to return to the grid and click Apply to write to the database.

Add or remove a property

  • Add a property: select the parent node and add an entry to the fragment, for example { name: "Alice", age: 25, sex: "f" }; after submitting, the new key is merged into the original object.
  • Modify a property: change only the value of that key; unmentioned keys stay unchanged.
  • Remove a property: select the node and click the delete button in the toolbar; the editor sets the value to {} and submits, which deletes the key from an object or removes the element from an array.
  • Array elements: arrays expand by index (0, 1, …), and editing an element is the same kind of operation as editing an object property.

Filter the tree

Filtering the JSON tree

Full-window view; the red box marks the filter input

Click the funnel icon in the toolbar to switch to filter mode; the input prompts Type to filter tree by key or value:

  • Filter by key or value; matching nodes are kept and the rest hidden.
  • Press Esc to clear the filter and exit filter mode.
  • Filtering only affects display and does not change data; clearing it restores the full tree.

Errors and formatting

  • If the input fragment is not valid JSON/JSON5, the editor shows a red error message at the bottom and the original value stays unchanged.
  • Submitting preserves the original indentation; if the original field is JSON, the output is JSON, and if it is JSON5, the output is JSON5.