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.

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 open-source vector DB built for billion-scale.

    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.

    Worth knowing

    Often cited as the first open-source vector database; a graduated LF AI & Data Foundation project since 2021.

    • 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.

    Worth knowing

    Berlin-based, founded 2021; raised a $28M Series A led by Spark Capital in January 2024.

    • 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.

    Worth knowing

    Founded in Amsterdam in 2019 under the name SeMI Technologies; raised a $50M Series B led by Index Ventures in 2023.

    • 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.

    Worth knowing

    Created in 2021 by Andrew Kane, a solo open-source developer; it's now offered managed by AWS, Google Cloud, Azure, Supabase, and Neon.

    • postgres
    • open-source
    • extension
    • rag