What is Airfold?

Airfold is the analytics platform built for engineers.

All under one roof, Airfold lets you ingest data in real time, transform it using SQL, and serve results through low-latency REST APIs. Whether you’re powering real-time metrics, embedding live dashboards in your app, or running fast, concurrent queries over terabytes of data—Airfold provides a high-performance, cost-efficient platform built to scale.

Unlike traditional data stacks that require stitching together multiple tools, Airfold offers an end-to-end system that excels at:

Real-Time Data Ingestion: Stream and process thousands of events per second with minimal latency and no batching complexity.

Lightning-Fast Queries: Use SQL to transform and aggregate huge datasets at exceptional, often sub-second latency.

Seamless API Integration: Instantly expose your query results as REST APIs for your app to consume.

Under the hood, Airfold is built on top of ClickHouse, the fastest open-source analytical database available. This lets your APIs query billions of rows with sub-second latency, no caching layers, and no pre-aggregation required. Just raw performance.

Airfold serves as your analytics backend—simplifying your data stack and giving your systems fast, direct access to the insights they need, when they need them.

How does Airfold work?

Taking your project from raw data to published APIs is a simple, three-step process:

Sources

Sync your data into Airfold by using one of the built-in connectors, or send your data directly by using the Airfold API.

Pipes

Transform and aggregate your data using Pipes by writing SQL select statements. Think dbt, but in real-time.

APIs

Instantly expose your pipeline results as low-latency API endpoints, ready to use in your front end.

UI or CLI? Your choice.

You can build and manage everything in Airfold using either our intuitive UI or our developer-friendly CLI. These docs will guide you through both approaches—whether you prefer point-and-click or pipelines-as-code, you’ll find everything you need to ship real-time analytics with confidence.

First Steps

Sign up for our free tier (no credit card required) and get started in minutes:

Quickstart (UI)

Using our user-friendly interface

Quickstart (CLI)

Using a few CLI commands

Explore

Workspaces

Organize and collaborate on your projects

Sources

Bring your data into Airfold

AI Tables

Transform unstructured data into structured data

Pipes

Build features over your data