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 |