# MyScale

> SQL-compatible vector database for scalable AI applications with powerful vector search, full-text search, and metadata filtering capabilities.

MyScale is a SQL-compatible vector database designed for building production-grade generative AI applications. It enables developers to perform fast vector search, text search, filtered search, and complex SQL-vector join queries using familiar SQL syntax. The platform combines structured and vector data management in a single system, making it ideal for RAG (Retrieval-Augmented Generation) applications, chatbots, recommendation systems, and image search.

- **MSTG Vector Engine** provides 3x the speed and 3x the cost savings compared to specialized vector databases, with optimized index building and performant metadata filter search capabilities.

- **Full SQL Compatibility** allows developers to manage and query AI-related data within a single system, execute advanced SQL vector joint queries, and enable text-to-SQL translation for complex querying needs.

- **Powerful Full-Text Search** includes BM25 for enhanced relevance ranking, configurable tokenizers for various languages, and a simple yet powerful query language.

- **Enhanced RAG Effectiveness** combines vector and full-text search for thorough data retrieval, utilizes advanced metadata filtering for precise outcomes, and adapts to changing business requirements with flexible data modeling.

- **Multiple Data Format Support** handles CSV, JSON, Parquet, and TSV file formats for easy data import and export.

- **Comprehensive SDK Support** offers language SDKs for Python, JavaScript, Go, and Java, enabling seamless integration into existing development workflows.

- **AI Stack Integrations** provides deep integration with OpenAI, LangChain, LlamaIndex, Dify, Hugging Face, Jina AI, DSPy, and other popular AI frameworks and tools.

- **MyScale Telemetry** enables seamless LLM application observability for monitoring and debugging AI applications.

- **Security and Compliance** features SQL-based RBAC, SOC 2 compliance, and ISO 27001 compliance for enterprise-grade security requirements.

To get started, sign up for a free account on MyScale Cloud, which supports up to 5 million 768-dimensional vectors. Create a cluster, connect using your preferred SDK or SQL client, and begin building AI applications with powerful vector search capabilities.

## Features
- Vector search with MSTG algorithm
- Full-text search with BM25
- Filtered search with metadata
- SQL-vector join queries
- Multiple data format support (CSV, JSON, Parquet, TSV)
- AI functions for embeddings
- Aggregate functions
- Time window functions
- JSON functions
- Geospatial functions
- Date/Time functions
- PostgreSQL and MySQL table functions
- SQL-based RBAC
- SOC 2 compliance
- ISO 27001 compliance
- MyScale Telemetry for observability

## Integrations
OpenAI, AWS, LangChain, Jina AI, Hugging Face, LlamaIndex, Dify, BentoML, DSPy, Gemini, Cohere, Voyage AI, Python, JavaScript, Go, Java

## Platforms
LINUX, WEB, API, DEVELOPER_SDK

## Pricing
Freemium — Free tier available with paid upgrades

## Links
- Website: https://www.myscale.com
- Documentation: https://myscale.com/docs/en/
- Repository: https://github.com/myscale/myscaledb
- EveryDev.ai: https://www.everydev.ai/tools/myscale