All 161 Dependencies

Every package ClickHouse depends on, ranked by repo health score.

ClickHouse is an open-source, column-oriented database management system purpose-built for real-time online analytical processing (OLAP). It stores data by columns rather than rows, enabling extreme compression ratios and the ability to scan only the columns needed for each query — a fundamental design decision that allows it to execute complex aggregations over billions of rows in milliseconds rather than minutes.

The system is deployed by engineering teams at companies including Tesla, Lyft, Cloudflare, and Anthropic who need analytical query performance that traditional data warehouses cannot match. ClickHouse runs on a single laptop via a standalone binary or scales horizontally to petabyte-scale distributed clusters, making it equally useful for local file analysis and production observability pipelines handling millions of events per second.

ClickHouse ships with a rich ecosystem of built-in storage engines (MergeTree, ReplicatedMergeTree, AggregatingMergeTree, SummingMergeTree), a vectorized query execution pipeline built in C++, native connectors for Kafka, S3, HDFS, PostgreSQL, MySQL, and object storage data lakes including Iceberg, Delta Lake, and Hudi. A managed cloud offering on AWS, GCP, and Azure handles infrastructure concerns for teams that want the performance without the operational overhead.

The project has been actively developed since 2016, has over 48,000 GitHub stars, releases monthly stable versions with a concurrent LTS track, and maintains a global community across 100+ countries with regular in-person meetups and an active Slack.

25 pyasn1-modules ==0.4.2 29 dict2xml ==1.7.8 31 legacy-cgi ==2.6.4 32 mdurl ==0.1.2 33 exceptiongroup ==1.3.1 36 python-rsa ==4.9.1 37 TheFuzz ==0.22.1 37 xdg 3.0.0 38 kafka-python-ng ==2.2.3 38 sniffio ==1.3.1 39 h11 ==0.16.0 39 ordered-set ==4.1.0 40 aiosqlite ==0.22.1 40 python-snappy ==0.7.3 41 GeoMet ==1.1.0 41 python-tabulate ==0.8.6 outdated 42 pykrb5 ==0.9.0 outdated 42 zipp ==3.19.1 outdated 43 dicttoxml ==1.7.16 43 jmespath.py ==1.0.1 outdated 43 pytest-repeat ==0.9.4 44 requests-kerberos ==0.15.0 45 markupsafe ==2.1.5 outdated 45 Blinker ==1.4 outdated 45 mccabe ==0.7.0 45 six ==1.16.0 outdated 49 serde_bytes 0.11.15 49 tomli ==2.2.1 outdated 50 httplib2 ==0.20.2 outdated 51 mypy_extensions ==1.1.0 51 term 1.0.0 53 Jinja ==3.1.6 53 annotated-types ==0.7.0 outdated 53 httpcore ==1.0.9 53 python-dateutil ==2.9.0.post0 53 tzlocal ==2.1 outdated 54 HTTPX ==0.28.1 55 PyYAML ==6.0.1 outdated 55 python-lz4 ==4.4.5 55 typing-inspection ==0.4.1 outdated 57 argon2-cffi-bindings ==25.1.0 outdated 57 pyspnego ==0.12.1 outdated 57 pytest-timeout ==2.4.0 60 pytest-reportlog ==1.0.0 60 xmltodict 61 tar 0.4.44 62 deepdiff ==8.6.1 outdated 62 rich ==14.3.3 outdated 63 s3fs ==2026.2.0 outdated 64 memmap2 0.9.8 65 Certifi ==2025.4.26 outdated 65 distro ==1.7.0 outdated 65 python-dotenv ==1.2.2 outdated 67 clickhouse-rs 0.13.1 outdated 67 Paramiko ==3.4.0 outdated 67 pycryptodome ==3.23.0 68 cramjam ==2.11.0 outdated 68 dill ==0.4.0 outdated 68 pytz ==2023.3.post1 outdated 68 termcolor ==1.1.0 outdated 69 Bottle ==0.12.25 outdated 69 execnet ==2.1.2 69 pytest-order ==1.3.0 outdated 70 argon2-cffi ==25.1.0 70 websocket-client ==1.9.0 outdated 71 ClickHouse Driver ==0.2.7 outdated 71 ClickHouse Driver 71 s3transfer ==0.16.0 outdated 71 soupsieve ==2.8.4 outdated 72 psycopg2 ==2.9.11 outdated 73 OAuthLib ==3.2.2 outdated 73 wheel ==0.46.1 outdated 74 jwcrypto ==1.5.6 outdated 75 anstream 0.6.12 outdated 75 bcrypt (Python) ==4.1.3 outdated 75 serde_json 1.0.140 76 BLAKE3 1.5.4 76 log 0.4.22 76 minio-py ==7.2.20 76 serde 1.0.215 76 sqlparse 76 toml 0.9 outdated 77 polyglot-sql 0.1.13 outdated 77 pycparser ==2.22 outdated 77 tenacity ==8.5.0 outdated 78 kazoo @ git+https://github.com/ClickHouse/kazoo.git@879e0b0e4ae367a289847b43a531938f68770125 79 DataComPy ==0.19.2 outdated 80 pluggy ==1.6.0 80 python-unidiff ==0.7.5 outdated 81 cffi ==1.17.1 outdated 81 idna ==3.15 outdated 81 SQLGlot ==28.10.1 outdated 82 botocore ==1.42.61 outdated 82 markdown-it-py ==3.0.0 outdated 82 Psycopg ==3.3.3 outdated 82 Psycopg ==3.3.3 outdated 82 Requests ==2.32.4 outdated 83 Charset Normalizer ==3.4.5 outdated 83 PyGithub ==1.43.5 outdated 83 pyparsing ==2.4.7 outdated 83 pytest-xdist ==3.8.0 83 tomlkit ==0.13.3 outdated 84 cryptography ==48.0.1 outdated 84 gcsfs ==2026.2.0 outdated 84 mypy ==1.15.0 outdated 84 packaging ==24.1 outdated 85 PyJWT ==2.13.0 outdated 85 RapidFuzz 85 Shapely ==2.1.0 outdated 85 wrapt ==1.17.2 outdated 86 env_logger 0.11.5 86 psutil 86 typing_extensions ==4.14.0 outdated 87 AnyIO ==4.10.0 outdated 87 confluent-kafka-python ==2.13.2 outdated 87 docker-py ==7.1.0 outdated 87 isort ==5.13.2 outdated 87 more-itertools ==8.10.0 outdated 87 pip ==25.0.1 outdated 87 pipdeptree ==2.23.0 outdated 87 pycurl ==7.45.3 outdated 87 PySpark ==3.5.5 outdated 88 Click ==8.3.1 outdated 88 skim 0.20.2 outdated 89 filelock ==3.25.0 outdated 89 lxml ==6.1.0 outdated 89 platformdirs ==4.3.8 outdated 89 tqdm ==4.67.1 outdated 90 astroid ==3.1.0 outdated 90 Black >=22.0.0 90 Clap 4.5.22 90 cxx 1.0.83 90 Pika ==1.3.2 outdated 90 prqlc 0.13.2 90 Ruff ==0.15.13 outdated 91 Apache Avro (Python) ==1.12.1 outdated 91 boto3 ==1.42.61 outdated 92 clickhouse-connect ==0.8.18 outdated 93 deltalake ==0.25.5 outdated 93 GeoPandas ==1.1.2 outdated 93 Pydantic ==2.12.5 outdated 93 Pydantic ==2.41.5 outdated 93 Tokio 1.42.0 93 urllib3 ==1.26.20 outdated 94 delta-spark ==3.3.0 outdated 95 PyArrow ==23.0.1 outdated 95 Pylint ==3.1.0 outdated 95 redis-py ==5.0.1 outdated 95 setuptools ==78.1.1 outdated 96 NumPy ==2.3.2 outdated 96 OpenAI Python SDK ==1.99.9 outdated 96 pytest ==9.0.3 outdated 98 Azure Container Service Management (Python) ==1.38.2 outdated 98 Azure Identity (Python) ==1.25.2 outdated 98 Azure Storage Blob ==12.27.1 outdated 98 Azure Container Service Management (Python) ==12.22.0 outdated 98 google-auth ==2.49.0 outdated 98 gRPC Python (grpcio) ==1.78.0 outdated 98 pandas ==2.3.3 outdated 98 Protocol Buffers ==6.33.5 outdated 98 SciPy ==1.16.1 outdated

Join founders buildingwith open source

Opinionated takes, migration guides, cost-saving tips, and insights from the open source ecosystem.

Subscribe on Substack
Join 750+ subscribers

Search