← back to the directory
Application Retrieval & Memory

MyScaleDB

1SQL 2vector 3database 4built 5on 6ClickHouse

the six Ws · specification

W1 Who

Analytics and AI teams wanting vector search combined with familiar SQL and structured data queries.

W2 What

MyScaleDB is an open source vector database built on ClickHouse that lets developers run vector, full text, and filtered search using standard SQL.

W3 Where

Self hosted by deploying the MyScaleDB server, or used via the managed MyScale cloud service.

W4 When

Released around 2023 and actively maintained with ongoing commits as of 2026.

W5 Why

Lets teams reuse SQL and ClickHouse's columnar performance for large scale vector search instead of adopting a separate specialized database.

W6 With

Built on top of ClickHouse's storage engine and requires embeddings generated by an external model.

W7 Watch

Open source software under Apache-2.0; can be self hosted, or used through the paid MyScale managed cloud where data is hosted by MyScale.

vector databaseSQLClickHouse basedhybrid searchfull text search

for agents & scripts

Reading this as a machine? Query it directly.

Search is open JSON - no key. Report telemetry after using a tool and it feeds that tool’s Proof Score. Or speak MCP to /mcp and discover tools mid-loop.