ClickPy – OSS project and service for Python analytics using ClickHouse

In plain words

ClickPy is an open-source analytics tool for Python package downloads built on ClickHouse. It provides fast, free querying of Python module download data sourced from BigQuery's 700-billion-row dataset. Designed for developers and package maintainers who need detailed analytics without speed limitations or query costs, ClickPy addresses performance and affordability gaps in existing analytics solutions. The project is available under Apache 2 license.

written from the facts on this page · September 2026

From the sources

Free analytics service for Python package downloads, powered by ClickHouse

Browse through 1,049,760 Python packages from PyPI and over 3.43 trillion downloads, updatedfrom clickpy.clickhouse.com

In the maker’s words, at launch

Thought i'd share some recent work i'd done after being generally frustrated as to the available analytics for Python modules. Most seem to be either limited in time or incur charges to query. Code is Apache 2 at https://github.com/clickHouse/clickpy The downloads for Python modules are actually…

• 
  ClickHouse-local – a small tool for serverless data analytics2023 · clickhouse.com · ▲289

  Me with my friend Vitaly Ludvichenko made an experiment to combine ClickHouse server and client to make a self-contained program running a database engine and processing data without a server: https://github.com/ClickHouse/ClickHouse/pull/150 Development continued in the past 6 years, and now clickhouse-local becomes a swiss-army knife for data processing. Say "ffmpeg" for datasets and more. It can resemble textql, octosql, dsq, duckdb, trdsql, q, datafusion-cli, spyql, but has better capabilities and performance. Here is a tutorial:…

• 1R
  1M rows/s from Postgres to Python2016 · magic.io · ▲296
• 
  How to analyse 100 GB of data on your laptop with Python2019 · towardsdatascience.com · ▲264

  Your home for data science and AI. The world's leading publication for data science, data analytics, data engineering, machine learning, and artificial intelligence professionals.

• 
  chdb2023 · clickhouse.com · ▲88

  Embedded SQL OLAP engine powered by ClickHouse

• 
  ClickHouse2016 · clickhouse.com · ▲12

  ClickHouse is a free analytic DBMS for big data.

• 
  GraphJSON – Easily log and analyze events using ClickHouse2022 · graphjson.com · ▲128

  Hi HN, My name is JR and I had a need for a simple analytics solution that allowed me to store (timestamp, json) logs and run SQL over them. It was hard to find the right solution. Solutions like Mixpanel and Amplitude optimized for particular report types. Whereas solutions like Snowflake, BigQuery, etc. required a lot of setup. I built GraphJSON to fit in the middle. I strived for the ease of use of tools like Mixpanel and Amplitude, but wanted to ensure affordances were built to support use cases that big data warehouses enable. Under the hood, GraphJSON is powered by ClickHouse. This…

• 
  /dev/null▲482

  a social network for devs

  Dev tools · 2d ago · dev-null.sh

• 
  Whiteboard (YC W26) – an open-source IDE for thoughtful software design▲423

  open-source IDE for thoughtful software design. Contribute to devdotfast/whiteboard development by creating an account on GitHub.

  Dev tools · 27d ago · github.com

• 
  Reladraw – A diagram language where you decide where to place things▲411

  Contribute to reladraw/reladraw development by creating an account on GitHub.

  Dev tools · 25d ago · github.com

• 
  OpenBot▲362

  Grok Bot alternative: free, local, open-source, multiplayer

  Dev tools · 22d ago · openbot.run

• 
  Talanoa▲343

  Hi HN, I’m a fullstack developer, and honestly, I’ve lost count of how many side projects I’ve worked on over the years. But one idea kept coming back to me: a different kind of email client. It first came to me in 2014: “What if we could handle emails more like conversations?” Every year, I’d revisit this concept in my “Build Notes.” Ten years later, no one had built exactly what I had in mind — so I finally decided to do it myself. That’s how Talanoa was born. I wanted something focused on people, not timelines. I was tired of marking messages as unread just to remember to reply later, or…

  Dev tools · 20d ago · talanoa.email

• 
  CoreSpeed▲332

  One MCP for everything your agents need: apps, memory, tools

  Dev tools · 28d ago · corespeed.io

• 
  Flowla▲1,119

  Digital sales rooms that wow buyers

  Growth · 2023 · flowla.com

• 
  Passionfroot Discovery▲962

  Discover & book top creators to promote your product

  Growth · 2023 · passionfroot.me

• 
  Re:catch▲939

  If Google Form & Calendly had a baby

  Growth · 2023 · recatch.cc

• 
  Pitch 2.0▲886

  Create, share and analyze presentations faster than ever

  Work · 2023 · pitch.com

• 
  LeadDelta 3.0▲883

  CRM built for modern teams & creators powered by AI

  AI · 2023 · leaddelta.com

• 
  SpeedVitals▲829

  Hi HN, I’m Kashish, one of the co-founders of SpeedVitals, a platform for testing & monitoring website performance with a major emphasis on Core Web Vitals. Until now, our platform has only focused on Synthetic/Lab testing, such as Lighthouse tests and TTFB tests. But now, we have developed a Real-User Monitoring platform that doubles up as a Web Analytics tool. One major feature we have that most RUM tools lack is Performance Audits. Just like Lighthouse audits work on Lab test data, our audits work across all the real-user visits and gives suggestions on what task to prioritize first.…

  Dev tools · 2023 · speedvitals.com