GUI Tools Working with Table

Json and Tree views

For MongoDB, Elasticsearch, DynamoDB and Redis, a table has two more views next to Data at the bottom of the window: Json and Tree. Both show the rows of the current page, with the filters of the Data view, one document each.

Json view

Click Json, or press ⌃ + ⌘ + ]. Each document is shown in its own box, numbered, with line numbers. Nested objects start folded: click the arrow in the gutter to unfold them.

  • To edit a document, type in its box. TablePlus updates the row a second after you stop typing. While the JSON isn't valid, the number of the document turns red and the change isn't kept until you fix it.
  • To add a document, click + Row. TablePlus adds {} and puts the cursor in it.
  • To delete a document, select it and press Delete, or right-click it and choose Delete.
  • To copy documents, select them and press ⌘ + C. TablePlus copies them as a JSON array.

Tree view

Click Tree to see each document as a list you can expand. Select a value to see its object in the right sidebar, and edit it there. Right-click a document and choose Delete, or press Delete, to delete it.

Search and save

In both views:

  • Type in Search for key or value... (⌘ + F) to show only the documents with a matching key or value. The Tree view expands the matches.
  • Click the button left of the search field to Expand All or Collapse All.
  • Press ⌘ + S to commit your changes to the database.

Only MongoDB can add or remove keys of a document from these views. For the other databases, you can change values, but TablePlus shows "Keys can't be added or removed here" if you add or remove a key.