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