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 |