Sign inTry Free

Aura Analyst

On this page

Note

This is a Preview feature.

Overview

Aura Analyst is an AI-powered data analyst that makes it easy to converse with the data in plain English. It is a fully managed agentic AI service built natively for SingleStore that translates natural language questions into precise SQL queries and instantly delivers insights from the databases. By removing the requirement of manually writing SQL or building complex dashboards, Aura Analyst accelerates analytics and empowers users to uncover insights faster. Leveraging SingleStore’s Agentic AI platform, it ensures that queries are accurate, context-aware, and governed, helping teams make smarter, data-driven decisions with ease.

How Aura Analyst Works

Aura Analyst is a fully managed agentic, multi-component AI system designed to transform natural language into reliable, actionable insights. Instead of relying on a single, monolithic model, it orchestrates a series of specialized stages, including intent interpretation, query planning, SQL generation, validation, execution, and result summarization. This modular architecture enhances accuracy, ensures control, and adapts flexibly across diverse datasets and query types.

By clarifying ambiguous inputs, exposing query plans, and automatically retrying on failures, Aura Analyst provides a more dependable experience while building user trust. Beyond running SQL, the system makes results easy to interpret through natural-language summaries and visualizations, enabling business and technical users alike to act on data with confidence.

What is a Domain

A Domain is the context service for Aura Analyst. It acts as a knowledge base, supplying the semantic and structural framework required to interpret questions accurately, generate the right SQL, and deliver governed insights.

Users with the “Agent Domain Owner” permission can configure Domains by selecting relevant workspaces, databases, and tables. They can enhance Domains with custom instructions, business-specific formulas, or logic that Aura Analyst applies when answering questions.Once configured, a Domain abstracts the complexity of raw schemas. Users interact with a curated, context-rich view of the data, making analytics more accurate, consistent, and accessible.

Domains are dynamic. As data changes and new business requirement emerges, users can continuously refine them. Each update enhances the context service, ensuring that insights remain reliable, governed, and immediately actionable.

Create a Domain

Once the Aura Analyst is enabled, select Create domain. In the Create Domain dialog:

Domain Details

Name

Enter the name of the domain.

Description

Enter the domain description.

Connect Data

Connection

Select the SingleStore deployment (workspace) the domain connects to.

Specifying a workspace allows connecting the SingleStore databases referenced in the domain.

SingleStore recommends creating a new workspace with a read-only database attachment for Aura Analyst to maintain clarity and separation of workloads.

Select tables

Select the tables from the SingleStore databases.

Select Create to create the domain for Aura Analyst.

Configure an Existing Domain

To configure an existing domain, perform the following steps:

  1. From the Domain list in the chatbox, select Domain settings.

  2. In the Configure Domains dialog, enter or select the following:

    Data

    Add more tables to the domain by selecting Add. Tables can be added from the deployment connected to the domain.

    Context

    Contexts are reference materials that the Analyst can draw on to answer questions more accurately. Use them to provide custom instructions, background knowledge, assumptions, or business logic that may not be immediately obvious from the raw data.

    To add a context, select Add Context, enter the context, and then select Save.

    Update and delete existing contexts.

    Saved Queries

    Saved Queries allows storing natural language questions together with their corresponding SQL statements. They are useful for reusing common queries, sharing examples with others, and helping the agent learn how similar questions must be handled. Saved Queries are domain specific.

    To add a saved query, select Add Query, enter Question and SQL Query, and then select Save.

    Saved queries can be updated or deleted as required.

    Access Controls

    Access Control provides the ability to assign roles, set permissions, and control who can access the domain.

    View all the users or teams and their roles in this tab. To share access to the domain with a user or a team, select Add New. In the Share <your_domain> dialog, select User or Team, select the access role, and then select Save.

    To remove access for any User or Team, select Remove Access in the access role of the selected user or team.

    Note

    Inherited roles cannot be modified.

    Details

    Update the domain name and description in the Name and Description fields respectively. Select Delete Domain to delete the domain.

Aura Analyst Access Controls

SingleStore Aura defines three RBAC (role-based access control) roles for Aura Analyst:

  • Organization Level Controls:

    • Aura Creator: Provide ability to install and uninstall Aura Analyst.

    • Agent Domain Owner: Provides ability to create and manage domains.

  • Domain Level Controls:

    • Owner: Provides ability to manage a given domain.

    • User: Provides ability to use the domain and ask questions in natural language and receive responses.

When an Agent Domain Owner creates a domain, the system performs the following actions:

  • Aura Analyst fetches the data accessible to the Agent Domain Owner.

  • Aura Analyst uses AI to infer tables and column definitions.

    • SingleStore recommends owners to review the description and modify as required.

  • When creating a new domain, a database user <domain_id>_auraanalyst is created with select permissions to the tables selected in the domain.

  • All queries run by Aura Analyst within a Domain are run as <domain_id>_auraanalyst user.

Interacting with Aura Analyst

Once a domain is created and configured, you can ask any data related questions to Aura Analyst using natural language. To start a conversation, select the desired domain in the chatbox. Domains can be switched at any time during a conversation.

Note

All queries and interactions require an active Domain context.

Within a conversation, following features can be accessed:

  • Thoughts block: View how Aura Analyst approached to provide the insights as a response including the SQL queries executed.

  • Left panel controls:

    • View the chat history.

    • Start a new session.

    • Delete an existing session.

Note

Observers can use Monitoring and Query History to track queries run by Aura Analyst, including slow-performing queries.

Examples

Example 1: SaaS Product Usage Analytics

This example analyzes product adoption by creating a domain focused on it, using the relevant tables from the saas_usage database.

Create Domain dialog showing 'SaaS Usage Domain' name, connection deployment set to workspace-1, and four tables selected from saas_usage database: subscriptions, support_tickets, usage_logs, and users. Cancel and Create buttons appear at the bottom.

Once the domain is created, questions can be asked about the data.

Example 2: E-commerce Marketing and Campaign Analytics

This example analyzes marketing product adoption by creating a domain focused on it, using the relevant tables from the marketing_analytics database.

Create Domain dialog showing 'Marketing Analytics Domain' name, connection deployment set to workspace-1, and five tables selected from marketing_analytics database. Options to cancel or create are at the bottom.

Then, adds Context and Saved Queries for more accurate and efficient analysis.

Once the domain is created, questions can be asked about the data.

Last modified: September 30, 2025

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