MyScale
discontinuedby MyScale (Moqi) · since 2023 · also known as MyScaleDB
Former SQL vector database forked from ClickHouse; the company shut down in 2025.
discontinued. MyScale announced it was ceasing operations in April 2025 and closed in May 2025; the cloud service is offline and the MyScaleDB repo is inactive since Feb 2025. Migrate to ClickHouse vector indexes or a vector DB.
Overview
MyScale was a managed SQL vector database built on a fork of ClickHouse, adding its MSTG vector index, Tantivy-based full-text search and SQL functions for hybrid and filtered vector queries. The engine was open-sourced as MyScaleDB under Apache-2.0 in 2024. The company announced it was ceasing operations in April 2025 and closed in May 2025; the cloud console is offline and the repository has had no commits since February 2025. Existing users should migrate, typically to ClickHouse (which now has native vector similarity indexes) or a dedicated vector database.
Strengths & trade-offs
Strengths
- +Vector search combined with full ClickHouse SQL analytics
- +Filtered and hybrid search expressed in SQL
- +Columnar storage made metadata filters cheap
Trade-offs
- −Vendor ceased operations in 2025
- −No security patches or releases since late 2024
- −Fork has diverged from upstream ClickHouse
Great for
- +Historical reference for SQL-plus-vector designs
- +Planning migrations of existing MyScale data to ClickHouse
Think twice for
- −Any new project
- −Production workloads needing support or security fixes
Capabilities
Native or official first-party support · 10 of 25 tracked
Scale & consistency
- Comfortable data size
- Large · ≤ 1 PB
- Horizontal scaling
- Native
- Multi-region
- No
- Transactions
- None
- Consistency
- Eventual
- Schema
- Strict
- Architecture
- Distributed, Client server
- Query languages
- SQL (ClickHouse dialect)
Inherited ClickHouse sharding and replication.
Deployment
Ecosystem
Alternatives to MyScale
Open-source columnar OLAP database known for very fast aggregations over billions of rows.
myscale vs clickhouse →Cloud-native, distributed open-source vector database built for billions of vectors.
myscale vs milvus →The standard Postgres extension for vector similarity search with HNSW and IVFFlat indexes.
myscale vs pgvector →Embedded, serverless retrieval database on the Lance columnar format for multimodal AI data.
myscale vs lancedb →Distributed SQL mixing in-memory rowstore and columnstore for real-time analytics, search and vectors.
myscale vs singlestore →Rust vector search engine with rich payload filtering, quantization and a managed cloud.
myscale vs qdrant →MyScale FAQ
What is MyScale?
MyScale is a vector database by MyScale (Moqi), first released in 2023. MyScale was a managed SQL vector database built on a fork of ClickHouse, adding its MSTG vector index, Tantivy-based full-text search and SQL functions for hybrid and filtered vector queries. The engine was open-sourced as MyScaleDB under Apache-2.0 in 2024. The company announced it was ceasing operations in April 2025 and closed in May 2025; the cloud console is offline and the repository has had no commits since February 2025. Existing users should migrate, typically to ClickHouse (which now has native vector similarity indexes) or a dedicated vector database.
Is MyScale open source?
Yes. MyScale is open source. License: Apache License 2.0.
Does MyScale support ACID transactions?
No. MyScale does not provide ACID transactions; its consistency model is eventual.
Does MyScale scale horizontally?
MyScale scales horizontally out of the box, with built-in sharding or partitioning. It is comfortable at large scale (≤ 1 PB).
How can I run MyScale?
You can self-host it.
What is MyScale best for?
MyScale is a strong fit for historical reference for SQL-plus-vector designs and planning migrations of existing MyScale data to ClickHouse. Think twice for any new project.
What are the best alternatives to MyScale?
Common alternatives to MyScale include ClickHouse, Milvus, pgvector, LanceDB and SingleStore. The right choice depends on your workload, scale and hosting; WhichDB's smart match ranks them against your requirements.
Is MyScale still maintained?
MyScale is discontinued. MyScale announced it was ceasing operations in April 2025 and closed in May 2025; the cloud service is offline and the MyScaleDB repo is inactive since Feb 2025. Migrate to ClickHouse vector indexes or a vector DB.
How popular is MyScale?
MyScale ranks #497 of 844 databases on the WhichDB Score (2.0/100), and #28 among vector databases. The score combines public adoption signals such as package downloads, GitHub activity, job posts and developer discussion.