Book a Demo Start Instantly

TiDB Serverless revolutionizes MySQL databases with its cutting-edge vector similarity search feature. By seamlessly integrating vector search capabilities, developers can now efficiently compare machine learning embeddings within their SQL environment. This innovative approach eliminates redundancy by storing vector embeddings alongside MySQL data directly, streamlining data management processes. The importance of this integration lies in enhancing AI applications through simplified data handling and leveraging SQL for advanced semantic searches.

What is Vector Similarity Search?

Similarity Search is a fundamental method in data science for efficiently retrieving relevant information within extensive datasets. It enables the quick identification and ranking of similar vectors based on their underlying meaning rather than exact matches. This approach is crucial for tasks like image retrieval, recommendation systems, and fraud detection.

Advantages and Limitations of Similarity Search

  • Efficient Retrieval: Similarity search allows for quick and accurate retrieval of semantically similar data.
  • Scalability: It enables efficient processing of large-scale datasets, making it ideal for applications with massive amounts of information.
  • Accuracy: By using distance metrics like cosine similarity or Euclidean distance, similarity search ensures precise results.
  • Limitations: While powerful, similarity search may face challenges with high-dimensional data due to the curse of dimensionality.

Use Cases for Vector Similarity Search

Image Search

Vector similarity search is widely used in image search engines to find visually similar images. By representing images as vectors, the system can quickly identify matching patterns or features.

Intelligent Recommendation

E-commerce platforms leverage vector similarity search to provide personalized recommendations to users. By analyzing user preferences as vectors, the system can suggest items that align with their tastes.

Fraud Detection

In finance and cybersecurity, vector similarity search plays a vital role in fraud detection. By comparing transaction patterns or user behavior as vectors, anomalies can be detected efficiently.

TiDB Serverless and Vector Similarity Search

TiDB Serverless seamlessly integrates vector search capabilities into the MySQL landscape, empowering developers to harness the best of both worlds. By combining the reliability of MySQL with advanced functionalities of vector search, TiDB Serverless opens up a world of possibilities for innovative AI applications.


How TiDB Serverless integrates vector search

  • Effortless Integration: TiDB Serverless smoothly incorporates vector search functionalities directly into the familiar MySQL environment. This integration simplifies the process for developers, allowing them to leverage advanced AI capabilities without extensive modifications to their existing systems.
  • Seamless Functionality: The integration of vector search into TiDB Serverless ensures that developers can easily access and utilize these powerful features within their SQL workflows. This seamless functionality streamlines the development process and enhances productivity in building AI applications.


Built-in vector search capabilities

  • Advanced Search Capabilities: TiDB Serverless offers built-in vector search capabilities that enable developers to perform complex similarity searches within their databases. This feature empowers users to efficiently compare machine learning embeddings and retrieve relevant information with precision.
  • Enhanced Data Retrieval: With its built-in vector search capabilities, TiDB Serverless simplifies data retrieval processes by allowing users to quickly identify similar vectors based on underlying patterns or features. This functionality enhances the efficiency of searching through large datasets.

👉 Build AI applications confidently with SQL you already know well. Join the Waitlist

Use Cases

Examples of applications using TiDB Serverless

  • Image Search Applications: Developers can leverage TiDB Serverless for image search applications, where visual similarity plays a crucial role in retrieving relevant images. By representing images as vectors, this solution enables quick and accurate matching based on visual patterns.
  • RAG Applications: TiDB Serverless is ideal for applications requiring semantic searches, such as RAG (Retrieval-Augmented Generation) models. By integrating vector search capabilities, developers can enhance the performance of RAG applications by efficiently retrieving semantically similar data.
  • Chat Applications: In chat applications where understanding context is essential, TiDB Serverless with vector similarity search proves invaluable. By analyzing text inputs as vectors, developers can implement intelligent chatbots that provide relevant responses based on semantic similarities.

By seamlessly integrating vector search capabilities into the MySQL ecosystem, TiDB Serverless empowers developers to unlock the potential of innovative AI applications while maintaining the simplicity and familiarity of SQL-based environments.

Benefits of TiDB Serverless

Simplified Data Management

Storing vector embeddings alongside MySQL data simplifies the process of managing information in TiDB Serverless. By integrating vector search capabilities directly into the database, developers can efficiently handle both operational and vector data within a single environment. This streamlined approach eliminates the need for separate storage solutions, reducing redundancy and enhancing overall data organization.

Enhanced AI Capabilities

Leveraging SQL for AI applications is a key advantage of TiDB Serverless. Developers can harness the power of familiar SQL commands to access and manipulate vector data seamlessly. This integration enables the creation of advanced AI models that leverage both structured and unstructured information for enhanced decision-making processes.


Integration with popular AI platforms further enhances the versatility of TiDB Serverless. By seamlessly connecting with platforms like OpenAI, Hugging Face, LangChain, and LlamaIndex, developers gain access to a wide range of tools and resources for building innovative AI applications. This compatibility ensures that TiDB Serverless remains at the forefront of AI technology advancements.

TiDB Serverless offers a seamless solution for developers and companies, enhancing productivity, accelerating time-to-market, and making innovation more accessible. By combining traditional database functionality with advanced vector search capabilities, TiDB Serverless provides scalability to meet the demands of various AI applications. The platform facilitates easier onboarding, lowers collaboration expenses, and guarantees agile project development. With an AI-assisted SQL Editor and support for high-performance analytics, TiDB Serverless empowers developers to enhance productivity and derive real-time data insights.

Last updated May 19, 2024

Spin up a Serverless database with 25GiB free resources.

Start Now