myscale/MyScaleDB

Health v2 · maintenance only

Adoption not part of the score

1039 stars · 72 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

MyScaleDB is a SQL vector database built as a fork of ClickHouse, adding high-performance vector search and full-text search to a proven OLAP engine. It lets developers build scalable AI and RAG applications using familiar SQL with vector functions, metadata filtering, and SQL-vector joins.

Use cases

• store and query embeddings with SQL
• build a RAG pipeline with metadata filtering
• run filtered vector search at scale
• combine full-text and vector search in one database
• perform similarity search over images or text
• manage structured and unstructured data for AI apps

When to choose

• you already know SQL and ClickHouse and want vector search without a new tool
• you need high-precision filtered vector search for RAG
• you want to unify structured, JSON, time-series, and vector data in one OLAP engine
• you need cost-effective scaling for large embedding datasets

When to avoid

• you need a lightweight embedded vector store for small prototypes
• you require a non-SQL API or ecosystem-specific vector DB features
• you need a fully managed service and don't want to self-host (though MyScale Cloud exists)
• your workload is purely transactional (OLTP) rather than analytical

Facets

application · maturity active

vector-database database search-engine databases large-language-models big-data self-hosted cloud cpp vector-search clickhouse-fork sql-vector similarity-search rag embeddings full-text-search olap sql search retrieval-augmented-generation linux docker

Member repositories

For agents

markdown · JSON · MCP: product_card(name="myscale/MyScaleDB")