Pre configured Variables

Table of contents

• Overview
• 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