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 download: https://dbeaver.io/download/

• IoTDB download: https://iotdb.apache.org/Download/

3. Configuration Guide

3.1 Download Driver

Select the appropriate version of the JAR package (choose the jar-with-dependencies.jar variant):

• Option 1: https://repo1.maven.org/maven2/com/timecho/iotdb/iotdb-jdbc/2.0.3.3/iotdb-jdbc-2.0.3.3-jar-with-dependencies.jar

• Option 2: https://repo1.maven.org/maven2/com/timecho/iotdb/iotdb-jdbc/2.0.3.3/

3.2 Configure Driver

Step 1: Open Driver Manager and Create New Driver

1. Navigate to Database → Driver Manager in the toolbar.

2. Click New to create a new driver configuration.

Step 2: Configure Driver Details

1. Under the Libraries tab, click Add File.

2. Select the downloaded IoTDB JDBC driver (e.g., iotdb-jdbc-2.0.3-jar-with-dependencies.jar).

3. Click Find Class to auto-detect the driver class.

4. Configure the following driver settings:

• ​Driver Name​​: IoTDB

• ​Class Name​​: org.apache.iotdb.jdbc.IoTDBDriver

• ​URL Template​​: jdbc:iotdb://{host}:{port}/

• ​Default Port​​: 6667

• ​​Default User​​: root

  

Step 3: Create and Test Connection

1. Click the Create Connection icon.

2. Search for IoTDB, select it, and click Next. Choose the URL connection method.

3. Complete the JDBC URL and enter the IoTDB database password. For tree model, select the Host connection method.

4. Click Test Connection. A successful connection will display Connected with server and driver versions.

4. Usage Guide

1. ​​Database Overview​​

Navigate to the left-side Database Navigator to view database details, including database name, device names, measurement names, and data types.

2. ​​Devices and Measurements​​

Double-click a device in the database list to display its properties. The Columns tab shows detailed measurement information.

3. ​​Data View​​

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

4. ​​Functions and Data Types​​

Under Database Navigator → Procedures, view all supported functions.

The Data Types tab lists all currently supported data types.