Skip to main content

Data

Data Dashboard View

The data view provides insight into your current tables and the documents contained within each of those tables.

On the left side of the window is a list of your tables. Clicking on an individual table will drill down into a layout that allows you to create, view, update, and delete documents in that table.

Filtering documents

You may filters documents on the data page by clicking the "Filter" button on the top of the page.

Data filters

All fields in a document are filterable by the operations supported in Convex query syntax. Equality and Comparison when filtering in the dashboard share the same rules as a query using the Convex client. You may also filter based on the type of the field.

To add a filter, click "Add condition" in the filter selection menu. If you add more than one condition, they will be evaluated using the and operation.

For each filter, you must select a field to filter by, operation, and comparison value. In the third input box (selecting a value), you may enter a valid Convex value, such as "a string", 123, or even a complex object, such as { a: { b: 2 } }

note

When filtering by _creationTime, a date picker will be displayed instead of the normal JavaScript syntax input box. Comparisons for _creationTime are made at the nanosecond granularity, so if you'd like to filter to an exact time, try adding two filter conditions for creationTime >= $time and creationTime <= $time + 1 minute.

Creating tables

You may create a table from the dashboard by clicking the "Create Table" button and entering a new name for the table.

Creating documents

note

The dashboard currently supports editing all Convex types except Bytes.

You may add individual documents to the table using the “Add Documents” button located in the data table's toolbar.

Once you click “Add Documents” a side panel will open, allowing you to add new documents to your table using JavaScript syntax. To add more than one document add a time, add new objects to the array in the editor.

Add document

Editing a cell

To edit a cell's value, double-click on the cell in the data table, or press the Enter key while it’s selected. You can change the selected cell by using the arrow keys.

You can change the value by editing inline, and pressing enter to save.

note

You can even edit the type of your value here, as long as it satisfies your schema — try replacing a string with an object!

Inline value editor

Editing a document

To edit multiple fields in a document at the same time, hover over the row and click the button that appears on the right hand side.

Edit entire document

Adding references to other documents

To reference another document, use the string ID of the document you want to reference.

Deleting documents

To selectively delete documents from a table, hover over the “_id” cell of a document row and select the checkbox that appears. To select multiple adjacent documents at once, press the Shift key when clicking on the checkbox.

When at least one document is selected, the “Delete documents” button will be visible in the table toolbar. Clicking “Delete documents” will open a prompt to confirm deletion.

Delete documents

Clear a table

The "Clear table" button can be found by clicking on the overflow menu at the top of the data view. This action will delete all documents in the table, without deleting the table itself.

In production environments, the Convex dashboard will have you type in the name of the table before deletion.

Clear table

Delete a table

This is a permanent action

Deleting a table is irreversible. In production environments, the Convex dashboard will have you type in the name of the table before deletion.

Delete table

The "Delete table" button can be found by clicking on the overflow menu at the top of the data view. This action will delete all documents and indexes for this table, and remove the table from your list of tables. If this table had indexes, you will need to redeploy your convex functions (by running npx convex deploy or npx convex dev for production or development, respectively) to recreate the indexes.

Generating a schema

At the bottom-left of the view is a "Generate Schema" button which you can click to have Convex generate a schema of all your documents within this table.

Generate Schema button

Table Schema and Indexes

The "Schema Indexes" button can be found by clicking on the overflow menu at the top of the data view.

Indexes button

This button will open a view showing the saved schema and indexes associated with the selected table.

Indexes that have not completed backfilling will be accompanied by a loading spinner next to their name.

Table indexes