The database editor is where you view and manage the data in your app. You'll find it in the Data tab, in the App data section. From here you can browse your data, search and filter it, edit values directly in the table, and import, modify, or export data in bulk.
The new database editor is in beta. To try it, click Try new at the top of the App data section. To switch back to the previous editor, turn off the Beta toggle next to the App Data heading.
Your app has two separate databases: one for the development version and one for the live version. The banner above the table shows which one you're viewing. See Switching between development and live data.
An overview of the database editor
The new database editor in the App data section of the Data tab.
Area | What it's for |
Data types and views | The list on the left shows your app's data types and any views you've created. Select one to show its data in the table. |
Toolbar | Buttons for working with data in bulk: Bulk, Modify, Export, Import, and New entry. More options are in the ⋮ menu. |
Table controls | Buttons to choose which columns to show and to filter the data, plus a search bar. |
Database banner | Shows whether you're viewing development or live data, with a link to switch. |
Table | Your data, with one row per record and one column per field. Each column shows the field's name and type. You can edit values directly in the table. |
Compared to the previous editor, the new one lets you edit data directly in the table, makes filtering and column settings easier to reach, and splits large datasets into pages instead of loading more records as you scroll.
Switching between development and live data
The banner above the table shows which database you're viewing, for example Currently viewing dev data. To switch, click Switch to live or Switch to dev in the banner.
Changes you make to live data affect your users right away. Check the banner before you edit, import, or delete data.
Views
A view is a saved way of looking at the records of a data type. Each view is made up of:
Part | What it controls |
Columns | Which fields are shown in the table |
Sorting | The order records are shown in |
Filters | Which records are included |
Bubble adds a default view for each data type, showing all its records. You can create as many extra views as you like, for example a view of Users who signed up this month, or Orders that haven't shipped yet. Views you create are listed under their data type on the left, and are shared between the development and live databases.
Create a view
1. Open the data type's menu
In the list of data types and views, hover over the data type you want to create a view for, and click the ⋯ icon next to it.
2. Click Add View
In the menu, click Add View.
3. Give it a name
Give the view a name that describes what it shows.
4. Set up columns, sorting, and filters
Choose which columns to show, how to sort the records, and add filters to narrow down which records are included.
The same menu also lets you duplicate the view with Duplicate View, rename it with Rename, add notes with Add notes, and open the data type's privacy rules with Go to privacy rules.
Finding data
Search
Type in the search bar above the table to find records in the current view. The search looks for the text you enter, or a record's unique ID.
When you search, common words like "the" and "and" (called stop words) are ignored, based on your app's default language.
Search doesn't look inside fields that link to other data types, not even their primary fields. For example, if each Project has a Company field, searching Projects for "Acme" won't find a project linked to Acme Corp, unless "Acme" also appears in one of the project's other fields.
Filter
Click the filter button next to the search bar to add filters. A filter limits the table to records that match a condition, for example category is Technology. You can combine several filters to narrow the results further, and save them as a view.
Filters limit the table to records that match a condition.
Choose which columns to show
Click the columns button next to the filter button to choose which fields are shown in the table, and in what order.
Browse large datasets
Large datasets are split into pages. Use the page controls below the table to move between them.
Editing data
Edit a value
You can edit most values directly in the table, without opening a separate editor.
1. Select the cell
Click the cell you want to edit.
2. Enter the new value
Type the new value, or choose one from the list for fields like option sets and linked data types.
Edit values directly in the table.
3. Save the change
Press Enter, or click outside the cell, to save. Press Escape to cancel.
Changes are saved as soon as you confirm them. If you're viewing live data, they reach your users right away.
Add a record
Click New entry in the toolbar, or + New entry below the table. This works the same way as the Create a new thing action in a workflow.
Delete records
Select the records you want to delete, then delete them. To delete many records at once, use a view with filters to show only the records you want to remove, and select them all.
Keyboard shortcuts
You can use keyboard shortcuts to move around the table and edit values without reaching for the mouse.
Shortcut | What it does |
Arrow keys | Move between cells |
Enter | Start editing the selected cell, or save your change |
Escape | Cancel your change |
Primary fields
A primary field is the field that best describes a record of a data type. It's used to represent the record when it appears in another data type's field. For example, a User might be represented by their email, and an Apartment by its address. In the table, linked records are shown by their primary field.
Ideally, choose a field that's unique to each record. For users, the email is a good choice. If no other field works, the unique ID is always unique.
Primary fields are only used for display in the App data section. If you export a view, linked records appear as their primary field, but this doesn't apply to workflow actions like Download data as CSV.
Running your app as a user
When you're debugging, it can help to see your app exactly as a specific user sees it. In the User data type, use the Run as option on a user's row to open your app in a new tab, logged in as that user.
You stay logged in as that user until you log out, and any changes you make are made as that user. Be careful not to change anything you shouldn't.
Importing data
Click Import to upload data from a CSV file. The data type and its fields need to exist in your app before you import. Importing is available on paid plans.
1. Choose the data type and file
Select the data type to import into, choose the delimiter your file uses, and select the CSV file.
2. Map the columns to fields
For each column in your file, choose the field it should go into. See the table below for details.
3. Validate the data
Click Validate data to check the first rows of your file for errors before you upload.
4. Upload
Click Upload data. Bubble uploads the file and processes it in the background, using your app's server capacity. You can close the page while it runs. You'll get an email when the import is done, or if there's an error.
Setting | What it does |
Type of data | The data type the records are imported into. |
Data delimiter | The character that separates values in your file. Commas are most common, but tabs or pipes (|) work well when your data includes commas. |
Custom field | The field each column is imported into. |
Composite field | For columns that link to another data type, the field used to find the linked record. For example, if each Apartment has an owner, and your file lists owners by last name, choose Last name. The linked records need to exist before you import, and each value needs to match exactly one record. |
List delimiter | For fields that hold a list, the character that separates the items. It needs to be different from the data delimiter. For example, with |
The first row of your file needs to be a header row with the field names. See this sample file for reference.
All data needs to be valid for its field. For example, a yes/no field can only contain yes or no. Bubble checks every row before importing, and if one row fails, nothing is imported.
Only one import or modify can run at a time in each app.
If you regularly import large amounts of data, it's usually more efficient to create records with a script through the Bubble API.
Modifying data in bulk
Click Modify to update many existing records at once from a CSV file. The file needs a column with the unique ID of each record you want to change, plus a column for each field you want to update.
Running bulk operations
Click Bulk to run an API workflow on many records at once, for example to update or delete them. See Bulk operations for details.
Exporting data
Click Export to export the records in the current view as a CSV or JSON file. You'll get an email with a download link when the file is ready. Exporting is available on paid plans.
Since you're exporting as the app owner, privacy rules don't apply, and every field in the current view is included in the file.
Make sure your app's scheduler isn't paused before you export.
Copying and restoring the database
You can copy data between your development and live databases, restore a database to an earlier point in time, and delete your database's change history. See these articles for details:
Article: Copying your database
Article: Restoring your database
Article: Delete all database change history
Cleaning up your data
It's a good idea to clean up your database from time to time, especially as your app grows.
To delete... | How |
A whole data type and all its records | In the Data types section of the Data tab, click the trash icon next to the data type. The data can't be recovered afterward. |
Specific records | In the App data section, create a view with filters that show only the records you want to remove, then select and delete them. |
Large numbers of records | Use a bulk operation to run an API workflow that deletes the records. |
FAQ: The database editor
Can I switch back to the previous editor?
Can I switch back to the previous editor?
Yes. While the new editor is in beta, you can switch back by turning off the Beta toggle next to the App Data heading.
Are views shared between development and live?
Are views shared between development and live?
Yes. Views are shared between the two databases, but the data each view shows depends on which database you're viewing.
Do privacy rules apply in the database editor?
Do privacy rules apply in the database editor?
No. As the app owner, you can see and edit all your app's data in the database editor, regardless of privacy rules.
Other ways to learn
Video lessons
Video lessons



