The Way to Build Realtime Data Products

Tinybird helps data teams deliver realtime answers at scale through analytical API endpoints built in minutes, not weeks.

Trusted by companies like...

The Hotels Network
The Hotels Network
Feedback Loop
Stay
Plytix
Audiense
Situm
Genially
The Hotels NetworkThe Hotels Network
Feedback Loop
Stay
Plytix
Audiense
Situm
Genially

1

Ingest

Easily ingest data

Ingest millions of rows per second from your Data Streams, Data Warehouses or using CSV files.

$ tb connection create kafka --bootstrap-server pkc-europe-west2.gcp.confluent.cloud:9092 --username CK2H --password O7DaVz93NbuNlRYT
** Connection 992207d5-430d created successfully!
$ tb datasource connect 992207d5-430d kafka_events --topic a --group b --auto-offset-reset latest
** Datasource 'kafka_events' created
** Kafka streaming connection configured successfully!
Icon Apache Kafka

kafka_events

21.3B rows / 4.1Gb

Chart Illustration

Works with Relational Databases, Data Warehouses and Data Streams.

2

Transform

Transform using SQL

Query and shape your data using Pipes, a new way to chain SQL queries inspired by Python Notebooks. Designed to reduce complexity without sacrificing performance.

Simplify complex queries

By splitting your query in different nodes you simplify development and maintenance.

top_products

SELECT product_id, count() AS sales FROM events
WHERE event = 'buy'
GROUP BY product_id
ORDER BY sales DESC

Enrich your data and add custom logic

Use JOINs to enrich your data. Enable parameterised API endpoints using a simple templating language.

top_products_endpoint

SELECT title, sales, sales*price as revenues
FROM o top_products
JOIN o products using product_id
ORDER BY {{column(order_by, 'sales')}} DESC
LIMIT {{Int8(limit, 10, required=True)}}

Your API endpoint has been enabled!

Activate your production-ready API endpoints with one click. Transformations occur on-the-fly so you will always work with the latest data.

3

Build

Publish scalable API endpoints

Share access securely to your data in one click and get fast and consistent results.
Apart from providing monitoring tools, Tinybird scales linearly: don't worry about traffic spikes.

Publish scalable API endpoints

Ingest your data with ease

Ingest millions of rows per second with our Data connectors or with just CSV files. Transform or augment while you ingest if needed

curl -H "Authorization: Bearer <auth_token>" \
-X POST "https://api.tinybird.co/v0/datasources?url=https://s3.amazonaws.com/nyc-tlc/trip+data/fhv_tripdata_2018-12.csv"

21.3B rows ingested in 122s.
curl -H "Authorization: Bearer <auth_token>" \
-X POST "https://api.tinybird.co/v0/datasources?url=https://s3.amazonaws.com/nyc-tlc/trip+data/fhv_tripdata_2018-12.csv"

21.3B rows ingested in 122s.
curl -H "Authorization: Bearer <auth_token>" \
-X POST "https://api.tinybird.co/v0/datasources?url=https://s3.amazonaws.com/nyc-tlc/trip+data/fhv_tripdata_2018-12.csv"

21.3B rows ingested in 122s.
curl -H "Authorization: Bearer <auth_token>" \
-X POST "https://api.tinybird.co/v0/datasources?url=https://s3.amazonaws.com/nyc-tlc/trip+data/fhv_tripdata_2018-12.csv"

21.3B rows ingested in 122s.

Transform using SQL

Query your data using Pipes, a new way for chaining SQL queries inspired by Python Notebooks, designed to reduce most of the hassle without sacrificing performance

Build scalable API endpoints

Share access securely to your data in a click and get fast and consistent results

Ingest

Transform

Build

Ingest your data with ease

Ingest millions of rows per second with our Data connectors or with just CSV files. Transform or augment while you ingest if needed

Works with Relational Databases, Data Warehouses and Data Streams.

Transform using SQL

Query your data using Pipes, a new way for chaining SQL queries inspired by Python Notebooks, designed to reduce most of the hassle without sacrificing performance

fhv_tripdata_clean

SELECT * FROM fhv_tripdata
WHERE
 toDate(date) > ‘01-01-2000’
 AND n_passengers < 8

Simplify complex queries

By splitting your query in different nodes you simplify creation and maintenance.

fhv_tripdata_clean

SELECT
 count(trip_id), sum(total_price), sum(total_miles)
FROM fhv_tripdata_clean
WHERE
 toDate(date) >= {{Date(‘start_date’)}}
 AND toDate(date) <= {{Date(‘end_date’)}}

Add custom logic

Enable parameterised API endpoints using a simple templating language.

Your API endpoint has been enabled!

Your API endpoint has been enabled!

Transformations occur on-they-fly so you will always work with the latest data

Build scalable API endpoints

Share access securely to your data in a click and get fast and consistent results

curl -H "Authorization: Bearer <auth_token>" \ -X GET...

113,982

Req. in the last 24h

107ms

Avg. Req. time

0.2%

Error rate

"We decided to go with Tinybird rather than continuing to invest on our internal Clickhouse cluster. Tinybird's tools, scalability and support have helped us accelerate and improve our analytics dashboards for our customers."

Jordi Miró

CTO at The Hotels Network

"After testing with Postgres, Cassandra, Redshift, etc. we finally went with Tinybird. Technical support is incredible and our query latency has improved a lot. We are no longer worried about how many rows we have."

Pedro Liévana

Lead Engineer at Plytix

"Analytics at STAY are at another level now, all thanks to Tinybird's platform and the amazing technical support from their team during the migration and implementation process."

Joan Lladó

CEO of STAY

"With Tinybird we were able to deploy an alerts system over Kafka data without having to deploy a single line of code or worry about scale.
And any new use case is just a SQL query away."

Ignasi Vegas

Data Engineer at Feedback Loop

"Tinybird takes out the hassle of dealing with data access performance and DB scaling. Now we can focus on what really matters: providing the best tool possible to our clients."

Álex López

Co-founder and CTO

API Endpoints

For developers by developers

Imagine if you could turn, in a matter of minutes, any Data Stream or CSV file into a fully secured realtime analytics API endpoint.

Connect your data, write your SQL and expose results via API endpoints.

Connect Data Streams, Data Warehouses or CSVs. Explore publishing APIs and build
Zero hassle Real-time Analytics

In the docs

Getting started with Tinybird

Learn how to build a quick and easy API endpoint using open data. It will not take you more than 10 minutes.

FAQ