Application Scenarios

Scenario 1: AI Calls Mcp Server to Aggregate Query Data Tables via Natural Language

• 1. Q: Query the top five employees with the highest total salary in 2024 and their total salary for 2024
• 2. AI: Call the Mcp Server to query all data tables to find the salary payment record table
• 3. AI: Call the Mcp Server to query the data table definition to obtain all field information of the salary payment record table
• 4. AI: Call the Mcp Server to query the data table record list, aggregate query the salary payment record table with the following parameters:

{
  "tableId":"wvq5gv0tu382k",
  "filter":{
    "conditionList":[
      {
        "fieldId":"year",
        "opt":"eq",
        "value":2024
      }
    ],
    "opt":"and"
  },
  "groupByList":[
    "staff_rel"
  ],
  "aggregationQueryList":[
    {
      "fieldId":"salary",
      "func":"sum"
    }
  ],
  "orderByList":[
    {
      "field":"salary$sum",
      "type":"desc"
    }
  ],
  "pageIndex":1,
  "pageSize":5
}

The Mcp Server return value is as follows:

[
  {
    "staff_rel":"b2h5lhol2rj52",
    "salary_sum":616649,
    "staff_rel_name":"Zhang San"
  },
  {
    "staff_rel":"ml8wvql82lwe6",
    "salary_sum":539649,
    "staff_rel_name":"Li Si"
  },
  {
    "staff_rel":"ar76k1emx4nlv",
    "salary_sum":442750,
    "staff_rel_name":"Wang Wu"
  },
  {
    "staff_rel":"in5w8j6rt3lit",
    "salary_sum":258500,
    "staff_rel_name":"Zhao Liu"
  },
  {
    "staff_rel":"z9bsl6guwk7jr",
    "salary_sum":253333,
    "staff_rel_name":"Chen Jiu"
  }
]

• 5. Q: Display it as a bar chart
• 6. AI: Call the tool to render HTML

• 7. The video is as follows

Scenario 2: DeepSeek R1 Deep Thinking

DeepSeek Supporting Local Private Deployment

Scenario 3: Recognize Attached Invoices and Automatically Write Data to Forms

Scenario 4: AI Quick Table Creation

Scenario 5: AI Recognizes PDF and Word Files

Scenario 6: AI Generates Informat Scripts

Scenario 7: AI Batch Generates Data Tables