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
⌘ + Sto 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.