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