Our Demo Applications

Open-source demos showcasing the speed and scalability of ClickHouse

adsb.exposed

adsb.exposed

With over 50 billion air traffic control records (or Automatic Dependent Surveillance-Broadcast Data), we visualize the flight paths of current aircraft. With this demo, you can see helicopter rides over the world's great cities, F16 training exercises, detours around volcanoes, balloons over the Alps, UFOs in Area 51, your favorite airport, and Elon Musk's globe-trotting. All through the most beautiful visuals.

The data is hosted in a ClickHouse database and queried on the fly, rendering directly in the browser with a single HTML file without web frameworks. You can tune the visualizations with custom SQL queries and, if nothing else, enjoy a new art form.

ClickPy

ClickPy

Explore free Python package analytics powered by ClickHouse. Almost 1 trillion rows of data and counting, which includes every download of a Python package via PyPI. Ever. See how your favorite Python package (ours is chDB) is performing, or just find out what's currently hot in the Python ecosystem.

This dataset is updated daily and includes GitHub events data to provide further statistics for those Python projects with a GitHub repository. Users are free to query the underlying tables and derive their own insights.

Pastila

Pastila

What better way to share a ClickHouse SQL query than a service powered by ClickHouse? Pastila is a free Pastebin service powered by ClickHouse. Paste it into your code snippet and share the URL. Links never expire thanks to ClickHouse's ability to store billions of messages efficiently. Read more about how this service was built here.

Reverse DNS Space

Reverse DNS Space

Ever wanted to visualize the entire internet? Well, now you can thanks to ClickHouse. This visual rendering of the DNS space allows you to see which blocks of the IP addresses are owned by which domains. Look hard enough and maybe you can find your own!

GitHub Archive

GitHub Archive

Everything you always wanted to know about GitHub (but were afraid to ask).

We prepared a dataset from the GH Archive that contains all the events in all GitHub repositories since 2011 in a structured format. The 7.5B row dataset was uploaded into ClickHouse, where it is updated hourly. We redistribute it for research purposes and provide some sample queries. Alternatively, users can download and process the data themselves.

This dataset can help answer almost any question about GitHub that you can imagine. Top repositories by stars? How has the list of top repositories changed over the years? Repositories with the highest growth YoY? Repositories with the maximum amount of pull requests?

Or maybe just find a friend through commonly-starred repos!

Build your own

Build your own

Struggling to find what you need or eager to create something unique? Explore our diverse sample datasets, including GitHub Events, Property Prices, YouTube Metrics, New York Taxis, and Weather Data. Start building your own application today!

Follow us
Twitter imageSlack imageGitHub image
Telegram imageMeetup imageRss image