DBeaver
DBeaver is a popular cross-platform database management tool that facilitates developers, database administrators, and data analysts in managing data. DBeaver has embedded support for TDengine starting from version 23.1.1. It supports both standalone deployed TDengine clusters and TDengine Cloud.
Prerequisites
Using DBeaver to manage TDengine requires the following preparations.
- Install DBeaver. DBeaver supports mainstream operating systems including Windows, macOS, and Linux. Please make sure to download the correct platform and version (23.1.1+) of the installer. For detailed installation steps, refer to the DBeaver official documentation.
- If using a standalone deployed TDengine cluster, ensure that TDengine is running normally, and that taosAdapter has been installed and is running properly. For specific details, refer to the taosAdapter user manual.
Using DBeaver to Access Internally Deployed TDengine
-
Launch the DBeaver application, click the button or menu item to "Connect to Database", then select TDengine in the time-series category.
-
Configure the TDengine connection by entering the host address, port number, username, and password. If TDengine is deployed on the local machine, you can just enter the username and password, with the default username being root and the default password being taosdata. Click "Test Connection" to test if the connection is available. If the TDengine Java connector is not installed on the local machine, DBeaver will prompt to download and install it.
-
A successful connection will be displayed as shown below. If the connection fails, check whether the TDengine service and taosAdapter are running correctly, and whether the host address, port number, username, and password are correct.
-
Using DBeaver to select databases and tables allows you to browse data from the TDengine service.
-
You can also operate on TDengine data by executing SQL commands.