SingleStore Studio

On this page

Caution

Studio has been superseded by SingleStore’s monitoring solution which is recommended for self-managed deployments.

Studio is not compatible with the SingleStore Kubernetes Operator.

Important

Studio should be installed on a host that is open to local (internal) network traffic but is not open to the Internet.

Note

Studio is designed to work with MemSQL 6.5 or later and is only supported on Chrome and Firefox browsers.

Studio is not intended as a comprehensive monitoring solution and therefore lacks the features of similar third-party tools. SingleStore recommends exploring these supported third-party tools, which have been tested by SingleStore and are likely familiar to developers. These tools offer advanced features, improved performance, and specialized capabilities for managing complex database operations, and can provide increased efficiency and a smoother workflow.

Should you encounter any issues with these tools, or require further assistance, please contact SingleStore Support.

Overview

SingleStore Studio is a visual user interface that allows you to interact with all of your SingleStore clusters, and was designed to be lightweight, easy to deploy, and easy to upgrade.

Studio turns user actions into standard SQL queries that are run against your SingleStore cluster. Results are then displayed back to you in the form of tables and graphics that help you understand your cluster better. Conceptually, Studio is a UI on top of the SingleStore database engine itself, pairing the stability and security guarantees of the command line with the ease of use of a visual UI.

Studio is a visual SQL client, so it can be used safely alongside other third-party tools.

In this section

Last modified: September 19, 2024

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