# Tinybird

> Managed ClickHouse that publishes SQL queries as APIs

Tinybird is a managed ClickHouse platform that turns a SQL query into a deployed HTTP endpoint, aimed at developers building real-time analytics into applications rather than operating a database.

Website: https://www.tinybird.co

## Use it when

- The deliverable is an API, not a database: a saved SQL query becomes a versioned, parameterized HTTP endpoint with authentication and observability attached.
- A product team wants ClickHouse performance without operating ClickHouse.
- Streaming ingest over HTTP plus the managed connectors covers your sources, and the standing free tier makes evaluation honest.
- ClickHouse knowledge should transfer in, and the option to leave should stay open.

## Think twice when

- You need the full surface of a database: arbitrary tooling, engine settings, and workloads beyond published endpoints.
- Volume is sustained and high; managed convenience prices above running ClickHouse yourself at scale.
- Endpoints throttle with 429s as capacity saturates; sizing is a plan decision rather than a knob you hold.

## How it runs

Fully managed: push events to the Events API or connect a source, define pipes (SQL transformations), and publish endpoints. ClickHouse runs underneath, with materialized views doing insert-time aggregation. The free tier covers 10 GB of storage, 10 million rows a day, and 1,000 API calls a day; paid plans scale on compute. Self-managed is in beta.

## Details

### General

| Attribute | Value |
| --- | --- |
| License | Commercial |
| Deployment | Managed |
| Workload | Interactive, Streaming |
| Operational complexity | Low |
| Pricing | Free, Subscription |
| Documentation | https://www.tinybird.co/docs |

### OLAP Engines

| Attribute | Value |
| --- | --- |
| Specialization | Analytics backend: ClickHouse published as parameterised APIs |
| SQL dialect | ClickHouse SQL with templated query parameters in pipes |
| Joins | ClickHouse joins |
| Updates and deletes | Append-only; delete and replace by SQL condition through the API |
| Ingest to queryable | Seconds: Events API acks on receipt; wait=true confirms commit |
| Storage format | Managed ClickHouse; MergeTree family engine per data source |
| Compute and storage | Fully managed, shared or dedicated infra; self-managed in beta |
| Indexes | ClickHouse sorting key per data source; skipping indexes in datafiles |
| Pre-aggregation | Materialized views run as insert triggers into aggregating engines |
| Concurrent users | Capacity-based: endpoints throttle with 429 as resources saturate |

## Capabilities

- [OLAP Engines](https://matca.io/capabilities/olap-engine)

---

Source: https://matca.io/tinybird
Last updated: 2026-08-31T11:40:47.409Z