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).
Ensure DBeaver and IoTDB are installed:
-
DBeaver(>= V25.2.0), download: https://dbeaver.io/download/
-
IoTDB is running, download: https://iotdb.apache.org/Download/
- Click DBeaver > Database > New Database Connection, or directly click the icon in the upper-left corner.
- Select the IoTDB driver (you can find it under the All or Timeseries category).
- Complete the connection settings, and choose the appropriate sql dialect based on whether the target IoTDB uses a Tree Model or Table Model.
- 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.
- 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.
- 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).
- Data View
Switch to the Data tab to explore all stored data for the selected table.
- Functions and Data Types
Under Database Navigator → Procedures, view all supported functions.
The Data Types tab lists all currently supported data types.
