14-dbeaver.md 2.6 KB
Newer Older
sangshuduo's avatar
sangshuduo 已提交
1 2 3 4 5 6
---
sidebar_label: DBeaver
title: DBeaver
description: You can use DBeaver to access your data stored in TDengine and TDengine Cloud.
---

D
danielclow 已提交
7
[DBeaver](https://dbeaver.io/) is a popular cross-platform database management tool that facilitates data management for developers, database administrators, data analysts, and other users. Starting from version 23.1.1, DBeaver natively supports TDengine and can be used to manage TDengine Cloud as well as TDengine clusters deployed on-premises.
sangshuduo's avatar
sangshuduo 已提交
8 9 10 11 12 13 14 15

## Prerequisites

To use DBeaver to manage TDengine, you need to prepare the following:

- Install DBeaver. DBeaver supports mainstream operating systems including Windows, macOS, and Linux. Please make sure you download and install the correct version (23.1.1+) and platform package. Please refer to the [official DBeaver documentation](https://github.com/dbeaver/dbeaver/wiki/Installation) for detailed installation steps.
- If you use an on-premises TDengine cluster, please make sure that TDengine and taosAdapter are deployed and running properly. For detailed information, please refer to the taosAdapter User Manual.

16
## Use DBeaver to access on-premises TDengine cluster
sangshuduo's avatar
sangshuduo 已提交
17 18 19

1. Start the DBeaver application, click the button or menu item to choose **New Database Connection**, and then select **TDengine** in the **Timeseries** category.

20
 ![Connect TDengine with DBeaver](./dbeaver/dbeaver-connect-tdengine-en.webp)
sangshuduo's avatar
sangshuduo 已提交
21 22 23

2. Configure the TDengine connection by filling in the host address, port number, username, and password. If TDengine is deployed on the local machine, you are only required to fill in the username and password. The default username is root and the default password is taosdata. Click **Test Connection** to check whether the connection is workable. If you do not have the TDengine Java connector installed on the local machine, DBeaver will prompt you to download and install it.

24
 ![Configure the TDengine connection](./dbeaver/dbeaver-config-tdengine-en.webp))
sangshuduo's avatar
sangshuduo 已提交
25 26 27

3. If the connection is successful, it will be displayed as shown in the following figure. If the connection fails, please check whether the TDengine service and taosAdapter are running correctly and whether the host address, port number, username, and password are correct.

28
 ![Connection successful](./dbeaver/dbeaver-connect-tdengine-test-en.webp)
sangshuduo's avatar
sangshuduo 已提交
29 30 31

4. Use DBeaver to select databases and tables and browse your data stored in TDengine.

32
 ![Browse TDengine data with DBeaver](./dbeaver/dbeaver-browse-data-en.webp)
sangshuduo's avatar
sangshuduo 已提交
33 34 35

5. You can also manipulate TDengine data by executing SQL commands.

36
 ![Use SQL commands to manipulate TDengine data in DBeaver](./dbeaver/dbeaver-sql-execution-en.webp)