DBeaver
DBeaver supports connecting to Databend using a built-in driver categorized under Analytical, available starting from version 24.3.1.
Prerequisites
- DBeaver 24.3.1 or later version installed
- For self-hosted Databend: Docker installed (if using Docker deployment)
User Authentication
If you are connecting to a self-hosted Databend instance, you can use the admin users specified in the databend-query.toml configuration file, or you can connect using an SQL user created with the CREATE USER command.
For connections to Databend Cloud, you can use the default cloudapp
user or an SQL user created with the CREATE USER command. Please note that the user account you use to log in to the Databend Cloud console cannot be used for connecting to Databend Cloud.
Connecting to Self-Hosted Databend
Start Databend (Docker)
Run the following command to launch a Databend instance:
If no custom values for QUERY_DEFAULT_USER
or QUERY_DEFAULT_PASSWORD
are specified when starting the container, a default root
user will be created with no password.
docker run -d --name databend \
-p 3307:3307 -p 8000:8000 -p 8124:8124 -p 8900:8900 \
datafuselabs/databend:nightly
Configure Connection
- In DBeaver, go to Database > New Database Connection to open the connection wizard, then select Databend under the Analytical category.
- Enter
root
for the Username (or your configured username).
- Click Test Connection to verify the connection. If this is your first time connecting to Databend, you will be prompted to download the driver. Click Download to proceed.
Once the download is complete, the test connection should succeed:
Connecting to Databend Cloud
Obtain Connection Information
Log in to Databend Cloud to obtain connection information. For more information, see Connecting to a Warehouse.
If your user
or password
contains special characters, you need to provide them separately in the corresponding fields (e.g., the Username
and Password
fields in DBeaver). In this case, Databend will handle the necessary encoding for you. However, if you're providing the credentials together (e.g., as user:password
), you must ensure that the entire string is properly encoded before use.
Configure Connection
- In DBeaver, go to Database > New Database Connection to open the connection wizard, then select Databend under the Analytical category.
- In the Main tab, enter the Host, Port, Username, and Password based on the connection information obtained in the previous step.
- In the Driver properties tab, enter the Warehouse name based on the connection information obtained in the previous step.
- In the SSL tab, select the Use SSL checkbox.
- Click Test Connection to verify the connection. If this is your first time connecting to Databend, you will be prompted to download the driver. Click Download to proceed. Once the download is complete, the test connection should succeed: