MyScale

What is MyScale?

MyScale is a next-generation AI database that combines vector search with SQL analytics, offering a streamlined, fully-managed, and high-performance experience. It allows developers to build production-grade GenAI applications using familiar SQL, minimizing the learning curve and maximizing value.

Key Features and Benefits:

• Fully SQL-Compatible Vector Database: Perform fast and powerful vector search, text search, filtered search, and SQL-vector join queries.
• Enhanced RAG Effectiveness: Achieve superior RAG (Retrieval-Augmented Generation) results by combining vector and full-text search with advanced metadata filtering.
• High-Performance and Cost-Efficient: Benefit from 3x the speed and 3x the savings with the MSTG vector engine.
• SQL/Relational Vector Database: Manage and query AI-related data within a single system, executing advanced SQL vector joint queries.
• Powerful Full-Text Search: Utilize BM25 for enhanced relevance ranking and configurable tokenizers for various languages.
• Integrates with Your AI Stack: Deep integration with popular development languages and frameworks, including seamless LLM application observability with MyScale Telemetry.

How to Use MyScale:

1. Create MSTG index:

   ALTER TABLE doc_table
   ADD VECTOR INDEX vec_idx vector
   TYPE MSTG('metric_type=Cosine');
   

2. Perform vector search:

   SELECT
       id, title, text
       distance(vector, query_vector) as dist
   FROM doc_table
   ORDER BY
       dist ASC
   LIMIT 10;
   

Why Choose MyScale?

Industry leaders praise MyScale for its SQL compatibility, ease of use, performance, and cost-effectiveness. It seamlessly integrates with Langchain and offers essential compatibility in Text to SQL integration.

Use Cases:

• RAG for Domain Knowledge Base
• Recommendations
• Chatbot
• Image Search

Getting Started:

Start building your AI projects with MyScale today with a free trial or explore the playground to experience its capabilities firsthand.