Skip to content

Vector DBMyScale

MyScale

SQL vector database built on ClickHouse — vector, full-text, and analytics in one query.

Category
Vector DB
Pricing
FREEMIUM
Source
Open core
Hosting
Hybrid
Platforms
API
Models
Model-agnostic
Verified
Jun 14, 2026

MyScale is a SQL-native vector database built as a ClickHouse fork, so a single SQL statement can combine vector similarity search, full-text search, and standard structured/analytical queries. It is offered as a managed cloud service with a free starter pod, and its core engine, MyScaleDB, is open source. The SQL-first design lets teams join embeddings with their existing relational data without standing up a separate vector store.

Capabilities 3

What it actually does — grouped by capability family.

  • Vector search (primary capability)
  • Unified search (primary capability)
  • RAG pipeline (secondary capability)

Pros & cons

  • Open source (Apache-2.0), self-hostable
  • SQL joins vectors with structured data
  • Built on battle-tested ClickHouse
  • Free managed starter pod
  • Smaller community than Pinecone/Milvus
  • Open-source release cadence slowed after 2024
  • SQL-first model has a learning curve

Tags

View all Vector DB
  • View Milvus details
    Vector DBFREEMIUMOpen core

    Milvus

    Zilliz

    Distributed vector database built for billion-scale search.

    Cloud-native, Apache-2.0 vector database for similarity search at scale, powering RAG, semantic and multimodal search, and recommendations. Its distributed architecture separates storage and compute and supports many index types (HNSW, IVF, FLAT, DiskANN, SCANN) with quantization and mmap. Created by Zilliz, which offers the managed Zilliz Cloud.

    Scales to billion-vector deployments
    Operationally heavy to self-host
    • vector-db
    • open-source
    • rag
    • ann-search
    • +1
  • View Qdrant details
    Vector DBFREEMIUMOpen core

    Qdrant

    Qdrant

    Open-source, Rust-based vector DB. Fast, predictable, self-hostable.

    Vector database written in Rust with a strong focus on filtering, payloads, and predictable latency at scale. Self-host on a single binary or use the managed cloud.

    Open source, written in Rust
    More ops than fully-managed rivals
    • open-source
    • rust
    • self-hosted
    • fast
  • View Weaviate details
    Vector DBFREEMIUMOpen core

    Weaviate

    Weaviate

    Open-source vector database with built-in vectorisers.

    Cloud-native vector DB that can compute embeddings inline — pass raw text in, store vectors out. Strong hybrid (BM25 + vector) search; self-hostable or managed.

    Hybrid BM25 + vector search
    Resource-heavy at large scale
    • open-source
    • self-hosted
    • hybrid-search
    • rag
  • View pgvector details
    Vector DBFREEOSS

    pgvector

    pgvector community

    Vector similarity search inside Postgres. The pragmatic default.

    Postgres extension that adds a vector type plus exact and approximate nearest-neighbour search. Pairs naturally with Supabase, Neon, and any managed Postgres. The lowest-friction RAG backend if you already run Postgres.

    No new database to operate
    Scales worse than dedicated vector DBs
    • postgres
    • open-source
    • extension
    • rag