MyScale | Run Vector Search with SQL

What is MyScale?

MyScale is a SQL vector database that enables developers to build production-grade Generative AI applications with powerful and familiar SQL. It provides a scalable and cost-effective solution for managing and querying AI-related data.

Features of MyScale

• Vector Search: Perform fast and powerful vector search, text search, filtered search, and SQL-vector join queries.

• Text Search: Utilize advanced metadata filtering for precise outcomes.

• Filtered Search: Achieve superior RAG (Retrieval-Augmented Generation) results by combining vector and full-text search for thorough data retrieval.

• Complex Queries: Execute advanced SQL vector joint queries and enable text-to-SQL translation for complex querying needs.

• High-Performance and Cost-Efficient: 3x the speed, 3x the savings with MSTG vector engine.

• SQL/Relational Vector Database: Manage and query AI-related data within a single system.

• Integrates with Your AI Stack: Deep integration with popular development languages and frameworks.

• Security and Compliance: SQL-based RBAC, in compliance with SOC 2, and ISO 27001 Compliance.

How to Use MyScale

To get started with MyScale, you can follow these steps:

1. Create a Vector Index: Create a vector index on a column in your table using the MSTG algorithm.

2. Perform Vector Search: Perform a vector search query using the distance function to retrieve the top 10 results.

Example:

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

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

Pricing and Resources

MyScale offers a free trial and a flexible pricing plan that scales with your needs. You can also access various resources, including documentation, blog articles, and community support.

FAQs

• What is the difference between MyScale and a specialized vector database?: MyScale is a SQL vector database that combines the power of SQL with the efficiency of vector search.

• What types of vector data does MyScale support?: MyScale supports various types of vector data, including dense and sparse vectors.

• What is the difference between traditional search and vector search?: Vector search is a more efficient and effective way of searching for similar vectors in a high-dimensional space.

Helpful Tips

• Start with a free trial: Try MyScale today and experience the power of SQL vector search.

• Explore the documentation: Access the MyScale documentation to learn more about its features and capabilities.

• Join the community: Connect with the MyScale community to get support and stay updated on the latest developments.