Settings


Preferences → Settings opens the settings window: switch groups on the left, edit individual options on the right, then click Apply to save or Cancel to discard.

Global is application-level; the other groups are saved per workspace. Each workspace (one DataSource) has its own configuration: if workspace A is set to show 200 rows, workspace B keeps whatever you set for B — the two never affect each other.

Settings

Preferences: groups on the left, options on the right

Global

OptionDescriptionDefault
Recover On StartupKeep last closed state when startupOn
Exit ConfirmPrompts when exiting to avoid mistakenly exiting the systemOn
Auto Update—Notify me about updates
Enable crashReportSends os level crash reports and runtime app info.On
Share Usage Data (anonymous)Share full diagnostic data (logs & usage) to help us improve. If disabled, only license validation data is sent and no other dataOn

DataGrid

OptionDescriptionDefault
Auto FocusIf this value is true, it will try to get focus when opened.Off
Display LimitWhether to display the cell to limit the number of display, if not will slow down the rendering speedOn
Cell Max display limitMaximum number of characters to be displayed in a table cell1024 character
Show Style By Data TypeDisplay data color by data typeOn
Page Data LimitWhen Pageing max result size200 rows
Filter Data LimitQuick filter max result size200 rows
Maximum Load Data LimitLimit the maximum amount of data returned by a load query1000000 rows
Default Filter Sort Type—Desc
Enable columnCons ColorDisplay column constraints colorOn
Enable Replace Char when display—Newline, Tab, Last Space
Escape NullEscape Null Value ToNULL
Escape EmptyEscape empty string Value ToEMPTY
Clob/Blob display limitSetting Thresholds,Shorten longer hex/text data to show headers and footers for easier understanding50 character
Detect Text ValueDetect Binary Data to Text ValueOn
Detect File TypeDetect the file type, if it is an image type it will be previewed.On
Max Edit Cell LengthMaximum number of characters to be edited in a table cell10 KB
Max Copy Cell LengthMaximum number of characters to be copied in a table cell20 MB

QueryNav

OptionDescriptionDefault
Query File Data Show Type—Display All File
Auto Add Not ExistsWhen add by schema,create on not extisOn
Allow Hidden RootWhen on, if there is only one root node, it will be hidden.Off

Query Editor

OptionDescriptionDefault
Enable Soft TabsIf true will convert tabs to spacesOn
Soft Tab lengthConvert tab to how many spaces4
SqlEditor Font SizeYou can adjust this value to increase or decrease the SqlEditor size of the font, and the units support decimals.1 em
Auto Save TimeoutWhen the file is modified, it will be completed within this time and saved only once.2000 ms
Auto Focus on OpenIf this value is true, it will try to get focus when opened.Off

AutoComplete

OptionDescriptionDefault
Enable Add SpaceWhether to automatically add spaces after keywordsOff
Keywords Case—Auto
Enable DocletControls whether or not a doclet reminder pops upOn
Enable Auto AliasEnable to add an alias prompt after entering a table nameOn
Disable Auto CompleteDisable auto-complete,no prompt when typing SQL in SqlEditorOff

Others

OptionDescriptionDefault
SearchIn Max Data SizeMaximum number of records displayed for in-table search100