Build Observability and Automation Platforms

IMPORT datasqrl.tutorials.sensors.*; -- Import sensor data
IMPORT time.endOfSecond;  -- Import time function
/* Aggregate sensor readings to second */
SecReading := SELECT sensorid, endOfSecond(time) as timeSec,
        avg(temperature) as temp FROM SensorReading
    GROUP BY sensorid, timeSec;
/* Get max temperature in last minute */
SensorMaxTemp := SELECT sensorid, max(temp) as maxTemp
    FROM SecReading
    WHERE timeSec >= now() - INTERVAL 1 MINUTE
    GROUP BY sensorid;

Automate and Observe Quickly

DataSQRL makes it easy to analyse metrics data in real-time with SQL and automate your playbook processes with custom rules or AIOps.

Try this Example

How DataSQRL Works

Implement your data processing in SQL and define your data API in GraphQL.
DataSQRL compiles optimized data pipelines that are robust, scalable, and easy to maintain.

How DataSQRL Works Exactly

Situational Awareness

DataSQRL makes it easy to integrate multiple data streams and apply real-time analytics so you can build dashboards that show the complete picture quickly.

AIOps

Deploy machine learning and large language models for predictive analytics on your metrics or log data streams.

Save Money

DataSQRL builds optimized data pipelines that efficiently store and process metrics data so you can get all the insights at a fraction of the cost.

Why DataSQRL?

DataSQRL turns the deluge of metrics data into your competitive advantage by making it easy to build contextual dashboards that provide situational awareness and automating processes with the help of ML. DataSQRL empowers you to turn metrics into insights by eliminating data plumbing.

Stop Drowning in Metrics Data

Saves You Time

DataSQRL allows you to focus on your data processing by eliminating the data plumbing that strangles your data pipeline implementation with busywork: data mapping, schema management, data modeling, error handling, data serving, API generation, and so on.

Easy to Use

Implement your data processing with the SQL you already know. DataSQRL allows you to focus on the "what" and worry less about the "how". Import your functions when SQL is not enough - DataSQRL makes custom code integration easy.

Fast & Efficient

DataSQRL builds efficient data pipelines that optimize data processing, partitioning, index selection, view materialization, denormalization, and scalability. There actually is some neat technology behind this buzzword bingo.