myscale.com

Overview

SQL vector search combining AI embeddings and full-text retrieval.

MyScale is a SQL vector database that supports vector search, text search, filtered search, and SQL-vector join queries for AI applications. It provides MSTG vector indexes (configurable metric types like Cosine) and BM25 full-text search to combine semantic and lexical retrieval.

MyScale supports metadata filtering, complex SQL queries, and data import/export to streamline RAG (Retrieval-Augmented Generation) pipelines and domain knowledge bases. The platform offers observability via MyScale Telemetry and integrations with common developer SDKs and frameworks, including LangChain.

Operational features include optimized index building and faster data ingestion for large-scale vector workloads. Security and access controls use SQL-based RBAC and compliance certifications such as SOC 2 and ISO 27001. Typical use cases include RAG systems, chatbots, recommendation engines, and image search where SQL familiarity and vector search need to coexist.

Use Cases

• Build a high-performance retrieval-augmented generation pipeline with MyScale to combine semantic vector search and BM25 lexical ranking using SQL–vector joins, enabling fast, scalable document retrieval with metadata filtering and SQL-based RBAC for secure production deployments.
• Ingest and index millions of enterprise documents into MyScale using fast ingestion and MSTG vector indexes with configurable metrics, then run hybrid semantic+lexical searches via SQL to power knowledge search, customer support, and internal knowledge bases with observability and SDK integrations.
• Implement a hybrid search feature for your application by using MyScale's BM25 full-text search alongside vector similarity, perform SQL-based joins to enrich results with relational data, and apply SQL-based RBAC and monitoring to ensure secure, auditable search in multi-tenant SaaS products.

Pricing

Verify on theofficial pricing page.

• Free pod: $0
• Capacity-optimized: $0
• Standard: starting from 68/mo

Who Is It For

• Software developers
• Data engineers
• Application builders
• Database administrators
• Data scientists