Workbench

1. Product Introduction

Workbench is Timecho's official visualization console for TimechoDB. It provides a graphical interface for managing database instances, metadata, time-series data, queries, analysis, permissions, and runtime status.

In the tree model, Workbench organizes data by database, device, and measurement paths. This hierarchy connects measurements with their devices and provides access to data queries, trends, views, and data synchronization.

2. Features

2.1 Sign In

Select a configured instance, enter a username and password, and choose Tree Model or Table Model as the entry point. The sign-in page supports language switching and can require a verification code when that option is enabled. The instance selector provides an edit entry for maintaining connection details.

2.2 Instance Management

Manage multiple TimechoDB instances from one place. Create, edit, delete, and test connections for standalone, cluster, and dual-active deployments. The instance list and relationship graph help organize deployments and switch the active instance.

Instance settings include the default data model, SSL, and an optional Prometheus endpoint. Database and monitoring connection tests are reported separately.

The instance topology graph displays relationships between instances. Drag nodes, add connections and text, and adjust the layout to organize deployments. Select an instance to review or edit its connection details or switch the active instance.

2.3 Home

The Home page summarizes activation, server clock, database, device, and measurement counts. Its node list shows ConfigNode, DataNode, and AINode status, version, and address. With a monitoring service configured, the page also displays CPU, memory, disk, write, and file metrics by node.

2.4 Measurement Management

Browse databases, devices, and time series in a hierarchy. Database details include retention time and device counts; measurement details include names, data types, encodings, and compression. Create, export, and delete measurements individually or in batches. The data-model view helps explain how paths map to devices and measurements.

2.5 Data Query

Select one or more measurements and filter results by time, device, sampling interval, or aggregation strategy. Results display timestamps alongside measurement values. Statistical queries include common calculations such as maximum, minimum, average, and sum. Results can be refreshed, imported, or exported.

2.6 SQL Operations

Enter and execute one or more SQL statements in the editor. Reset, save, and editing actions are available alongside execution controls. Results appear below the editor and can be exported, making it easier to validate queries and review returned data.

2.7 AI Analysis

AI analysis provides time-series forecasting and anomaly detection for selected measurements. Compare historical data with model predictions, review detected anomalies in charts and tables, and export results. Forecast results can be written back to a new measurement. Model management supports search, import, fine-tuning, and batch deletion.

2.8 Visualization

Real-time trends continuously display current measurement values. Historical trends show data over a selected time range and use an overview chart to adjust the visible window. Group measurements into curves, inspect values with the cursor, calculate time and value differences, save common selections as templates, and export charts as PNG files. Analysis tools such as FFT display frequency-domain characteristics.

2.9 Views

Review view names, descriptions, result measurements, and expressions. Create, edit, delete, import, and export views through the interface. View definitions organize source measurements and expressions into reusable data access logic.

2.10 Data Synchronization

Create and manage synchronization tasks between databases. The task list shows synchronized data, scope, target address, running status, and creation time. Start, stop, delete, and monitor tasks from the interface.

2.11 System Management

Manage users, roles, global permissions, and data permissions. Audit logs record data-definition, data-write, and query operations to support change review and troubleshooting. Database configuration provides an interface for reviewing and managing instance settings.

3. Usage

For deployment instructions, see Workbench Deployment. Contact the Timecho team for the detailed operation manual.