TDEngine SQL Client

TDengine is an industrial data platform purpose-built for the IoT (Internet of Things), combining a time series database with essential features like stream processing, data subscription, and caching. QStudio is a free SQL GUI, it allows running SQL scripts, easy browsing of tables, charting and exporting of results. It works on every operating system, with every database including TDEngine.

Setting up a TDengine connection in QStudio

Start TDEngine
Connecting to TDEngine
Querying TDEngine

Start TDEngine

We will use docker to quickly launch an instance of TDEngine:

docker pull tdengine/tdengine:3.0.1.4
docker run -d -p 6030:6030 -p 6041:6041 -p 6043-6049:6043-6049 -p 6043-6049:6043-6049/udp tdengine/tdengine

This will output something similar to the below when it runs successfully.
TDengine Server 3.0 uses TCP port 6030.
Port 6041 is used by taosAdapter for the REST API service.
Ports 6043 through 6049 are used by taosAdapter for other connectors.

john@SERVER-BOX-1 $ docker pull tdengine/tdengine:3.0.1.4

3.0.1.4: Pulling from tdengine/tdengine
Digest: sha256:f67b428e3c97c32ab0c03d8b530106921ac46ac93f8527fb870d0e0a4b75242d
Status: Image is up to date for tdengine/tdengine:3.0.1.4
docker.io/tdengine/tdengine:3.0.1.4

john@SERVER-BOX-1 $ docker run -d -p 6030:6030 -p 6041:6041 -p 6043-6049:6043-6049 -p 6043-6049:6043-6049/udp tdengine/tdengine
08af8bc59cd83b0e54bfdb987528cc96ebccbcf3ba8c24785e3ef4af8a4a4190

john@SERVER-BOX-1 $ docker ps
CONTAINER ID   IMAGE               COMMAND                  CREATED         STATUS         PORTS
                              NAMES
08af8bc59cd8   tdengine/tdengine   "/tini -- /usr/bin/e…"   4 seconds ago   Up 3 seconds   0.0.0.0:6030->6030/tcp, 0.0.0.0:6041->6041/tcp, 0.0.0.0:6043-6049->6043-6049/tcp, 0.0.0.0:6043-6049->6043-6049/udp   charming_burnell

Connecting to a Server

When you first open QStudio it will look like the image below.

Click on the menu options Server->Add Server or on the add server button on the toolbar.
Server Type: TDEngine
Host:localhost
Port: 6041
Username: root
Password: taosdata
Click Add

Either when you add the connection or once you try to run code in the code editor, you will be asked to install the driver automatically:

Sending Queries

Copy paste the below code into the SQL editor. Then highlight the commands you want to run and press Ctrl + e to run that code. See Keyboard Shortcuts.

Command	Shortcut
Run current statement	Ctrl + q
Run highlighted text	Ctrl + e
Run Line	Ctrl + Enter

Run this code line by line otherwise it will FAIL

// DROP DATABASE IF EXISTS db;
CREATE DATABASE db;
use db;
SHOW DATABASES;

CREATE STABLE meters (ts timestamp, current float, voltage int, phase float) TAGS (location binary(64), groupId int);
CREATE TABLE d1001 USING meters TAGS ("California.SanFrancisco", 2);
INSERT INTO d1001 USING meters TAGS ("California.SanFrancisco", 2) VALUES (now, 10.2, 219, 0.32);
SHOW TABLES;

select * from meters;
select * from d1001;

This will update your various results panels, result contains your table (excel export etc. supported), charts are generated based on your data and the console summarizes your recent commands

The Server Tree

The server tree populates but it's not a complete as we would like. We have reported the issue.

server tree showing the variables that exist on TDEngine

Well Done! You have now got QStudio querying your database successfully.

We want to make QStudio the best SQL analysis tool. If you have any problems or want additional features, please post on our github repo.