SynxDB AI Bot - Data

SynxDB AI Bot - Data (or AI Bot - Data) is the intelligent data analysis platform for SynxDB Cloud. It combines advanced natural language processing (NLP) with powerful database querying capabilities to democratize data access. By enabling users to interact with data using natural language, AI Bot - Data transforms how organizations analyze, visualize, and report on their data assets across multiple database systems.

Note

For instructions on creating and managing SynxML instances via the DBaaS Admin Console, see Manage AI Platforms.
AI Bot - Data is only available when enable-data-mind is set to true in the deployment configuration. For details, see Deploy SynxDB Cloud.

Core scenarios & user value

AI Bot - Data empowers enterprises to bridge the gap between complex data structures and business insights:

Democratized data access: Enable non-technical users to query data directly using natural language (Text-to-SQL), removing the bottleneck of dependency on data analysts.
Accelerated insight delivery: Automate the generation of comprehensive reports and visualizations, reducing the time from question to insight from hours to minutes.
Unified analysis: Connect and query across multiple database systems (PostgreSQL, MySQL, Oracle, Hive) from a single intelligent interface.

Key capabilities

Intelligent analysis: Advanced NLP engine that understands context, synonyms, and ambiguity to generate optimized SQL queries.
Automated visualization: Automatically selects and generates the most appropriate charts (Line, Bar, Pie, Scatter, etc.) based on query results.
Enterprise management: Comprehensive data governance features including data dictionary management, semantic views, and granular access control.

How to use

Analyze data

The Chat interface is the primary workspace for interacting with your data. It supports natural language queries, multi-turn conversations, and interactive visualizations.

Start intelligent chat

You can start analyzing your data immediately by asking questions in plain language. The interface allows you to select different AI models to tailor the analysis depth and speed.

To start a chat:

Select an AI model: Click the model selector in the left sidebar (for example, Qwen3-8B, Deepseek V3, or Qwen3 Max) to choose the reasoning engine that best fits your needs.
Select database: Click the list icon to the right of the input box to choose your target data source.
Enter query: Type your question in the input box at the bottom of the main window.
- Example: “Show order range for order_date in orders table.”
- You can also simply say “Hi” to start a conversation.
View process: The system (Assistant) displays the reasoning steps:
- Analyzing query type (for example, SYSTEM_QUERY).
- Generating SQL: View the generated SQL code in a code block.
- Executing SQL query: Watch the execution status.
View result: The final answer is presented clearly, often accompanied by a findings summary or a data table (for example, min_order_date: 1996-07-04, max_order_date: 1998-05-06).

Visualize results

AI Bot - Data automatically generates charts to help you understand trends and patterns. You can hover over data points to see detailed values.

Manage sessions

Your analysis history is preserved to maintain context and allow for continuity.

Use the sidebar to browse your history (grouped by “Today”, “Last 7 Days”) or start a new conversation.

Click + New Chat (or the Plus icon) to reset the context.
Click on a specific topic (for example, “orders table order_date…”) to resume a past analysis.

Generate reports

You can create comprehensive, structured reports to share insights with stakeholders.

To generate a report:

Navigate to the Report section.
Enter a prompt describing the report requirements (for example, “Generate a monthly sales performance report including regional breakdown and top products”).
The system will plan the analysis, execute necessary queries, and compile the findings.
Review the generated report, which includes an executive summary, data sources, detailed analysis with charts, and conclusions.

Manage data configurations

You can access advanced data configuration tools by clicking the Settings (Gear icon) in the left sidebar.

Manage data dictionary

The Data Dictionary allows you to index specific columns to help the AI understand the unique values (categorical data) within your tables. This is crucial for correctly interpreting user queries that reference specific entities like region names or product categories.

Select Data Dictionary from the settings menu.
Select Database: Choose your target database (for example, northwind) from the dropdown menu.
Add dictionary index:
- Click + ADD.
- In the “Add Dictionary” dialog, select the Table (for example, suppliers) and the specific Column (for example, phone) you want to index.
- Click SUBMIT.
View and manage:
- The new entry appears in the list.
- Click VIEW to open the Dictionary Details panel and see the “Unique Values List” (for example, Western, Southern).
- Use REFRESH to update the index if the underlying data changes.
- Click DELETE to remove the index.

Configure custom tools

Define specific SQL functions or tools that the AI can invoke to answer complex questions.

Select Custom Tools from the settings menu.
Select Database: Choose the target database from the dropdown menu.
Add new tool:
- Click + ADD.
- In the “Add Tool” panel, configure the following:
  - Tool Name: Enter a unique name for the tool.
  - Tool Description: Provide a clear description of what the tool does, which helps the AI understand when to use it.
  - Tool SQL Template: Define the parameterized SQL query.
  - Tool Parameters: Define the input parameters required by the template.
- Click SAVE.

Define metrics and dimensions

Create semantic layers to simplify data access for business users.

Select Metrics & Dimensions from the settings menu.
Select Database: Choose the target database from the dropdown menu.
Add new metric:
- Click + ADD.
- In the “Add Metric” panel, configure the following:
  - Metric Name: Enter a unique identifier (for example, Monthly Recurring Revenue).
  - Description: Describe the metric’s purpose.
  - Formula: Enter the SQL calculation (for example, SUM(revenue) / COUNT(*)).
  - Base Table: Select the primary table for the metric.
  - Time Column: Select the column representing time for time-series analysis.
- Add Dimensions:
  - Select Dimension Table and Column.
  - Define the Join Path (From Table/Column -> To Table/Column).
  - Click ADD DIMENSION.
- Click SAVE.

Manage terminology

Input specific industry jargon or business logic notes to refine the AI’s domain knowledge.

Select Terminology, Jargon & Notes from the settings menu.
Select Database: Choose the target database from the dropdown menu.
Add new terminology:
- Click + ADD.
- In the “Add Terminology” panel, configure the following:
  - Business Term Name: Enter the specific term (for example, Churn Rate).
  - Category: Classify the term (for example, selected Business Terms).
  - Definition: Provide a business explanation for the term.
  - SQL Expression: Define the SQL logic for the term manually or generate it based on the selected table/column.
- Click ADD.
Manage: You can View, Edit, or Delete existing terminology from the list.

Administer system

Administrators can manage users and database connections from the dedicated management interface.

Manage users

Click the User Management (Person icon) in the left sidebar.
View users: See a list of all registered users with their Name, Email, Role (Admin/User), Status (Active), and Created At timestamp.
Add user:
- Click + ADD.
- Enter the Name, Email, and Password.
- Select a Role (for example, User) and Status (for example, Active).
- Click ADD.
Edit/Delete: Use the Edit (Pencil) or Delete (Trash) icons to manage existing accounts.
Refresh connections: Click REFRESH DB CONNECTIONS to update the system’s awareness of available database sources.