DBeaver Documentation

Data Editor

The Data editor appears:

The Data editor allows viewing and editing the data of a database table or view.
The central part of the Data editor is the data table. The editor also provides two toolbars and a filter field:

To learn how many rows the data table 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 data table, see Navigation article.

The top toolbar contains the following buttons:

ButtonNameDescription
Apply filter criteriaApplies filter criteria entered in the filter field above the data table, see Data Filters article for more information
Remove all filters/orderingsRemoves all filters and orderings applied to the data
Save filter settings for current objectSaves the current filter settings for the database object to apply next time when you reopen it in the editor, see details in Data Filters article
Custom FiltersOpens the Result Set Order/Filter Settings window, see article for more information
Configure auto-refreshAllows configuring data auto-refresh settings, see Data Refresh article for details
Forward and backward - history navigation buttonsNavigate forward and backward in the Data Editor history, see History section of Navigation article for more information. The buttons are equivalent to pressing the key combinations: Alt+Left (backward) and Alt+right (forward).

The side bar contains the following tabs:

ButtonNameDescription Chart_button
GridSwitches to grid view of data
TextSwitches to plain text view of data
ChartSwitches to chart view. For more details on charts, see Managing Charts article.
Record- Same as pressing Tab<br/>- Switches the positions of rows and columns so that columns appear as rows, and rows hide in one Value column, see details in the Table vs. Record Views section of article.

The bottom toolbar provides the following buttons:

ButtonNameDescription
SaveSaves all unsaved changes to the data such as adding, duplicating, deleting rows, inline editing of values, see Data Viewing and Editing article for information
CancelDiscards all unsaved changes to the data
ScriptOpens the Preview Changes window in which you can see changes that you have made to the data, see details in Data Viewing and Editing article
Edit cell value in separate dialog/editorOpens the cell in focus for editing in a separate editor or dialog box, see details in Cell Editor section of Data Viewing and Editing article
Add new rowAdds a new empty row below the current row, see details in Adding, Copying and Deleting Rows section of Data Viewing and Editing article
Duplicate current rowCopies the current rows and pastes the copy below the current row, see details in Adding, Copying and Deleting Rows section of Data Viewing and Editing article
Delete current rowColors the rows in focus in red to mark them for deletion, see details in Adding, Copying and Deleting Rows section of Data Viewing and Editing article
Move to first rowMoves the focus (highlighting) from the current to the first row of the table
Move to previous rowMoves the focus (highlighting) from the current to the previous row of the table
Move to next rowMoves the focus (highlighting) from the current to the next row of the table
Move to last rowMoves the focus (highlighting) from the current to the last row of the table
Fetch next page of resultsFetches the next portion of data (next N rows) making it ready for display, see Scrolling Results Page section of Navigation article for more information
Fetch all rowsFetches the whole result set making it ready for display, see Scrolling Results Page section of Navigation article for more information
PanelsOpens panels on the right side of the Data Editor, see Panels for information
ConfigureOpens a dropdown menu with settings
JSON- Available in EE version only for MongoDB documents and JSON tables<br/>- Switches to JSON view of data
XML- Available in EE version only for XML tables<br/>- Switches to XML view of data
Generate Mock DataOpens the Mock Data Generator window, see TBD for details
Rows count detailsOpens the Status details dialog box showing the timing details of fetching table rows
Calculate total row countCalculates the total number of rows in the table

Every cell in the data table has a context menu – right-click the cell to open the menu. The context menu provides the following items:

Menu ItemDescription
CutCuts the content of the current cell or column to the clipboard
CopyCopies the content of the current cell or column to the clipboard
Advanced CopyOpens advanced copy submenu that allows copying data with preset formatting parameters
PastePastes the copied content to the cells in focus
Advanced PastePastes several values delimited with a tabulation or line break
DeleteDeletes the row that has the cell in focus<br/> NOTE: In fact, when users click Delete, the system only highlights the row red while the actual deletion happens when users click Save.
Edit cell- For CLOB/BLOB data format, opens the contents of the cell in a new tab<br/> - For all formats except CLOB/BLOB, opens a properties window for the cell<br/>
Inline edit- Same as double-click on a cell<br/>- Makes the cell editable
Set to NULLSets the value of selected cells to NULL
Hide columnHides the column currently in focus, see the Managing Display of Columns in Data Table section further in this article
Save to file…- Appears only for columns with BLOB/CLOB data<br/>- Opens the standard Save As window that allows saving data contained in the cell to a file
Load from file…- Appears only for columns with BLOB/CLOB data<br/>- Opens a standard window for opening files
Order/FilterDisplays a submenu that allows selecting 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.<br/> 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/FormatOpens a submenu that provides tools for formatting and modifying the view of data, see Data View and Format
NavigateOpens a submenu that helps users navigate throughout the data table, see Navigation
LayoutChanges the layout of data, see the Table vs. Record Views section of the Data View and Format article
Export ResultsetOpens the Data Transfer wizard that guides you through the steps to select a format and export data<br/>NOTE: The system exports the whole result set including records that are not visible in the screen and preserves all applied data filters and ordering.
Generate SQLOpens a submenu on which you can select the type of SQL query to generate
RefreshRefreshes the whole results set including all items that are not visible in the screen

For more information about using the Data Editor, please see the subsections of this article - open them via the contents tree on the right.