Lower storage costs
Object storage and compression make it economical to retain the data your devices and infrastructure generate.
EMQX Tables
Managed time-series
database for MQTT data
Understand device behavior and trends over time. Query IoT telemetry with SQL or PromQL, fully managed in EMQX Cloud.
Average temperature by device · Last 24 hours
SELECT device_id,
ROUND(AVG(temperature), 1) AS avg_temp
FROM sensor_metrics
WHERE ts >= now() - INTERVAL '24 hours'
GROUP BY device_id;| device_id | avg_temp (°C) |
|---|---|
| sensor-01 | 24.6 |
| sensor-02 | 26.1 |
| sensor-03 | 23.8 |
Average GPU utilization by rack · Last 24 hours
SELECT rack_id,
ROUND(AVG(gpu_utilization), 1) AS avg_gpu_pct
FROM gpu_metrics
WHERE ts >= now() - INTERVAL '24 hours'
GROUP BY rack_id;| rack_id | avg_gpu_pct |
|---|---|
| rack-01 | 82.4 |
| rack-02 | 67.8 |
| rack-03 | 91.2 |
Why EMQX Tables
Make sense of your telemetry
Bring MQTT data, historical context, and SQL or PromQL queries together in one managed service.
Built into EMQX Cloud
Send data from EMQX Broker through built-in integration. Manage messaging and storage in one console.
Database operations, handled
EMQ manages the infrastructure, backups, and maintenance. Choose Pro when your workload needs high availability.
Capabilities
Query the history behind your MQTT data
MQTT data ingestion
Select topics, extract fields, and write data from EMQX Broker with rules and a built-in connector.
Efficient storage
Retain telemetry for historical analysis on object storage. Compression reduces the space needed for long-term retention.
SQL and PromQL
Compare readings and track trends with SQL filters and aggregations. Query metrics with PromQL and visualize them in Grafana.
Retention controls
Set retention periods for databases and tables. Keep the history you need and expire older data automatically.
Familiar interfaces
Write through HTTP and InfluxDB Line Protocol. Explore data in the console or connect your existing tools.
Production controls
Set database and table permissions. Use private connectivity where supported and Pro for high availability.
Benefits
Put your history to work
Investigate incidents
Look back at the readings before and after an event to understand what changed.
Compare performance
Track equipment, energy use, and infrastructure utilization across weeks, months, and seasons.
Build better data features
Give customers historical views, usage reports, and device trends in your applications.
Use cases
From connected devices to data centers
Understand device behavior, compare performance, and investigate changes with historical telemetry.
See compute, power, and cooling together.
Compare GPU utilization with power and cooling metrics by rack and time. Keep the history needed to investigate incidents and plan capacity.
Discuss your workload
Understand equipment performance
Compare temperature, vibration, and pressure readings to understand equipment behavior across production lines and operating cycles.
Compare energy performance across sites
Analyze generation, consumption, and performance across sites with historical meter, inverter, and battery data.
Understand how customers use your devices
Analyze device status, usage, and vehicle telemetry over time. Build historical views for customers and troubleshooting tools for support.
Plans & Pricing
Plans for your workload
Choose Starter for evaluation, Pro for high availability, or Enterprise on your infrastructure.
Customer story
How TVU Networks uses EMQX Tables
Media & broadcasting
Operational metrics for a global media platform.
TVU stores MediaHub's metrics and service health data in EMQX Tables. Its monitoring tools use InfluxDB Line Protocol, while EMQX Broker handles messaging.
Read customer story
FAQ
Frequently asked questions
EMQX Tables is the fully managed time-series database in EMQX Cloud, powered by GreptimeDB. It stores and queries device telemetry and operational metrics. Enterprise is available for private deployments.
EMQX Tables combines object storage with data compression to reduce storage costs. Usage is measured after compression, with a storage allowance included in each plan. Beyond that allowance, additional compressed storage costs $0.04 per GB-month. Deployment and egress charges also apply.
You set the retention period for a database or table. Retained data remains queryable with SQL. Choose a policy that fits your history requirements and storage budget.
You can write data directly through the HTTP API using SQL or InfluxDB Line Protocol. For MQTT data, EMQX Broker provides built-in integration with rules to select and transform messages before storage.
Yes. Store infrastructure metrics such as GPU utilization, power, and temperature. Query them with SQL or PromQL and visualize them in tools such as Grafana. Configure your collection pipeline to write through a supported interface. See the HTTP API guide.
Starter uses a managed single node with SQL and PromQL queries, object storage and compression, and built-in EMQX Broker integration. Pro adds primary–standby high availability across availability zones, a 99.9% uptime SLA, 24×7 support, and production connectivity controls. Enterprise supports private cluster deployments on your infrastructure, with custom sizing and deployment. Contact us to discuss sizing or a move between plans.
Starter supports selected regions on AWS, Azure, and Google Cloud. Pro is currently available on AWS in Ohio and Google Cloud in Iowa. Private connectivity depends on your plan and network setup. Check the current region list.
Query your MQTT history with EMQX Tables
Start exploring your device data, or talk to our team about your workload.