Tool Properties
In Tools → Tool Properties, you set how DbVisualizer looks and works. The settings are saved in the current workspace. For the other places where settings are set, see Configuring DbVisualizer.
Tool Properties has two tabs: General, with settings for DbVisualizer as a whole, and Database, with settings for each database type. Select a category in the tree to see its settings. To find a setting, use the Search field, see Searching Tool Properties. To reset the settings of the selected category, click Defaults.
General tab
General
The name of the workspace and the options for the Java VM that runs DbVisualizer. See Java VM options.
- Workspace Name: The name of the current workspace. You can't rename the default workspace. See Renaming a workspace.
- Workspace Directory: The folder where the settings of the workspace are saved. Click the path to open the folder.
- Reset Hidden Messages: Shows the messages again that you have chosen not to show again.
- Java VM Properties: Your own options for the Java VM, such as the maximum memory (
-Xmx), in the upper field. The lower field shows the default options.
Appearance
The theme, the sidebars, the window title bar, the icon sizes and the window layouts. See Changing the Appearance.
- Theme: Light or dark. With Automatic (default), the theme follows the operating system.
- Use Sidebars: Shows the sidebars, which you use to switch between views such as Databases, Files and Git. Show Button Labels shows text under the buttons, and Show Large Button Icons uses large icons. See Customizing the sidebars.
- Show Full Path in Window Title: Shows the full path of the selected tab in the window title, not only its name.
- Full Window Support: Uses the whole window, including the title bar, for DbVisualizer, with the menus in the title bar. Restart DbVisualizer after you change it.
- Icon Sizes: The size of the icons in Menus, Main Toolbars and Sub Toolbars.
- Reset Layouts: Resets the layout of the main window, the work area, the monitor window or the Object View tabs of a database type. Select the layouts and click Reset Selected Layout(s).
Fonts
The fonts of the application, the grids and the text editors. Select the check box next to a font to choose another font than the default. See Fonts.
- Application: The font of menus, buttons, labels and all other text, except in grids and text editors.
- Grids: The font of the grids.
- Text Editors: The font of the text editors. Only monospaced fonts are listed by default, since other fonts may not show correctly in an editor.
Editor Styles
The colors and font styles of the text editors, and the column guide. The colors and styles are saved for the current theme. See Changing the colors.
- Editor Colors: The colors of the editor itself, such as the background, the selection, the current row and the caret.
- Token Styles: The color and font style of each type of token, such as keywords and comments. Choose the language in the Syntax list.
- Show Guide at Column: Shows a vertical line at the column you set. See Showing a column guide.
Grid Colors
The colors of the grids. The colors are saved for the current theme. See Colors.
- Grid Colors: The colors of odd and even rows, null values, quick filter matches, truncated values, edited cells, deleted rows and the grid lines.
Key Bindings
The keyboard shortcuts. See Changing Keyboard Shortcuts.
- Key Bindings: The keymaps, and the key bindings of each action. To change a key binding, first make a copy of the keymap.
Database Objects Tree
How the tree in the Databases tab works. See Keeping the tree and the tabs in sync.
- Double-Click Actions for Database Objects: What happens when you double-click an object, and when you hold down
Altwhile you double-click: open it in a tab, in a new tab or in a floating tab, or expand or collapse it. See Database objects. - Autoscroll: With Autoscroll TO Object View tab, the object you select in the tree opens in an Object View tab. With Autoscroll FROM Object View tab, clicking the header of an Object View tab selects its object in the tree.
- Visited Foreground: The color of objects that you have opened.
Tabs
How tabs are labeled, where new tabs open, and which tabs are kept between sessions. See Customizing Tabs.
- Tabs Labelling Scheme: The label of Object View, SQL Commander and result set tabs. See Changing the tab label.
- Show SQL in Tooltip: Shows the SQL statement in the tooltip of a result set tab. With Truncate and Max, you limit its length.
- Preserve SQL Commander tabs between Sessions: Opens the SQL Commander tabs again, with their content, when you start DbVisualizer. On by default. See Keeping Tabs Open Between Sessions.
- Preserve Object View tabs between Sessions: Opens the Object View tabs again when you start DbVisualizer.
- Keep Associated Object View tabs at Disconnect: Keeps the Object View tabs of a connection open when you disconnect.
- Show Active Tab Title in Bold: Shows the title of the selected tab in bold.
- Position for new Work Area Tabs: Where new Object View and SQL Commander tabs open: first, last, or before or after the selected tab.
- Tab selection when requesting "Open in Tab": Whether Open in Tab reuses a tab that isn't pinned or modified, or opens a new tab, when the object isn't already open. See Database objects.
Password Vault
How saved passwords are protected. See Protecting Saved Passwords.
- Basic Protection: Passwords are stored encrypted, and you don't need to unlock them.
- Master Password: You enter a master password once per session to unlock the passwords.
- Touch ID Protection or Windows Hello Protection: You unlock the passwords using Touch ID or Windows Hello. Only shown on computers that support it.
- Change Master Password: Changes the master password.
- Forgot Master Password: Resets the protection to basic protection, and clears all saved passwords.
Database Connection
What happens with connections when DbVisualizer starts. See Connecting at startup.
- Run "Connect All" at Startup: Connects the connections that are marked for Connect All when DbVisualizer starts.
SSH Configurations
The SSH servers that connections use for SSH tunnels. See Using SSH Tunnels.
- SSH Configurations: Add, edit, copy and remove SSH configurations, and see which connections use each one. See Managing SSH configurations.
Database Profile
Where DbVisualizer looks for database profiles. See How a Database Profile Is Loaded.
- Database Profile Paths: The folders where DbVisualizer looks for database profiles, in the order they are searched.
Metadata
How information about the database objects, such as table names and column types, is cached. See Configuring the metadata cache.
- Metadata Cache: Persistent (default) keeps the cache between sessions, Shared also shares it between DbVisualizer instances that run at the same time, Transient clears it for each session, and Disabled turns it off.
- Stale Content Threshold: After how many days unused metadata is removed from the cache. The default is
60, and0turns it off.
Driver Manager
The Maven repositories that drivers are downloaded from. See Maven repositories.
- Maven Repositories: The repositories, searched from top to bottom. For each repository, you set the URL, and if needed a scope and login credentials.
- Test Maven Connections: Checks that DbVisualizer can reach each repository.
Permissions
Which operations are allowed, denied or must be confirmed, for each permission mode: Development, Test and Production. See Setting SQL Permissions.
- SQL Commander Permissions: For each kind of SQL statement, whether SQL Commander executes it, asks first or doesn't execute it.
- Table Data Editor Permissions: Whether changes in the table data editor must be confirmed. See Confirming changes.
- Procedure Editor Permissions: Whether saving and running code in the code editor must be confirmed.
- Connection Permissions: Whether DbVisualizer asks before it connects automatically, for example when you run SQL. See Confirming Before Connecting.
Files
The defaults for files, which files the Files tab shows, and the file chooser.
- Default File Encoding: The encoding that is selected by default when you choose the encoding of a file.
- Default File Line Break: The line breaks of new scripts. See Choosing the line breaks.
- Recent Paths Limit: How many entries are kept in the lists of recently used files and folders.
- Show All File Extensions: Shows all files in the Files tab. When it is off, the tab only shows files with the extensions in Files Tab Script Extensions, for example
sql,ddl. - Use Native File Chooser: Uses the file chooser of the operating system. Has no effect on Linux. See File chooser dialog.
Data Formats
How dates, numbers, null values, long texts and binary data are shown and edited. See Changing Date and Number Formats.
- Date, Time and Number Formats: The formats of dates, times, timestamps, numbers and decimal numbers, the number separators, and the texts for true and false. The same formats are used when you enter values.
- Display Null Value as: The text shown for null values. The default is
(null). - Edit Null Value as: The text you enter to set a value to null, for example when you edit table data. The default is
(null). - Max Chars for Text Data: The maximum number of characters shown for a text value. See Showing longer text values.
- Presentation of Binary/BLOB and CLOB Data: Whether binary and CLOB values are shown as their size, their value, or for binary values, an image preview, hexadecimal or Base64. See Viewing and editing binary/BLOB and CLOB data.
- Copy/Paste and Drag & Drop of Binary/BLOB and CLOB Data: How binary and CLOB values are copied when you copy and paste or drag and drop them.
Time Zone
The time zone that DbVisualizer uses. Other programs and the database server are not affected.
- Time Zone: The time zone. To choose one from a list, click Select. By default, the time zone of the operating system is used.
Variables
The characters that mark DbVisualizer variables in SQL and in connection fields. See Changing the variable delimiters.
- Variable Identifier Prefix and Suffix: The characters that start and end a variable. The defaults are
${and}$. - Variable Delimiter: The characters that separate the parts of a variable. The default is
||.
Table Data
How the Data tab of tables works. See Viewing Table Data.
- Highlight Primary Key Columns: Shows a key icon in the header of primary key columns. See Column headers.
- Include Variables in SQL: Uses DbVisualizer variables instead of the values in the SQL that is generated from rows. See Generating SQL from rows.
- Max Rows at First Display: Limits how many rows are loaded when the Data tab opens, and whether the filter of the table is used in the first query. Off by default. See Showing more rows in the Data tab.
- Max Filters Limit: How many filters are saved for each table. See Filtering rows.
- Months to keep Unused Filters: After how many months an unused filter is removed.
Transaction
What happens to uncommitted changes when you disconnect. See Uncommitted changes.
- Pending Transactions at Disconnect: Whether to commit or roll back the changes, or to ask, which is the default.
Favorites
What happens when you double-click a favorite in the Favorites tab. See Using Favorites.
- Double-Click Actions for Favorites: What happens when you double-click a favorite, and when you hold down
Altwhile you double-click: open it in a tab, in a new tab or in a floating tab.
Monitor
How monitors start and run. See Running a Monitored Query.
- Show Monitor Window at Startup: Opens the Monitor window when DbVisualizer starts.
- Start Monitors Automatically: Starts the monitors when DbVisualizer starts.
- Monitor Run Style: Sequential (default) runs the monitors one at a time. Parallel is faster, but uses more connections.
Grid
How grids look and work, and the format used when you copy cells.
- Copy Grid Cells in CSV Format: The column and row delimiters used when you copy cells. The defaults are a tab and a line break. See Copy and paste.
- Auto Resize Column Widths: Fits the column widths to the data, and optionally to the column headers. See Column widths and line wrapping.
- Show Grid Row Header: Shows the row numbers to the left of read-only grids.
- Max Column Width: The maximum width of a column, in pixels, when the column widths are fitted automatically. The default,
-1, means no limit. - Automatically Show Grid Warnings: Shows a notification below the grid, for example when Max Rows is reached. See Setting Max Rows and Max Chars.
- Show Column Alias as Grid Column Label: Shows the column aliases of the query in the column headers, instead of the column names.
Grid Viewers
How the value, record and aggregates viewers are shown. See Using the Grid Viewers.
- Grid Viewers Appearance: Side-by-side (default) shows the viewers next to the grid, and Separate Windows shows them in their own windows.
- Use Text Editor Font: Shows text in the value viewer using the text editor font instead of the grid font.
- Right-aligned Numbers: Aligns numbers to the right in the record viewer.
- Image Thumbnail Size (pixels): The size of image thumbnails in the record viewer.
SQL Commander
How SQL Commander works, for example when an execution stops and which errors are marked. See Executing SQL Statements.
- Confirm Close of Unsaved Editors: Asks before you close an SQL Commander tab with unsaved changes. You are always asked for a script loaded from a file. See Saving a script.
- Set "Sticky" for SQL Commanders: Selects Sticky in new SQL Commander tabs, so that the connection, database and schema are kept when you open a script. See Keeping the selection.
- Conditional Stop: Whether a script stops by default when a statement fails, gives a warning, or returns or changes no rows. See Stopping on errors.
- Show Error Position Markers: Whether the position of an error, or the whole failed statement, is marked by default. See Choosing which errors are marked.
- Drop Database Objects in SQL Editor: What happens when you drag an object from the Databases tab to the editor: open the Script Object dialog (default), or insert only the name. See Generating SQL for an object.
- Enable/Disable Stale Files Warning: Shows a warning in the editor when another program changes the file. See When another program changes the file.
- Set Modified State when Scripting: Marks a new SQL Commander tab with generated SQL as modified.
Editor
How the SQL editor works. See Customizing the SQL Editor.
- Change Font Size with Alt+Mouse Wheel: Lets you zoom in an editor by holding down a key while you scroll. Modifier Key sets the key.
- Tab Size: The width of a tab, in characters.
- Expand Tab to Whitespace: Inserts spaces instead of a tab character when you press
Tab. - Show Tab Lines: Shows vertical lines at the tab positions.
- Enable/Disable Caret Blinking: Makes the caret blink.
- Enable/Disable Auto Indent: Indents a new line to the same level as the line before it.
- Enable/Disable Auto Highlight: Highlights all text that matches the selected text. See Highlighting matches.
- Multi-Caret Modifier Key: The key to hold down while you drag the mouse to add carets. See Editing multiple lines at once.
- Enable Vim Mode: Turns on Vim-style editing.
Auto-Completion
When the auto completion list opens, and the case of the inserted names and keywords. See Changing how auto completion works.
- Auto-Completion Popup List: Whether the list opens automatically as you type, and after how long. When it doesn't, press
Ctrl+Spaceto open it. You can also choose whether the columns are sorted by name. - Case for Auto-Completed Keywords: Inserts keywords in uppercase, in lowercase, or as they are written in the list.
- Case for Auto-Completed Names: Inserts names in uppercase, in lowercase, or as they are written in the list.
Comments
The characters that mark comments in SQL. See Setting the comment delimiters.
- Comment Delimiters: Two identifiers for single-line comments, by default
--and//, and the identifiers that begin and end a block comment, by default/*and*/.
Result Sets
How results are shown after an execution in SQL Commander. See Viewing a Result Set.
- Result Sets: Whether to keep the existing result tabs when you execute again, pin new result tabs, show empty results, and make all results read-only. See Keeping results.
- Default Display Mode: Whether new results are shown as a grid (default), as text, as a chart or as a map, or the way the last result was shown.
- Focused Tab after Execution: Which tab is shown after an execution: the Log tab, or the first or last result tab. You can also show the Log tab when there are warnings or empty results. The Log tab is always shown when there are errors.
SQL Log
How the Log tab shows times and long values. See Using the Log Tab.
- SQL Log Time Format: The format of the times in the Log tab. See Changing the time format.
- Width for Multiline Columns: The width, in pixels, of the columns that show long values on several lines. With
-1, the values are shown on one line.
Statement Delimiters
How a script is split into statements. See Statement delimiters.
- SQL Statement Delimiter: The characters that end a statement. The default is
;. - Allow "go" as Delimiter: Also ends a statement with
goalone at the start of a line. - SQL Block Identifiers: The identifiers that begin and end an SQL block, which is executed as one statement. The defaults are
--/and/. See Using an SQL block. - Allow SQL Dialects: Recognizes complex statements, such as
CREATE TRIGGER, by their syntax, so that you don't need block identifiers. See Using an SQL dialect.
Editor Templates
The templates that you insert in the editor by typing a shortcut. See Using Editor Templates.
- Editor Templates: The templates, each with a shortcut, the text it is replaced with, and a description.
- Instant Substitution: Inserts a template at once when only one template matches, instead of showing a list.
SQL Formatting
How SQL is formatted. The settings are saved in formatting profiles. See Formatting SQL.
- Profile: The formatting profile whose settings you see and change. Use the buttons next to it to create, copy, rename and delete profiles. See Formatting profiles.
- Use by Default: Uses the selected profile for all connections that don't have their own profile.
- The formatting settings are grouped in the following categories: General, where you choose the formatting engine, Input, Alignment, Indentation, Line Breaks, Whitespace, Custom Keywords and Transformations, such as the case of keywords. A sample shows how SQL is formatted with the settings. See Formatting settings.
SQL History
Which executions in SQL Commander are saved in the SQL history. See Limiting the history.
- Collect Duplicates in a Single History Entry: When you execute the same script again right after, the last entry is updated instead of a new one being added.
- Ignore Error Entries: Scripts that fail are not saved.
- Ignore SQL (regex): Scripts that match this regular expression are not saved.
Audit Log
Whether DbVisualizer logs the SQL it runs against your databases. An administrator can set them for all users. See Audit Logging.
- Enable Audit Log: Logs every SQL statement that DbVisualizer executes to a file.
- Log Metadata Queries: Also logs the calls that DbVisualizer makes to get information about the database objects.
- Log Connection State Changes: Also logs commits, rollbacks and changes of the current database or schema.
Proxy Settings
The proxy that DbVisualizer uses to reach the internet, for example to check for updates. The proxy isn't used for database connections.
- Proxy Settings: Whether to use no proxy (default), the proxy of the operating system, or a proxy that you set yourself.
- Proxy Type, Proxy Host and Proxy Port: The type, HTTP or SOCKS, the host and the port of a proxy that you set yourself.
- Proxy User and Proxy Password: The login for the proxy, if it requires one.
Server Certificates
The server certificates that you have accepted. See Accepting untrusted certificates.
- The list shows the accepted certificates. Select one to see its details. You can also add a certificate from a file, and remove certificates.
Mail Server Accounts
The mail server accounts that the @mail command uses. See Setting up a mail server account.
- The list shows your mail server accounts. You can add an account for Gmail, Outlook.com or another mail server, send a test email, and copy an account as a
@mailcommand.
AI Assistant
Whether the AI Assistant is turned on, and how it works. See Using the AI Assistant.
- Enable AI Assistant: Turns the AI features on or off. See Turning the AI Assistant on and off.
- Include Context Automatically: Includes the database context with your questions by default. See Including database context.
- Font Scale: The font size in the AI Assistant panel, compared to the application font. See Changing the font size.
- Display on Statement Execution Errors and Display for the Current Statement: Whether the lightbulb with AI actions is shown in the editor when a statement fails, and for the statement at the cursor. See The lightbulb menu.
- Credits Available: Your AI credit balance. Only shown with the built-in AI connection. See AI credits.
AI Connection
How DbVisualizer connects to an AI provider. See Choosing an AI Connection.
- Built-in AI Connection: Uses the AI connection that comes with your DbVisualizer account and AI credits. This is the default.
- Custom AI Connection: Connects to an AI provider of your choice, such as your own OpenAI or Anthropic account, a local model, or your organization's AI service.
- Provider: The providers for a custom AI connection, and the API key of the selected provider. To use a provider, click Set as Current. You can also create, copy, edit and delete your own providers. See Managing your own providers.
- AI Resources: The status of the local model and the user guide index that a custom AI connection uses, with buttons to download them and to check for a newer index. See Downloading AI Resources.
AI Models
Which AI models the AI Assistant uses. See Choosing the AI model.
- With the built-in AI connection, the list shows the models and their relative cost. Select the model to use.
- With a custom AI connection, Current Model is the model to use, and Enabled Models are the models you can choose from in the AI Assistant panel. To load the models from the provider, click Refresh. You can also add models by name.
Permissions
Which statements from the AI Assistant panel can be executed without asking. The SQL Commander permissions of the connection also apply, and the stricter setting is used. See Running generated queries.
- For each kind of statement, such as
SELECT,INSERTandDROP, choose Allow, Ask or Deny.
Notifications
How each type of notification is shown. See Choosing which notifications are shown.
- For each type of notification, set Display to Always, On errors and warnings or Never, and Close to Automatically or Manually.
Telemetry
Whether DbVisualizer sends anonymous usage data and error reports. An administrator can set them for all users. See Telemetry.
- Collect Anonymous Usage Statistics: Sends anonymous information about which features you use.
- Report Application Errors: Sends reports of unexpected errors in DbVisualizer.
Database tab
The Database tab lists the database types. The settings for a database type apply to all connections of that type, and you can override them for a single connection in its Properties tab. See Configuring Connection Properties.
Under each database type, there are the following categories. Some are only available for some database types.
Database type
When you select a database type, such as PostgreSQL, you set the following for all connections of that type.
- Permission Mode: Development (default), Test or Production. The rules for each mode are set in General / Permissions. See Setting SQL Permissions.
- Connect when "Connect All": Connects the connections when you use Connect All. See Connecting several connections at once.
- JDBC Fetch Size: How many rows the driver fetches from the database at a time.
0, the default, uses the default of the driver.
Authentication
Whether DbVisualizer asks for the user name and password, and whether the password is saved. See Saving Credentials.
- Require Userid and Require Password: Asks for the user name or password when you connect, if it isn't saved in the connection.
- Database Password: Whether the password is saved: Save Between Sessions (default), Save During Session or Clear at Disconnect.
Delimited Identifiers
The delimiters of identifiers, such as double quotes, and where DbVisualizer uses them in the SQL it generates. See Choosing Delimiters and Qualifiers.
- Begin Identifier and End Identifier: The characters that enclose a delimited identifier. You can only change them for the Generic database type.
- Use of Delimited Identifiers: The features that write names as delimited identifiers: Scripting, Auto-Completion/Query Builder, Export and Actions.
Qualifiers
Where DbVisualizer qualifies names in the SQL it generates. See Choosing Delimiters and Qualifiers.
- Qualify Objects with Schema/Database: The features that qualify object names with the schema or database.
- Fully Qualify Objects: For databases with both databases and schemas, the features that qualify names with both.
- Qualify Columns: The features that qualify column names with the table name.
Physical Connection
How DbVisualizer uses physical connections to the database server, and how it keeps them alive. See Keeping Connections Alive and Using a Single Physical Connection.
- Use a Single Shared Physical Connection: Uses one physical connection for all features, instead of one for each.
- Show only the Default (Login) Database: Shows only the database you log in to. Only for some database types, such as PostgreSQL.
- Validation and Keep-Alive SQL: The SQL that checks whether a connection is still open.
- Connection Keep-Alive: Checks idle connections at regular intervals, so that they stay open.
- Connection Idle Time: How many seconds a connection must be idle before it is checked.
Transaction
How transactions are handled. See Committing and Rolling Back Changes.
- Auto Commit: Commits each statement right away. On by default.
- Ask when Auto Commit is OFF: When auto commit is off, whether to ask to commit always, or only when there are uncommitted changes.
- Transaction Isolation: The transaction isolation level. See Setting Transaction Isolation.
- Commit Batch Size (rows): How many rows are saved before each commit when you save changes in a grid.
0commits when all rows are saved.
Encoding
The encoding to use when text is saved in a binary column.
- Text to Binary Encoding: The encoding. By default, the encoding of the operating system.
SQL Statements
The SQL that DbVisualizer generates for some operations on this database type, such as selecting, inserting and deleting rows.
- Select a template to see what it is used for, and to edit its SQL. To see the variables you can use, click Variables.
Connection Hooks
SQL to run when DbVisualizer connects to the database and before it disconnects. See Running SQL at Connect and Disconnect.
- Run SQL at Connect and Run SQL at Disconnect: The SQL to run, and whether to run it.
Color and Border
A color and a border that mark the tabs of the connections. See Using tab colors and borders.
- Color and Border: The background color, and the border style or a small image.
- Where the color and the border are shown: in Object View, SQL Commander, result set and monitor tabs, and in the connection name.
SQL Editor
How SQL Commander works with this database type. See Choosing the Connection, Database and Schema.
- Preprocess Script: Prepares scripts before they are executed, for example to handle variables and permissions. See Turning off preprocessing.
- Parameterized SQL: Handles variables and parameter markers. See Using Variables and Parameter Markers.
- Get Parameter Types via JDBC: Asks the driver for the data types of parameter markers. See Getting the types from the driver.
- Strip Comments when Executing: Removes comments from statements before they are sent to the database. See Leaving out comments.
- SQL Formatting Profile: The formatting profile for the connections. If it's empty, the default profile is used. See Formatting profiles.
- Initial Database/Schema Selection: What is selected first in the database and schema lists in SQL Commander. See Choosing what is selected first.
- Set Current Schema: Whether the selected schema is used as the current schema when you execute SQL, or only for auto completion. Only for some database types. See Choosing the schema.
- Show DBMS Output Tab and Enable DBMS Output Automatically: Shows the DBMS Output tab, and turns on DBMS output in new SQL Commander tabs. Only for some database types. See Using the DBMS Output Tab.
- Auto-Completion for Joins: Suggests join conditions when you type a
JOINclause. - Handling loss of Connection: What happens when the connection is lost: don't reconnect, reconnect, or reconnect and execute again (default). See Reconnecting after a lost connection.
Query Builder
How the Query Builder joins tables and lists columns. See Query Builder settings.
- Auto-Join Enabled and Auto-Join Type: Whether tables that you add are joined automatically, by foreign keys or by equal column names. See Joining tables automatically.
- Generate JOIN Clause in Query Builder: Writes joins as
JOINclauses instead of conditions in theWHEREclause. See JOIN clauses or WHERE conditions. - Sort the Columns in the Table Windows: Lists the columns of the tables in alphabetical order.
Data Types
How some data types are handled. This category only exists for some database types, and its settings depend on the database type.
- Handle DATE as TIMESTAMP: Handles the Oracle
DATEdata type asTIMESTAMP. - Handle RAW as STRING: Shows Oracle
RAWvalues as hexadecimal strings. - Convert "FOR BIT DATA" data types to Text: Handles the Db2 and Derby
FOR BIT DATAdata types as text. - Convert "YEAR" data types to Short instead of Date: Handles MySQL and MariaDB
YEARvalues as numbers instead of dates.
Explain Plan
The explain plan tables and how the costliest steps in a plan are colored. This category only exists for some database types. See Analyzing Query Performance (Explain Plan).
- For Oracle and Db2, the schema and name of the tables that the plan is written to, and whether to create them.
- Color Critical Nodes: Colors the steps with the highest cost.
- Critical Threshold and Warning Threshold: The share of the total cost, in percent, at which a step is marked as critical or as a warning.
Objects Tree
What is shown in the Databases tab for Oracle.
- Show Empty Schemas: Shows all schemas, also the empty ones. On by default.
- System Views Prefix: Whether the information is read from the
ALL_(default) or theDBA_system views. TheDBA_views require extra privileges in the database.
Key Split Character
How Redis and Valkey keys are split into a tree.
- Key Split Character: The character that splits key names into a tree. The default is
:.