Skip to main content
The Data Viewer is a spreadsheet-like interface for the rows in a table. Open any table in the Data Model and click the Data tab to switch from schema design to record editing. It’s where you add seed data during development, eyeball the contents of a table, or fix a bad row by hand. Schema-level validations apply here too — uniqueness, mandatory fields, type constraints, and enum values are enforced just like they are through the GraphQL or REST API.

​
Adding a row

1

Click + Add row

The button sits in the top-left of the toolbar. A form opens with all the table’s fields.
2

Fill in the fields

Required fields are marked. Validation runs as you go — uniqueness, type, and constraint errors appear inline.
3

Click Add Row

The row is inserted and appears in the grid immediately.
Add row form in Data Viewer

​
Editing a row

Click any row in the grid to open the edit form, update the fields, and click Update Row. As with adding a row, schema validations run before the change is saved. Edit record form in Data Viewer

​
Deleting a row

Right-click the row you want to delete and choose Delete Row from the context menu. Confirm in the dialog that appears. Delete row confirmation in Data Viewer
Deleting a row is permanent. There is no undo from the Data Viewer.

​
Filtering

Click the Filter icon (funnel) in the toolbar to add filters. You can stack multiple filters — for example, “is_active = true AND created_at > 2025-01-01”. The grid updates as you add and remove filters. Filter records in Data Viewer The Data Viewer’s filter UI doesn’t span related tables. For filters that need joins, use the GraphQL API Explorer or the SQL Playground.

​
Sorting

Click the sort icon (up/down arrows) in the toolbar to add sort attributes. You can sort on multiple columns; the order in which you add them determines the priority. Sort records in Data Viewer

​
Showing and hiding columns

Click View in the toolbar to toggle which columns are visible in the grid. Audit columns — created_by, updated_by, created_at, updated_at — are hidden by default. Use Show All to bring them back, or Reset to return to the default view. Column visibility toggle in Data Viewer The current column selection also drives what gets exported when you run a CSV export — see Exporting data.

​
Preview a referenced record

A foreign key cell links a row to a record in another table. To read that record without leaving the current table, use the preview. Hover over a foreign key cell to reveal the View referenced record button at the right edge of the cell. Click it to open a card with the record the cell points to. The button doesn’t appear when the cell is empty. The card is titled “Table:” followed by the table name and lists every field of the referenced record. Each field shows an icon for its type, its name, and its value. The field the foreign key points to is listed first. Dates and timestamps appear in a readable format.
  • An empty value shows as null.
  • An encrypted field that Archie hasn’t revealed shows a lock icon and dots instead of the value.
Two buttons sit at the bottom of the card:
  • Copy ID copies the foreign key value to your clipboard. The button reads Copied for a moment afterward.
  • View in table opens the referenced table in a new browser tab on its Data tab, filtered to that record.
While the record loads, the card shows placeholders. If it can’t load the record, it shows “Couldn’t load the referenced record. You may not have access to it.” If no matching record exists, it shows “Referenced record not found.” The preview follows the same permissions as the rest of the Data Viewer.

​
Importing and exporting

The Data Viewer toolbar has dedicated controls for moving data in and out via CSV:

​
Permissions

Whether a user can read, add, edit, or delete rows — and whether specific fields are visible to them — is governed by Role-Based Access. The Data Viewer respects those rules: a field hidden from your role is hidden in the grid; a delete action you don’t have permission for is unavailable. The same applies to the referenced record preview: if you can’t read the related record, the card tells you.

​
FAQ

They’re audit columns the platform manages automatically. Hiding them by default keeps the grid focused on the fields you’re likely to edit. Toggle them on from the View dropdown when you need them.
The save fails and an inline error tells you which constraint was violated. The row stays in edit mode so you can fix the value.
Edits go through the same validations as the API, but anything you delete is gone. Use environments to keep production isolated — see Environments.
The Data Viewer edits one row at a time. For bulk updates, use a custom function or the SQL Playground.