Local Preferences

Table of contents

• Overview
• Preferences
  • Interface
  • Data viewer
  • SQL Editor
  • Tools
  • Logger
  • Diagram
  • Query Manager

Overview

CloudBeaver provides extensive customization and management capabilities through its Preferences settings, allowing both administrators and regular users to tailor the application according to their needs. To access these settings:

• Administrators: Navigate to Settings -> Administration -> Global Preferences.
• Users:
  • Go to Settings -> Preferences.
  • Alternatively, navigate to Profile -> Preferences

Preferences

Upon accessing the preference page, you will encounter the following settings for customization:

Interface

Setting	Description	Admin only	Variable values
Language	Sets the application's language.	No
	Available languages:
	- English		en
	- Arabic		ar
	- French		fr
	- German		de
	- Italian		it
	- Japanese		jp
	- Korean		ko
	- Portuguese (BR)		pt_BR
	- Romanian		ro
	- Russian		ru
	- Simplified Chinese		zh
	- Spanish		es
	- Traditional Chinese		tw
	- Ukrainian		uk
Theme	Application color theme. Available themes:	No
	- Light		light
	- Dark		dark

Tip: Variables are part of Product settings parameters. For more details, see Product settings parameters.

Data viewer

Setting	Description	Admin only
Disable Import	Disables importing of data in Data Viewer for non-admin users.	Yes
Disable Table presentation	Disables the table view in Data Viewer.	Yes
Disable Copy	Disables copying of data in Data Viewer.	Yes
Disable Export	Disables exporting of data in Data Viewer for non-admin users.	Yes
Disable Edit	Disables editing of data in Data Viewer.	Yes
Default fetch size	Default number of rows to fetch.	No
Maximum fetch size	Maximum number of rows to fetch.	Yes

SQL Editor

Setting	Description	Admin only
Import limit (KB)	Sets the maximum file size that can be imported (in KB).	No
Insert table aliases	Automatically inserts table aliases in the FROM clause of a SQL query. Options:	No
	- Disable: Do not insert any aliases automatically.
	- my_table mt: Use a short alias for tables.
	- my_table AS mt: Use the AS keyword with a short alias for tables.
Use long object names	Always use schema/catalog for object names.	No

Read more about SQL Editor.

Tools

Setting	Description	Admin only
Disable log viewer	Disables the ability to view logs for all users.	Yes
Disable Tools	Removes Tools menu from the top menu bar.	Yes

Logger

Setting	Description	Admin only
Enable detailed logging	Enables detailed logging of GraphQL queries in the server log, including all variables.	Yes

Diagram

Setting	Description	Admin only
Max elements to display	Sets the maximum number of elements (tables, columns, etc.) shown in the ERD viewer.	No

Read more about ERD viewer

Query Manager

Setting	Description	Admin only
Automatic history cleanup	Automatically deletes old query history once a day. If turned off, history is kept forever.	Yes
Days to store history	Number of days to keep query history. Older records are deleted daily.	Yes

Read more about Query Manager.