应用场景

场景1：AI通过自然语言调用Mcp Server聚合查询数据表

1.问：查询2024年薪资总和最高的五位员工以及他们2024年的薪资总和
2.AI：调用mcp server 查询所有数据表找到薪资发放记录表
3.AI：调用mcp server 查询数据表定义得到薪资发放记录表所有字段信息
4.AI：调用mcp server 查询数据表记录列表聚合查询薪资发放记录表参数如下：

json

{
  "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
}

mcp server 返回值如下：

json

[
  {
    "staff_rel":"b2h5lhol2rj52",
    "salary_sum":616649,
    "staff_rel_name":"张三"
  },
  {
    "staff_rel":"ml8wvql82lwe6",
    "salary_sum":539649,
    "staff_rel_name":"李四"
  },
  {
    "staff_rel":"ar76k1emx4nlv",
    "salary_sum":442750,
    "staff_rel_name":"王五"
  },
  {
    "staff_rel":"in5w8j6rt3lit",
    "salary_sum":258500,
    "staff_rel_name":"赵六"
  },
  {
    "staff_rel":"z9bsl6guwk7jr",
    "salary_sum":253333,
    "staff_rel_name":"陈九"
  }
]