DBeaver

1. Feature Overview

DBeaver is an open-source universal database management tool that supports core functionalities including data query and visualization, metadata management, data import/export, and driver extensions. It provides a cross-platform graphical interface for various databases (e.g., MySQL, PostgreSQL, Oracle).

2. Prerequisites

Ensure DBeaver and IoTDB are installed:

• DBeaver(>= V25.2.0), download: https://dbeaver.io/download/

• IoTDB is running, download: https://iotdb.apache.org/Download/

3. Create Connection

1. Click ​​DBeaver > Database > New Database Connection​​, or directly click the icon in the upper-left corner.

2. Select the ​​IoTDB driver​​ (you can find it under the ​​All​​ or ​​Timeseries​​ category).

3. Complete the connection settings, and choose the appropriate sql dialect based on whether the target IoTDB uses a ​​Tree Model​​ or ​​Table Model​​.

4. Test the connection (make sure to select the driver file compatible with your version). If the connection is successful, a prompt will appear showing "Connected," along with the server version and driver version.

4. Usage Guide

1. ​​Database Overview​​

In the left-side ​​Database Navigator​​, you can view database-related information, including: database name, table names, column names, column data types, column comments.

2. Table Structure

Double-click a table in the database list to display its structure in the ​​Properties​​ tab on the right panel, including: basic table attributes and detailed column information.

The ​​Primary Keys​​ section shows the table's composite primary keys (time + tag columns).

3. ​Data View​​

Switch to the Data tab to explore all stored data for the selected table.

4. ​Functions and Data Types​​

Under Database Navigator → Procedures, view all supported functions.

The Data Types tab lists all currently supported data types.