Data Editor preferences

You can fully customize how data is displayed and edited in the Data Editor.

Use these settings to change the appearance, behavior, formatting, and handling of different data types.

Tip

You can configure Data Editor preferences directly in the configuration file, without starting the application. For details, see how to manage preferences via config files.

All preferences are available at Window -> Preferences -> Editors -> Data Editor.

Customize general behavior of the Data Editor::

Setting	Description
ResultSet fetch size	Number of rows fetched from the database in one batch. Affects performance
Auto-fetch next segment	Automatically loads the next data segment when the current one is fully processed or viewed
Refresh data on next page reading	Refreshes the data when moving to the next page
Use SQL to limit fetch size	Modifies the source SQL query to scroll through or limit results. This is typically achieved using the LIMIT/OFFSET SQL clause
Automatic Row Count	Counts the number of rows only once when you first open the data viewer. It doesn't update automatically after that.
Ordering mode	Specifies how sorting is applied to query results: - Adaptive (default) chooses the best strategy depending on context; - Always on client sorts data after it's fetched; - Always on server enforces sorting in the SQL query
Default ordering	Specifies the default ordering of records. By default, the ordering is not changed, and the result set is displayed in the order in which it was fetched. Otherwise, this option has no effect if the table doesn't have a primary key. Please note that setting this option may result in an additional query to the database because information about constraints is unavailable beforehand
Query cancel timeout (ms)	Defines the duration (in milliseconds) the system waits before cancelling a non-responsive query
Always use subselect for filters	Forces the usage of subqueries when applying filters to the data
Use column names instead of column labels	Prioritizes column names over column labels when referencing data
Use fetch-size	Overrides the default JDBC fetch size. This is an advanced option and should only be changed if you know how the driver handles data fetching.
Use all table columns as a key upon saving	Forms a virtual composite key using all table columns for data saving. If set to true, this will determine the action taken if a key element is missing. If set to false, no action will be taken when a key element is missing
Disable data editing	Prevents data modification when a primary key is absent. This setting defines the action taken when the assumed primary key is missing
Keep open cursors in SQL editor	Closes the result set after a selection. To view a cursor column value, the option should be enabled
Insert new rows after current	Places newly inserted rows immediately following the currently selected row
Refresh after update	Automatically refreshes the data after making changes
Use navigator filters	Employs filters in the navigator to refine the displayed data
Activate advanced datetime editor	Enables the advanced datetime editor in the Data editor
Show confirmation before save	Displays a prompt asking for a confirmation before saving changes
Show errors in a dialog	Presents error messages in a separate dialog box
Mark occurrences of the selected cell's value	Highlights instances of the selected cell's value within the data set
Show images in web browser	Controls whether image data (e.g., PNG, JPEG stored as BLOBs) is displayed in the Value panel using an embedded browser. When disabled, images are shown as raw binary or hex.

Appearance

Customize how data looks in different modes.

Setting	Description
Switch to Record/Grid mode on single/multiple row(s)	Allow to switch between Record mode and Grid mode when dealing with single or multiple rows. When set to true, the system will automatically switch modes based on the number of rows selected (Record mode for a single row, Grid mode for multiple rows)
Show filters panel in single tab mode	Shows the filters panel when using a single-tab layout in the Data Editor
Show column description in header	Displays the description for each column in the header
Calculate column width by cell values	Adjusts the width of each column based on the content of its cells
Show connection name in status	Displays the name of the connection in the status section
Visualize complex columns	Enables the visualization of complex columns (such as objects, structures and arrays)
Right-justify numbers	Allows right-justify numbers
Right-justify date/time values	Aligns date and time values to the right side of their respective cells or columns
Enable auto-completion in data filter text	Activates the auto-completion feature in the data filter text field

Grid

Configure Grid view options.

Grid appearance

Setting	Description
Mark odd/even rows	Marks odd and even rows in the grid
Colorize data types	Colorizes data types in the grid
Show column type icons	Displays icons representing the data types of each column
Show attribute filters	Enables the display of attribute filters in the grid
Show attribute ordering	Shows asc/desc order icon in column header
Show booleans as checkboxes	Represents boolean values in the grid as checkboxes
Show whitespace characters	Displays whitespace characters within the grid
Show column ordering	Shows column order in the column headers
Value display format	Controls how values are shown in the Value panel: - Display (default) shows formatted read-only values, - Editable shows raw editable content - Database native shows the exact value as stored in the database.
Max auto size column %	Determines the maximum percentage of width a column can occupy

Grid behavior

Setting	Description
Highlight rows with selected cells	Enables the highlighting of entire rows when one or more cells are selected
Smooth scrolling	Enables smooth horizontal scrolling within the grid
Toggle boolean on click	Allows boolean values to be toggled with a single click
Select next cell after inline edit	After completing the inline edit, a cell on the next row will be selected, SHIFT+ENTER can be pressed to select the cell on the next column
Double-click behavior	Defines the action taken when a cell is double-clicked (None, Editor, Inline editor, Copy selected cell, Paste cell value into editor)
Row color batch size	Number of consequent rows with the same background color

JSON

Note

This feature is available in Lite, Enterprise, Ultimate and Team editions only.

Collapse large JSON objects or arrays to simplify viewing.

Setting	Description
Collapse objects that have more members than	Specifies the max amount of object members before collapsing
Collapse arrays that have more elements than	Determines the max amount of array element before collapsing
Collapse objects that have deeper nesting than	Determines the max nesting of an object before collapsing

Info

Read more on working with JSON.

Plain text

Adjust text data formatting.

Setting	Description
Tab size	Determines tab size
Maximum column length	Determines the maximum length of a column’s content
Value display format	Controls how values are shown in the Value panel: - Display (default) shows formatted read-only values, - Editable shows raw editable content - Database native shows the exact value as stored in the database.
Show NULLs	Enables the display of NULLs
Show line numbers	Enables the display of line numbers
Leading delimiter	Enables trailing delimiter
Trailing delimiter	Enables trailing delimiter
Top delimiter	Enables top delimiter
Bottom delimiter	Enables bottom delimiter
Extra spaces	Enables extra spaces

Binary editor

Configure how binary and LOB data is handled.

Setting	Description
Open in separate editor	Opens separate string editor instead of dialog
Binary data formatter	Determines the format in which binary data is displayed
Binary editor	Enables to change the binary Data Editor (EDITOR or PANEL)
Maximum length of binary strings	Determines the maximum length of binary strings
Maximum LOB length to keep in memory	Determines the maximum length of LOB (Large Object) data that will be kept in memory
String encoding	Allows to specify the character encoding used when interpreting binary data as strings
Cache CLOB values	Enables caching of CLOB (Character Large Object) values to reduce repeated reads
Cache BLOB values	Enables caching of BLOB (Binary Large Object) values for better performance
LOB cache max size	Sets the maximum total size of cached LOB data
Edit LONG columns as LOBs	Treats LONG column types (e.g. in Oracle) as LOBs for consistent editing
Maximum text editor content length (KB)	Limits the size of LOB content (in KB) shown in the text editor
Commit session on value edit apply	Automatically commits the transaction after applying edited scalar values
Commit session on content edit apply	Automatically commits the transaction after editing and saving LOB or large content fields

Data formats

Change how numbers, dates, and times are formatted in the Data Editor.

Info

For details, see Managing data formats.

Dictionaries

Define how DBeaver recognizes description columns.

Setting	Description
Keywords for dictionary description columns	Defines which column names are considered descriptive or label columns
Maximum amount of elements on a dictionary panel page	Determines how many dictionary values are shown per page

GIS viewer

Adjust spatial data viewer settings.

Setting	Description
Default SRID	Sets the default spatial reference system (e.g. 4326)
Maximum objects per viewer	Limits how many spatial objects are shown at once
Minimum zoom level	Prevents zooming too far out on spatial visualizations