Skip to main content


ClickHouse is the fast and resource efficient open-source database for real-time apps and analytics with full SQL support and a wide range of functions to assist users in writing analytical queries. It has data structures and distance search functions (like L2Distance) as well as approximate nearest neighbor search indexes That enables ClickHouse to be used as a high performance and scalable vector database to store and search vectors with SQL.

Installation and Setup​

We need to install clickhouse-connect python package.

pip install clickhouse-connect

Vector Store​

See a usage example.

from langchain_community.vectorstores import Clickhouse, ClickhouseSettings

Was this page helpful?

You can also leave detailed feedback on GitHub.