Data Editor
Table of contents
Overview
The Data editor appears:
- as the Data tab of the Database Object Editor, which is only available for tables and views;
- as the Results tab when you run a custom SQL query in SQL Editor.
The Data editor allows to view and edit data of a database table or view. The central part of the Data editor is the data grid. The editor also provides top toolbar, bottom toolbar, left side bar, right side bar and a filter field:
To learn how many rows the table data contains, click the Calculate total row count button in the bottom toolbar.
The number of rows appears in a status field next to the button: 
To learn about ways to navigate data in the table data, see Navigation article.
Top toolbar
The top toolbar contains the following buttons:
| Button | Name | Description |
|---|---|---|
 | Remove all filters/orderings | Removes all filters and orderings applied to the data in the filter field. |
 | Save filter settings for current object | Saves the current filter settings for the database object to apply next time when you reopen it in the editor, see details in the Data Filters article. |
 | Custom Filters | Opens the Result Set Order/Filter Settings window. See Data Filters article for more information. |
 | Forward and backward - history navigation buttons | Navigate forward and backward in the Data Editor history, see the history section of our article for more information. |
Left side bar
The left side bar contains the following tabs:
| Button | Name | Description |
|---|---|---|
 | Grid | Switches to the grid view of data. |
 | Text | Switches to the plain text view of data. |
 | Spatial | Switches to the spatial view. For more details, see the GIS data article. |
 | Chart | Switches to the chart view. For more details on charts, see the Managing Charts article. |
 | Record | - Same as pressing Tab - Switches the positions of rows and columns so that the columns appear as rows, and the rows hide in one Value column. See details in the Table vs. Record Views section of our article. |
Right side bar
The right side bar contains the following tabs (see the Panels for more information):
| Button | Name | Description |
|---|---|---|
 | Panels | Opens panels on the right side of the Data Editor. |
 | Calc | Opens the result cells calculation panel (SUM, MAX, AVG, etc.). |
 | Grouping | Opens grouping panel window tools. |
 | Metadata | Opens Metadata panel. |
 | References | Opens References panel. |
 | Value | Opens Value Viewer. |
 | Result Details/Query Trace | Opens the Result Details or Query Trace panel depending on the database. |
Note: The Result Details panel is compatible with specific databases such as BigQuery, while the Query Trace panel is available for Cassandra and Yugabyte CQL. For guidance on enabling Query Trace, see Panels article.
Bottom toolbar
The bottom toolbar provides the following buttons:
| Button | Name | Description |
|---|---|---|
 | Refresh | Refreshes the whole results set, including all items that are not visible on the screen, while its dropdown option allows to customize the refresh frequency over a specific period. |
 | Save | Saves all unsaved changes to the data such as adding, duplicating, deleting rows, inline editing of values. See the Data Viewing and Editing article for information. |
 | Cancel | Discards all unsaved changes to the data. |
 | Edit cell value in separate dialog/editor | Opens the cell in focus for editing in a separate editor or dialog box. See details in the Cell Editor section of our article. |
 | Add new row | Adds a new empty row below the current row, see details in the Adding, Copying and Deleting Rows section of our article. |
 | Duplicate current row | Copies the current rows and pastes the copy below the current row, see details in Adding, Copying and Deleting Rows section of our article. |
 | Delete current row | Colors the rows in focus in red to mark them for deletion, see details in the Adding, Copying and Deleting Rows section of our article. |
 | Move to first row | Moves the focus (highlighting) from the current to the first row of the table. |
 | Move to previous row | Moves the focus (highlighting) from the current to the previous row of the table. |
 | Move to next row | Moves the focus (highlighting) from the current to the next row of the table. |
 | Move to last row | Moves the focus (highlighting) from the current to the last row of the table. |
 | Fetch all data | Fetches the whole result set making it ready for display. See the Scrolling Results Page section of our article. |
 | Configure | Opens a menu with settings. |
 | Result-set fetch size | Displays the initial fetch number of rows in the result set on loading or refreshing. |
 | Calculate total row count | Calculates the total number of rows in the table. |
Note: Some of these buttons may be disabled and may not work if you are using a read-only connection, connecting to a read-only database or if you see the result of a complex query, such as joining two or more tables.
Table status indicators
When working in the Data Editor grid, you might notice icons in the top left corner of each table. These icons are tools to help you quickly understand why you may encounter limitations while attempting to edit data in specific tables. Here is a guide to understanding what each icon means and how it can help you:
| Icon | Indicator | Description |
|---|---|---|
 | No unique key was found. Data modification is not possible. | The table lacks a unique key, restricting editing. |
 | PRIMARY KEY column_name | A unique key enables editing of the table. |
 | VIRTUAL PRIMARY KEY column_name. | A virtual key enables editing of the table. For more information about virtual keys, see Virtual keys. |
 | Table metadata not found. Data edit is not possible. | Unavailable metadata prevents editing of the table. |
 | Read-only connection. | A read-only connection prevents any edits. |
Column context menu
Each column has a context menu, accessed by clicking the downward arrow button 
, providing different filter options.
Cell context menu
Every cell in the table data also has a context menu – right-click the cell to open the menu. The context menu provides the following items:
| Menu Item | Description |
|---|---|
| Copy | Copies the content of the current cell or column to the clipboard. |
| Advanced Copy | Opens advanced copy submenu that allows copying data with preset formatting parameters. |
| Paste | Pastes the copied content to the cells in focus. |
| Advanced Paste | Pastes several values delimited with a tabulation or line break starting from the selected cell. |
| Delete | Deletes the row that has the cell in focus. NOTE: In fact, when users click Delete, the system only highlights the red row while the actual deletion happens when users click Save. |
| Edit | Opens a submenu enabling inline editing. See the Data Viewing and Editing article. |
| Order | Displays a submenu that allows to specify ordering criteria for the data. The submenu contains the most common ordering options that can be applied to the column in focus. See details in Data Filters article. By default, DBeaver orders data by sending a request to the server (the Server-side results ordering checkbox selected). To order data on the client side using DBeaver's internal algorithm, clear the checkbox. |
| Filter | Displays a submenu that allows to specify filter criteria for the data. The submenu contains the most common filters that can be applied to the cell in focus. See details in Data Filters article. By default, DBeaver filters data by sending a request to the server (the Server-side results ordering checkbox selected). To filter data on the client side using DBeaver's internal algorithm, clear the checkbox. |
| View/Format | Opens a submenu that provides options for formatting and modifying the view of data. See the Data View and Format article. |
| Navigate | Opens a submenu that helps users to navigate through the table data. See the Navigation article. |
| Layout | Changes the layout of data, see the Data View and Format article. |
| Export data | Opens the Data Transfer wizard that guides you through the steps to export data to a selected format. See the Data Transfer article. Note: The system exports the whole result set including records that are not visible on the screen and preserves all applied data filters and ordering. |
| Generate SQL | Opens a submenu where you can select the type of SQL query to generate. See the SQL Generation article. |
| Generate Mock Data | Opens Mock Data Generator. See the Mock Data Generation in DBeaver article. |
| Logical structure | Opens a submenu allowing you to write virtual column expressions. See the article about Virtual column expressions. |
| Open with | Opens the data in external applications like Excel or a web browser. |
| Toggle result panel | Opens Value Viewer panel on the right side of the Data Editor. |
| Refresh | Refreshes the whole results set including all items that are not visible on the screen. |
Additional features
Disabling metadata queries
If you want to improve performance and save money in databases where you pay for each query, you can stop reading the metadata queries in the Data Editor. This means the editor would not automatically ask for information about tables and columns.
To enable, navigate to Window -> Properties -> Connections -> Metadata and check the option Do not read tables information in SQL and data editors.
Benefits:
- Makes the Editor work faster because it runs fewer queries.
- Saves money in databases where each query costs you, by only running queries that you start yourself.
Disadvantages:
- You won't have auto-completion or other tools that need metadata.
- Results from queries are read-only. To check if modifications are possible, look for an indicator in the top left corner of the table grid. For more information on indicators, see Table status indicators.
Tip: This setting is particularly valuable for managing databases like Google BigQuery or Snowflake.