デモ

Try out ClickStack, the open-source observability platform powered by ClickHouse.

You can explore it using your own data or dive into a sample dataset that includes a real-world anomaly. It’s a hands-on way to test your monitoring skills and see how ClickStack helps you spot unusual behavior in your systems.

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 RubyGem analytics powered by ClickHouse. The dataset includes every RubyGems download ever recorded — with billions of events and counting. Check how your favorite gem is performing, or explore what’s trending now across the Ruby ecosystem.

The data refreshes daily and includes GitHub activity to add more context for gems linked to repositories. You can also query the underlying tables directly to explore your own insights.

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.

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.

Analyze team activity across various open-source products and compare them with each other. Find out who answers the most GitHub issues and who does the most code reviews. Filter organizations, activities, and people in real time. Examples:

Rust vs. Zig | Polars vs. Datafusion | Superset vs. Metabase | Node vs. Deno | Node vs. Bun | SurrealDB vs ArangoDB | Elasticsearch vs Opensearch | Redis vs. Valkey | Tensorflow vs. PyTorch | QDrant vs. Weaviate | Supabase vs. Neon

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.

Booth challenge

Run live SQL queries on 10B+ GitHub events and explore real-time analytics in action. Track repo trends, analyze developer activity, and see how ClickHouse delivers blazing-fast insights with high-speed ingestion and efficient query execution.

You’ll also learn how to speed up queries with materialized views, making complex analytics even faster.

Try it now - execute queries instantly and sharpen your SQL skills!

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.

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!