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