Informat AI Low-Code Docs

English

简体中文

English

简体中文

Appearance

AI Data Agent ​

Overview ​

The AI Data Agent is an intelligent assistant focused on data querying and analysis, helping users quickly retrieve and analyze data table information within applications. Through natural language interaction, users can easily query data table lists, retrieve specific records, and perform data statistical analysis without writing complex query statements. Whether for daily data viewing, business data analysis, or data verification, the AI Data Agent provides convenient and efficient support.

Core Capabilities ​

1. Data Table Information Retrieval ​

  • Network Capability: Retrieve a list of all data tables in the current application
  • Basic Information Display: View basic information such as table names, field structures, and record counts
  • Quick Location: Help users quickly understand the data structure layout of the application

2. Flexible Data Querying ​

  • Conditional Filtering: Support filtering data records by single or multiple conditions
  • Pagination: Support paginated display when handling large amounts of data, improving query efficiency
  • Sorting: Sort data in ascending or descending order by specified fields
  • Data Grouping: Group and display data by specific fields
  • Aggregate Statistics: Support operations such as sum, count, average, maximum, and minimum

3. Natural Language Interaction ​

  • Simple Queries: Describe query requirements in everyday language, such as "show all incomplete orders"
  • Complex Analysis: Perform multi-condition combination queries and data analysis through conversation
  • Result Interpretation: AI interprets and explains query results to help understand data meaning

Using the AI Data Agent ​

In the [Data Agent] page, enter your query requirements directly in the dialog box. The AI will automatically understand and execute the corresponding data operations.

Application Cases ​

1. Query Data Table List ​

  • Use Case: Quickly understand what data tables the current application contains and their basic information
  • Example:
    • Input: "Show all data tables"
    • Input: "What tables does this application have?"
    • AI will return the data table list, including table names, field counts, etc.

2. Query Data Records by Conditions ​

  • Use Case: Need to find data records that meet specific conditions
  • Example:
    • Input: "Query all tasks with status 'In Progress'"
    • Input: "Show customer information added this month"
    • Input: "Find orders with amounts greater than 10000"
    • AI will filter and return records that meet the requirements

3. Data Statistics and Analysis ​

  • Use Case: Need to perform statistical analysis on data to understand business metrics
  • Example:
    • Input: "Count the number of employees in each department"
    • Input: "Calculate total sales for this quarter"
    • Input: "View the average price by product category"
    • AI will perform the corresponding aggregate calculations and return statistical results

4. Sorting and Pagination Queries ​

  • Use Case: Need to view data in a specific order, or handle large amounts of data records
  • Example:
    • Input: "Show the 10 most recent orders sorted by creation time in descending order"
    • Input: "Show the top 5 customers by sales amount"
    • Input: "Display all products with pagination, 20 per page"
    • AI will sort and paginate the data as requested

5. Combined Queries ​

  • Use Case: Need to combine multiple conditions for complex data queries
  • Example:
    • Input: "Query completed orders from Q4 2024 with amounts over 5000, sorted by amount in descending order"
    • Input: "Count customer numbers by region, filter regions with more than 100 customers"
    • AI will understand complex requirements and execute multi-condition combined queries

Usage Tips ​

  • Clarify query objectives: Describe the data and conditions you need to query as clearly as possible
  • Query in steps: For complex requirements, refine query conditions gradually through multiple conversations
  • Leverage statistical features: Make good use of aggregate statistical features to quickly gain business insights
  • Verify query results: For important data queries, it's recommended to verify the accuracy of results

Important Notes ​

  • The AI Data Agent can only read and analyze data; it cannot modify or delete data records
  • Query results are based on real-time data of the current application
  • For queries involving large amounts of data, it's recommended to use pagination to improve performance
  • Complex data analysis requirements may need multiple rounds of dialogue to complete