Lower storage costs
Object storage and compression make it economical to retain the data your devices and infrastructure generate.
EMQX Tables
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
Bring MQTT data, historical context, and SQL or PromQL queries together in one managed service.
Object storage and compression make it economical to retain the data your devices and infrastructure generate.
Send data from EMQX Broker through built-in integration. Manage messaging and storage in one console.
EMQ manages the infrastructure, backups, and maintenance. Choose Pro when your workload needs high availability.
Capabilities
Select topics, extract fields, and write data from EMQX Broker with rules and a built-in connector.
Retain telemetry for historical analysis on object storage. Compression reduces the space needed for long-term retention.
Compare readings and track trends with SQL filters and aggregations. Query metrics with PromQL and visualize them in Grafana.
Set retention periods for databases and tables. Keep the history you need and expire older data automatically.
Write through HTTP and InfluxDB Line Protocol. Explore data in the console or connect your existing tools.
Set database and table permissions. Use private connectivity where supported and Pro for high availability.
Benefits
Look back at the readings before and after an event to understand what changed.
Track equipment, energy use, and infrastructure utilization across weeks, months, and seasons.
Give customers historical views, usage reports, and device trends in your applications.
Use cases
Understand device behavior, compare performance, and investigate changes with historical telemetry.
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
Compare temperature, vibration, and pressure readings to understand equipment behavior across production lines and operating cycles.

Analyze generation, consumption, and performance across sites with historical meter, inverter, and battery data.

Analyze device status, usage, and vehicle telemetry over time. Build historical views for customers and troubleshooting tools for support.

Plans & Pricing
Choose Starter for evaluation, Pro for high availability, or Enterprise on your infrastructure.
Customer story
Media & broadcasting
TVU uses EMQX Tables to store MediaHub's operational metrics and service health data. InfluxDB Line Protocol connects its existing monitoring tools, while EMQX Broker handles service messaging.
Read Customer Story
FAQ
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.