Sign inTry Free

SingleStore Kai

On this page

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.

Note

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

Disclaimer:

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.

Availability

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

In this section

Last modified: August 2, 2024

Was this article helpful?

On this page

Was this article helpful?

Verification instructions

Note: You must install cosign to verify the authenticity of the SingleStore file.

Use the following steps to verify the authenticity of singlestoredb-server, singlestoredb-toolbox, singlestoredb-studio, and singlestore-client SingleStore files that have been downloaded.

You may perform the following steps on any computer that can run cosign, such as the main deployment host of the cluster.

  1. (Optional) Run the following command to view the associated signature files.

    curl undefined

  2. Download the signature file from the SingleStore release server.

    • Option 1: Click the Download Signature button next to the SingleStore file.

    • Option 2: Copy and paste the following URL into the address bar of your browser and save the signature file.

    • Option 3: Run the following command to download the signature file.

      curl -O undefined

  3. After the signature file has been downloaded, run the following command to verify the authenticity of the SingleStore file.

    echo -n undefined |
        cosign verify-blob --certificate-oidc-issuer https://oidc.eks.us-east-1.amazonaws.com/id/CCDCDBA1379A5596AB5B2E46DCA385BC \
          --certificate-identity https://kubernetes.io/namespaces/freya-production/serviceaccounts/job-worker \
          --bundle undefined \
          --new-bundle-format -
    Verified OK