# Aura Analyst

> **📝 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 theSingleStoredeployment (workspace) the domain connects to.Specifying aworkspaceallows connecting theSingleStoredatabases referenced in the domain.SingleStorerecommends creating a newworkspacewith a read-only database attachment for Aura Analyst to maintain clarity and separation of workloads. |
| **Select tables**  | Select the tables from theSingleStoredatabases.                                                                                                                                                                                                                                                                |

Select **Create** to create the domain for Aura Analyst.

> **📝 Note**: Aura Analyst keeps the workspace active as hourly metadata collection prevents the cluster from remaining idle for more than one hour.

## Configure an Existing Domain

To configure an existing domain, enable **Creator Mode**, and enter or select the following:

| **Build**           |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| ------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **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.<ul> <li><strong>Instructions</strong>: Add general instructions to set response style, constraints, and domain-specific guidance. To add an instruction, enter your context in <strong>Instructions</strong>, and then select <strong>Save</strong>. The following are the context states for the instructions: <ul> <li><strong>Draft</strong>: A working copy of domain instructions that can be edited and tested without affecting the live published version. It is created when a domain owner begins editing instructions in <strong>Creator Mode</strong> and changes remain isolated until explicitly published. This allows domain owners to test and refine instructions, make multiple edits without disrupting active users, and discard changes if needed.</li> <li><strong>Published</strong>: The current live version of domain instructions that the Analyst actively uses to answer questions. All users querying the domain see and use the published version, and the Analyst applies these instructions when generating SQL and interpreting questions. This is the production state visible to all domain users.</li> </ul></li> <li><strong>Learned Context</strong>: The system automatically learns contexts from user questions and interactions. The following are the context states for the learned contexts: <ul> <li><strong>Pending</strong>: Learned contexts that have been automatically generated by the system but have not yet been reviewed by a domain owner. These insights are awaiting approval or rejection.</li> <li><strong>Approved</strong>: Learned contexts that have been reviewed and approved by a domain owner. Only approved contexts are actively used by the Analyst to answer questions and generate SQL queries.</li> <li><strong>Rejected</strong>: Learned contexts that have been reviewed and rejected by a domain owner.</li> </ul> You can update and delete existing learned contexts.</li> </ul>                                                                                                                                                                                                                       |
| **Data**            | The Data section allows you to review and enhance schema metadata and includes relationship management capabilities.<ul> <li>Database: Navigate to the <strong>Database</strong> tab. Auto-generated descriptions for tables and columns help the Analyst understand the data model. Domain owners can edit and refine these descriptions to improve accuracy. Add more tables to the domain by selecting <strong>Add</strong>. Tables can be added from the deployment connected to the domain. To edit the table description, select the ellipsis (three dots), and then select <strong>Edit</strong>. To delete the table, select the ellipsis (three dots), and then select <strong>Delete</strong>. In the <strong>Table</strong> column, select the table and you can view and edit the description of each column of the table.</li> <li>Entity-Relationship: Navigate to the <strong>Relationship</strong> tab. A relationship crawler automatically discovers foreign key relationships using schema analysis and LLM inference, assigning each relationship a confidence score between 0.0 and 1.0. Discovered relationships include source and target database, table, column, cardinality, and description. You can also manually create relationships by selecting source and target tables and columns, specifying cardinality (<strong>> for many-to-one</strong>, <strong>&#x3C; for one-to-many</strong>, <strong>- for one-to-one</strong>, <strong>&#x3C;> for many-to-many</strong>), and saving entries individually or in bulk. Manually created relationships are labeled accordingly. To add a relationship, select <strong>Add</strong>. In <strong>Add table relationship</strong>, enter of select the following: <ul> <li><strong>Left Table</strong>: Select the table from the list.</li> <li><strong>Right Table</strong>: Select the table from the list.</li> <li><strong>Join Condition</strong>: Select the columns from each table to create a join condition.</li> <li><strong>Type</strong>: Select the cardinality type.</li> <li><strong>Description</strong> (Optional): Enter the description.</li> </ul> Select <strong>Save Relationship</strong> to save the table relationship. To edit the relationship, select the ellipsis (three dots), and then select <strong>Edit</strong>. To delete the relationship, select the ellipsis (three dots), and then select <strong>Delete</strong>.</li> </ul> |
| **Governance**      |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| **Chat Review**     | Review recorded analyst conversations and user feedback to monitor quality and identify areas for improvement.View the question, rating, reason, and comment of the response. Select the question to view the Analyst’s response. Monitor response quality, review user feedback, and identify areas for improvement.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| **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**. In the**Share \<your\_domain>**&#x64;ialog, 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.<blockquote> <p><strong>📝 Note</strong>: <p>Inherited roles cannot be modified.</p></p> </blockquote>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| **Settings**        | Update the domain name and description in the**Name**and**Description**fields, respectively. Enable**Record conversations for review**. When enabled, the system saves all conversations for the selected domain to the**Chat Review**. If this setting is disabled, only questions with user feedback are captured in**Chat Review**.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |

## Aura Analyst Access Controls

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

* **Organization Level Controls**:

  * **Aura Creator**: Provides the ability to install and uninstall Aura Analyst.
  * **Agent Domain Owner**: Provides the ability to create and manage domains.
    > **📝 Note**: Domain creation is limited to the tables accessible by the "Agent Domain Owner".
* **Domain Level Controls**:

  * **Owner**: Provides the ability to manage a given domain.
    > **📝 Note**: Domain creation is limited to the tables accessible by the "Owner".
  * **User**: Provides the 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.

A user can be granted Domain-level access even without having privileges on the underlying databases or tables referenced by the Domain. Aura Analyst runs queries inside the Domain as the `<domain_id>_auraanalyst` database user. This allows any user with access to the Domain to query the underlying databases.

A user may be an Aura Domain **User** or **Domain** Owner regardless of other organization roles. A user can be a member without any additional roles (a "roleless" org member) and still receive Domain-level permissions. However, these permissions do not grant or imply elevated privileges on the underlying databases.

> **📝 Note**: Domain owners must manage Domain roles and access settings to align with their organization’s governance policies.

## 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.
* **Feedback**: Your feedback enables a human-in-the-loop system that continuously improves results.

  * Improve accuracy over time: Feedback helps refine how queries are interpreted and answered to deliver more reliable and complete responses for future queries.
  * Domain expert review: Domain owners can review query interactions to identify gaps and improve overall system performance.

  For a query response, use the “**Is this correct?**” option under the query result to provide feedback.

  * Select **Yes** (thumbs-up) if the response is correct.
  * Select **Needs Improvement** (thumb-down) if the response is incorrect or incomplete.

  When **Needs Improvement** is selected, submit feedback by selecting one of the following options:

  * Values look off
  * Missing data
  * Misunderstood question
  * Analyst made something up
  * Other

  Optionally, enter additional details in the field to describe what went wrong.

> **📝 Note**: Observers can use [Monitoring](https://docs.singlestore.com/cloud/user-and-workspace-administration/workspace-health-and-performance/historical-monitoring/#section-idm33412590041948.md) and [Query History](https://docs.singlestore.com/cloud/query-data/query-tuning/query-history.md) to track queries run by Aura Analyst, including slow-performing queries.

## Share a Chat

You can share an Aura Analyst chat with other users in your organization, enabling them to review the conversation and its associated insights.

To share a chat:

1. Open a chat that includes at least one assistant response.

2. Select **Share** from the right top of the chat.

3. Copy the generated link and share it with the users who need access.

> **📝 Note**: - The shared chat is a snapshot of the conversation up to the most recent assistant response at the time of sharing. It does not update if the chat continues.
> - Shared chats are not public. A user can access a shared link only if the following conditions are met:
>
>   * The user is signed in as a member of the same organization that owns the chat.
>   * The user has permission to use the Aura Analyst domain associated with the chat.
> - Users who do not meet these conditions see an access denied message.
> - Sharing a chat link is separate from other sharing features in Aura Analyst. It does not affect the following:
>
>   * Saving or sharing charts to dashboards
>   * Domain access or domain sharing settings in **Domain settings**

## Continue a Shared Chat

When a user opens a shared link, the conversation appears in **read-only** mode.

To continue working from that conversation:

1. Select **Continue conversation** at the bottom of the page.

2. Aura Analyst creates a new chat session that copies the shared conversation.

New messages in this session do not affect the original chat or the shared snapshot.

## 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.](https://images.contentstack.io/v3/assets/bltac01ee6daa3a1e14/blt1346d433d5114b76/6a3ad3a375bd40f7c6a72963/Screenshot_2025-09-30_at_7_54_13_AM-FYAXHx.png)

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

![](https://images.contentstack.io/v3/assets/bltac01ee6daa3a1e14/bltdd3c4b4cf5f418ef/6a3ad3277c9b6bd32ea8ad0f/saasusage-3Qyy9c.gif)

## 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.](https://images.contentstack.io/v3/assets/bltac01ee6daa3a1e14/bltc4c83f4cbfa6038c/6a3ad353b8c8ed937582ea9d/Screenshot_2025-09-30_at_7_55_08_AM-brqyWq.png)

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

![](https://images.contentstack.io/v3/assets/bltac01ee6daa3a1e14/bltfd9f3cdb8a55097d/6a3ad33ce3036bf138dedb4b/marketing_analytics-4FIm8G.gif)

***

Modified at: April 17, 2026

Source: [/cloud/ai/aura-analyst/](https://docs.singlestore.com/cloud/ai/aura-analyst/)

(An index of the documentation is available at /llms.txt)