Our demo applications

Explore our SQL playground, offering free access to over 35 diverse datasets—including Stack Overflow and Reddit posts, NOAA weather measurements, forex trades, YouTube statistics and GitHub events—supported by 220+ example queries. Perfect for both beginners and data enthusiasts, the playground lets users run custom SQL queries, visualize the results with charts, and uncover insights from real-world data. Share your findings with link sharing, and save your own queries to revisit or refine anytime. Updated regularly, this playground is a free tool for experimenting with and learning ClickHouse SQL on open data.

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.

CryptoHouse is a free blockchain analytics service powered by ClickHouse with the aim of democratizing blockchain analytics. Users can use SQL to query blockchain data, such as Solana and Ethereum, which is updated in real-time, thanks to Goldsky. Save and share queries or chart metrics, with examples provided, to get users started. We welcome external contributions to the example queries and materialized views.

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.

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.

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!

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!

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!