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