SingleStore Kai

Use the SingleStore Kai ("the API") to connect to a SingleStore Helios workspace from MongoDB® clients and tools. You can run the MongoDB® queries natively in your SingleStore Helios workspace using the API without a code change. Additionally, you can use the Management API and Data API (SQL endpoint) in conjunction with the API. SingleStore Kai natively supports the BSON data type for storage. Refer to Kai Data Storage Model for more information.

Refer to Maintenance Release Changelog for information on features and improvements introduced since the preview release of SingleStore Kai.


You can only run the MongoDB® commands in your SingleStore Helios database using the SingleStore Kai-enabled endpoint.


SingleStore is not a MongoDB® partner. SingleStore Kai™ is an API that offers compatibility and enhanced performance for applications built on MongoDB®.

Why Use the API for MongoDB®

SingleStore Kai offers an innovative, fast, and easy API to perform exceptionally fast analytics on JSON data for your MongoDB® applications without losing transactional performance.

Key benefits to using SingleStore Kai:

  • Drive faster analytics on JSON data for your MongoDB® applications.

  • Zero code changes and zero data transformations required for supported commands and operations.

  • Best of both worlds (NoSQL + SQL), lets developers utilize both the MongoDB® API and a SQL API to power their applications.

  • Scale-out SingleStore without any additional cost and simply by defining a shard key.

  • Vector support lets users provide semantics on vectors using dot_product, euclidean_distance, and many other functions available through the API.

How the API Works

The API uses a proxy service (provided by SingleStore) to run the MongoDB® commands and aggregation pipelines. The proxy service receives the MongoDB® commands, generates the SQL equivalent of the command, and runs the SQL in the SingleStore environment. It then reads the resulting rowsets and returns the results as a collection of BSON (Binary JSON) documents back to the MongoDB® client application.


The SingleStore Kai feature is available in all the regions where SingleStore Helios can be deployed.

In this section

Last modified: March 7, 2024

Was this article helpful?