Manage data with Data Browser
Use the Data Browser in the Prisma Data Platform to view and edit your application data.
Models (tables or collections)
When you first open the Data Browser, you see a list of all models defined in your Prisma schema file.
model User
, refers to a table in a relational database (PostgreSQL, MySQL, SQL Server, SQLite, CockroachDB) or a collection in MongoDB.For more information, see Defining models.
You can select a model and its data opens in a new tab.

Open and close models
To open another model, click the + button.
To close a model, click the the x button in the model tab.

Icons of data types in models
The data type for each field is indicated with an icon in the header.
The table below lists all data types and their identifying icon.
Keyboard shortcuts in models
When you open a model, a number of keyboard shortcuts are available to browse and manipulate the data in the model.
Note
With the Data Browser tab open, you can open the keyboard shortcuts modal by pressing Cmd ⌘+/ on macOS or Ctrl+/ on Windows.

Edit data
In the model view, you can edit data directly in the model cells. You can copy and paste values in cells. You can add new records as well as delete existing records.
You must confirm every edit operation (add, edit, or delete). You confirm added and edited records with the Save change button. When you select records and click Delete records, you confirm the deletion in a dialog box.
You can accumulate multiple added records and edited cells, which you can then finalize with the Save changes button.
You can select multiple records and delete them at once with the Delete records button. When you delete multiple records, the operation completes immediately (after you confirm it).
In addition, if you have any accumulated added or edited records and then decide to delete records, the deletion also force-saves the accumulated edits.
You can discard any accumulated changes with the Discard changes button.
Copy and paste
You can copy the value of any table cell using:
- Cmd ⌘ + C on macOS
- Ctrl + C on Windows
To paste in another cell, first double-click the cell to enter edit mode, and then use:
- Cmd ⌘ + V on macOS
- Ctrl + V on Windows
Add a record
In the model view, click Add record.
Based on the data allowed in each field, type the data for the record.
(Optional) If you are unhappy with your changes, click Discard changes and start over.
Click Save 1 change.
Edit a record
- Double-click a cell with existing data to edit.
- (Optional) If you are unhappy with your changes, click Discard changes and start over.
- Click Save 1 change.
Delete a record
- From the left column, select the check box for the record you want to delete.
- Click Delete 1 record.
- Click Delete in the confirmation dialog.
Edit multiple records at once
You can add multiple records, edit multiple cells and, thus, accumulate multiple edits.
In the end, click Save changes to finalize them.
Warning
Deleting a record is a separate operation that cannot be accumulated. If you delete a record while having unsaved edits, the delete operation first force-saves the unsaved edits and then completes.

Filters
Filter data
Use the Filters menu to filter data in the model by adding conditions.
Steps
- Click Add a new filter.
- Configure the filter.
- Select the field by which you want to filter.
- Select a comparison operator.
- equals
- in
- notin
- lt
- lte
- gt
- gte
- not
- Type the value you want to use for the filter.
Step result: The model is filtered immediately after you define the first filter.
- To add a new filter, click Add a new filter and repeat the steps above.
- To remove a filter, click the x button on the right.
- To remove all filters, click Clear all.
- If you have too many filters and want to clear the UI real estate, click Show less and only the topmost filter remains visible. Click Show more to show again the rest of the applied filters.
Result
- The data in the model is filtered based on the conditions you added.
- The default None value in the Filters menu changes to the number of filters you added.
Show and hide fields
You can select which fields to view or hide by using the Fields menu.
title
field in model User { title String }
, refers to a column in a relational database (PostgreSQL, MySQL, SQL Server, SQLite, CockroachDB) or a document field in MongoDB.For more information, see Defining fields.
Steps
- Click the Fields menu.
- Select only the fields you want to see and deselect any fields you want to hide.
Result
The model is immediately filtered to hide the data from any fields you have deselected.
Also, the Fields menu shows the number of fields that are currently selected.
Show and hide records
You can also select to show or skip a specific number of records in the model view.
Steps
- Click the Showing menu.
- In the Take box, specify the maximum number of records that you want the model view to show.
- In the Skip box, specify how many of the first records you want to hide.
Result
The model is immediately filtered to show or hide records based on your selection.
The Showing menu indicates how many records are shown out of how many available records are in the model.
Sort data
Click a field title to sort by the field data.
The first click sorts the data in ascending order, the second - in descending order.
