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 installclickhouse-connect python package.
Vector Store
See a usage example.Connect these docs programmatically to Claude, VSCode, and more via MCP for real-time answers.