MyScale Howto
MyScale is a cloud-based SQL vector database optimized for AI applications, combining vector search capabilities with full SQL support for efficient management of structured and unstructured data.
View MoreHow to Use MyScale
Create a MyScale account and cluster: Sign up for a MyScale account and create a new cluster to store your data by following the quickstart guide.
Install required libraries: Install the clickhouse-connect library to interact with MyScale, as well as other dependencies like OpenAI if needed.
Connect to your MyScale cluster: Use the connection details (host, username, password) provided when you created your cluster to establish a connection from your application.
Create a table to store vector data: Use SQL to create a table in MyScale with appropriate columns for your data, including a vector column. Specify the vector index type and distance metric.
Insert vector data: Insert your vector data into the table you created, either by importing from files or inserting programmatically.
Perform vector searches: Use SQL queries with vector functions to perform similarity searches on your data. You can do basic vector searches, filtered searches, or hybrid text+vector searches.
Utilize advanced features: Take advantage of MyScale's SQL capabilities to perform complex queries, joins, and analytics on your vector and structured data.
MyScale FAQs
MyScale is a high-performance, SQL-enabled vector database optimized for AI applications and solutions. It combines vector search capabilities with full SQL support, allowing management of both structured and vector data within the same database.
View More