Skip to content

Pre-configured variables

Overview

DBeaver includes pre-configured variables that facilitate automatic insertion. These variables allow for customization by integrating predefined environment or user-specific information. Variables such as ${host} and ${port} are used to dynamically adjust connection details, whereas ${date} and ${time} can be directly employed in SQL scripts for operations such as logging.

Tip

You can create your own custom variables in the Variables panel to suit your specific needs.

Variables

In the table below, you will find pre-configured variables used in DBeaver for automating and customizing database operations.

Variable Description Example value
${host} Target database host. localhost
${host.tunnel} Tunnel host name. localhost
${port} Target database port. 5432
${database} Target database name. postgres
${user} Database user name. postgres
${url} Connection URL. jdbc:postgresql://localhost:5432/postgres
${connection.type} Connection type. dev
${datasource} Datasource. postgres
${project.path} Project path. /Users/user/Library/DBeaverData/workspace6/General
${project.name} Project name. General
${workspace} Workspace path. /Users/user/Library/DBeaverData/workspace6
${home} OS user home path. /Users/user
${dbeaver_home} Application install path. /Applications/DBeaverUltimate.app/Contents/Eclipse
${application.path} Application install path. /Applications/DBeaverUltimate.app/Contents/Eclipse
${application.name} Application name. DBeaver Ultimate
${application.version} Application version. 24.1.0.202406080852
${local.ip} Local IP address. 192.168.31.154
${date} Current date. 20240614
${time} Current time. 15:30:00
{server} The name of the target server. server1
{folder} The path to a folder on the local file system. /path/to/local/dbfolder
{file} The path to a file on the local file system. /path/to/local/databasefile.jar