ai_business_tools_seed.sql 151 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173
  1. -- ============================================================================
  2. -- 案件数据分析业务工具种子(迁移自旧 module.agent 工具集)
  3. --
  4. -- 工具实现:com.zsjz.ai.module.ai.core.agent.tools.business.BusinessToolCatalog
  5. -- 说明:
  6. -- 1) 旧 Agent 的领域分析工具与基础设施工具,共 69 个(get_current_workspace 已按业务要求移除);
  7. -- 2) execute_sql / render_chart / render_graph / get_case_graph 已按业务要求移除;
  8. -- 3) tool_code = impl_name = 旧 @Tool 名称,参数 Schema 由 AgentScope 反射生成;
  9. -- 4) 新增内置专家「案件数据分析专家」,绑定全部工具(写工具 decision=0,expert_write_enabled=1)。
  10. -- ============================================================================
  11. -- 一、业务工具
  12. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100001, 'get_call_records', '查询通话明细', '查询通话原始明细(一行一通);按姓名/号码/主被叫/类型/基站/日期筛选。只要通话次数/汇总,改用当前工具列表中的通话汇总工具,不要用本工具逐条拉全量。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"callDirection":{"type":"string","description":"主被叫标识,取值「主叫」或「被叫」,精确匹配"},"callType":{"type":"string","description":"通话类型(如「本地」「长途」「漫游」等),精确匹配"},"endDate":{"type":"string","description":"通话日期上限,格式 yyyy-MM-dd(含当天)"},"operatorId":{"type":"string","description":"运营商,模糊匹配(LIKE %值%)"},"otherName":{"type":"string","description":"对方姓名,精确匹配;查「未知对手」传「未知对手」"},"otherPhones":{"description":"对方号码,可传多个(OR 关系);查「未知号码」传「未知号码」","type":"array","items":{"type":"string","description":"对方号码,可传多个(OR 关系);查「未知号码」传「未知号码」"}},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500(用户可在前端表格翻页看全部)"},"personCellId":{"type":"string","description":"本方基站小区号(CELL),精确匹配"},"personCertNo":{"type":"string","description":"本方证件号码,精确匹配"},"personName":{"type":"string","description":"本方(机主)姓名,精确匹配,如「张三」"},"personPhoneArea":{"type":"string","description":"本方号码归属地,精确匹配"},"personPhones":{"description":"本方号码,可传多个(OR 关系);通常由 personName 已能定位","type":"array","items":{"type":"string","description":"本方号码,可传多个(OR 关系);通常由 personName 已能定位"}},"personRegionId":{"type":"string","description":"本方基站大区号(LAC),精确匹配"},"startDate":{"type":"string","description":"通话日期下限,格式 yyyy-MM-dd(含当天)"}},"description":"通话记录筛选条件,字段全部可选(但至少要能定位到人/号码/时段)"}},"required":["query"]}', 'get_call_records', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  13. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100003, 'get_eds_applications', '已安装应用', '查询电子数据包里终端的已安装应用列表:软件名称、类型、版本、安装路径、包名、签名、安装时间、最后修改时间、删除状态。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"collectTargetId":{"type":"string","description":"电子数据包的采集目标编号(cid)。可选:不传时自动合并当前案件全部已解析数据包(多包结果带 collectTargetId/packageName 来源列);只想看某个包时再传。可先调用 list_eds_packages 获取。"},"keyword":{"type":"string","description":"软件名称或应用包名关键词,模糊匹配;如「微信」「com.tencent.mm」"}},"description":"应用筛选条件;collectTargetId/keyword 均可选"}},"required":["query"]}', 'get_eds_applications', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  14. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100004, 'get_eds_call_records', '通话记录', '查询电子数据包的通话记录(一行一通电话),可按本方号码、对方号码、时间范围筛选;返回本方号码、对方号码、通话开始时间、通话时长(秒)、通话状态、收发方向、删除状态。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"account":{"type":"string","description":"本方(机主)号码,精确匹配;不传表示不限制本方号码"},"collectTargetId":{"type":"string","description":"电子数据包的采集目标编号(cid)。可选:不传时自动合并当前案件全部已解析数据包(多包结果带 collectTargetId/packageName 来源列);只想看某个包时再传。可先调用 list_eds_packages 获取。"},"endDate":{"type":"string","description":"结束日期/时间,格式 yyyy-MM-dd 或 yyyy-MM-dd HH:mm:ss(只传日期时含当天 23:59:59)"},"friendAccount":{"type":"string","description":"对方号码,精确匹配;查与某人的通话时传"},"startDate":{"type":"string","description":"开始日期/时间,格式 yyyy-MM-dd 或 yyyy-MM-dd HH:mm:ss(只传日期时含当天 00:00:00)"}},"description":"通话筛选条件;字段全部可选,但建议至少给号码或时间范围"}},"required":["query"]}', 'get_eds_call_records', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  15. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100005, 'get_eds_case_info', '案件信息', '查询电子数据包的案件/检材基本信息:案件编号、案件名称、案件类型、采集时间、设备厂商/型号、检材名称、采集人警号、被采集人姓名/证件/出生日期/户籍地址,以及手机号(msisdn)、IMSI、ICCID 等。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"collectTargetId":{"type":"string","description":"电子数据包的采集目标编号(cid)。可选:不传时自动合并当前案件全部已解析数据包(多包结果带 collectTargetId/packageName 来源列);只想看某个包时再传。可先调用 list_eds_packages 获取。"}},"description":"数据包定位条件;collectTargetId 可选(不传=全部数据包)"}},"required":["query"]}', 'get_eds_case_info', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  16. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100006, 'get_eds_catalog', '读取电子数据目录树', '读取电子数据包的目录树(电子数据浏览器左侧那棵树),返回每个数据节点的dtId、名称、层级、appType(应用类型编码)、appTypeName(应用类型中文名)、account(账号)、记录数与已删除数。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"collectTargetId":{"type":"string","description":"电子数据包的采集目标编号(cid)。可选:不传时自动合并当前案件全部已解析数据包(多包结果带 collectTargetId/packageName 来源列);只想看某个包时再传。可先调用 list_eds_packages 获取。"}},"description":"数据包定位条件;collectTargetId 可选(不传=全部数据包)"}},"required":["query"]}', 'get_eds_catalog', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  17. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100007, 'get_eds_chat_account_info', '即时通信账号信息', '查询电子数据包里即时通信应用的账号信息:账号、昵称、密码、姓名、性别、生日、手机号、邮箱、证件、注册城市/时间、最后登录时间等。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"account":{"type":"string","description":"本机即时通信账号。可选:不传时自动展开目录树里该应用下的全部账号。"},"appType":{"type":"string","description":"即时通信应用类型编码(目录树节点上的 appType)。可选:不传时自动展开目录树里的全部即时通信应用。"},"collectTargetId":{"type":"string","description":"电子数据包的采集目标编号(cid)。可选:不传时自动合并当前案件全部已解析数据包(多包结果带 collectTargetId/packageName 来源列);只想看某个包时再传。可先调用 list_eds_packages 获取。"}},"description":"账号定位条件;collectTargetId/account/appType 均可选"}},"required":["query"]}', 'get_eds_chat_account_info', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  18. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100008, 'get_eds_chat_friends', '即时通信好友', '查即时通信好友:不传 friendAccount 返回好友清单,传则查指定好友详情;可按分组、删除状态筛选。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"account":{"type":"string","description":"本机即时通信账号。可选:不传时自动展开目录树里该应用下的全部账号。"},"appType":{"type":"string","description":"即时通信应用类型编码(目录树节点上的 appType)。可选:不传时自动展开目录树里的全部即时通信应用。"},"collectTargetId":{"type":"string","description":"电子数据包的采集目标编号(cid)。可选:不传时自动合并当前案件全部已解析数据包(多包结果带 collectTargetId/packageName 来源列);只想看某个包时再传。可先调用 list_eds_packages 获取。"},"friendAccount":{"type":"string","description":"好友账号,精确匹配;传了只返回该好友(仍需遍历分组定位)"},"friendGroup":{"type":"string","description":"好友分组名称;不传则遍历该账号下的全部分组"}},"description":"好友筛选条件;collectTargetId/account/appType/friendGroup/friendAccount 均可选"}},"required":["query"]}', 'get_eds_chat_friends', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  19. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100009, 'get_eds_chat_groups', '即时通信群组', '查询电子数据包里即时通信账号的群聊列表:群号、群名称、消息数(或成员数)、已删除数。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"account":{"type":"string","description":"本机即时通信账号。可选:不传时自动展开目录树里该应用下的全部账号。"},"appType":{"type":"string","description":"即时通信应用类型编码(目录树节点上的 appType)。可选:不传时自动展开目录树里的全部即时通信应用。"},"collectTargetId":{"type":"string","description":"电子数据包的采集目标编号(cid)。可选:不传时自动合并当前案件全部已解析数据包(多包结果带 collectTargetId/packageName 来源列);只想看某个包时再传。可先调用 list_eds_packages 获取。"}},"description":"账号定位条件;collectTargetId/account/appType 均可选"}},"required":["query"]}', 'get_eds_chat_groups', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  20. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100010, 'get_eds_chat_messages', '聊天记录', '查询电子数据包里某个即时通信账号的聊天记录(一行一条),可按会话类型、好友账号/群号、内容关键词、时间范围筛选;返回本方/对方账号、昵称、备注、聊天内容、收发方向、发送时间、媒体类型、删除状态。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"account":{"type":"string","description":"本机即时通信账号。可选:不传时自动展开目录树里该应用下的全部账号。"},"appType":{"type":"string","description":"即时通信应用类型编码(目录树节点上的 appType)。可选:不传时自动展开目录树里的全部即时通信应用。"},"chatType":{"type":"integer","description":"会话类型:1 好友私聊(默认),2 群聊"},"collectTargetId":{"type":"string","description":"电子数据包的采集目标编号(cid)。可选:不传时自动合并当前案件全部已解析数据包(多包结果带 collectTargetId/packageName 来源列);只想看某个包时再传。可先调用 list_eds_packages 获取。"},"endDate":{"type":"string","description":"结束日期/时间,格式 yyyy-MM-dd 或 yyyy-MM-dd HH:mm:ss(只传日期时含当天 23:59:59)"},"friendAccount":{"type":"string","description":"对方账号:好友私聊传好友账号,群聊传群号。必填;好友账号可从 get_eds_chat_friends 获取,群号可从 get_eds_chat_groups 获取。"},"keyword":{"type":"string","description":"聊天内容关键词,模糊匹配(包含即命中)"},"startDate":{"type":"string","description":"开始日期/时间,格式 yyyy-MM-dd 或 yyyy-MM-dd HH:mm:ss(只传日期时含当天 00:00:00)"}},"required":["friendAccount"],"description":"聊天记录筛选条件;friendAccount 必填"}},"required":["query"]}', 'get_eds_chat_messages', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  21. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100011, 'get_eds_contacts', '通讯录', '查询电子数据包的通讯录:联系人序号、姓名、电话号码(多个号码以逗号分隔)、邮箱、删除状态与删除时间。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"collectTargetId":{"type":"string","description":"电子数据包的采集目标编号(cid)。可选:不传时自动合并当前案件全部已解析数据包(多包结果带 collectTargetId/packageName 来源列);只想看某个包时再传。可先调用 list_eds_packages 获取。"},"keyword":{"type":"string","description":"联系人姓名、电话号码或邮箱关键词,模糊匹配"}},"description":"通讯录筛选条件;collectTargetId/keyword 均可选"}},"required":["query"]}', 'get_eds_contacts', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  22. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100012, 'get_eds_geography_locations', '地理定位记录', '查询电子数据包的地理/出行应用定位记录:定位时间、城市代码、地址、经度、纬度、海拔、删除状态。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"appType":{"type":"string","description":"地理/出行应用类型编码(目录树节点上的 appType)。可选:不传时自动展开目录树里的全部地理/出行应用。"},"collectTargetId":{"type":"string","description":"电子数据包的采集目标编号(cid)。可选:不传时自动合并当前案件全部已解析数据包(多包结果带 collectTargetId/packageName 来源列);只想看某个包时再传。可先调用 list_eds_packages 获取。"},"endDate":{"type":"string","description":"结束日期/时间,格式 yyyy-MM-dd 或 yyyy-MM-dd HH:mm:ss(只传日期时含当天 23:59:59)(按定位时间在工具内过滤)"},"startDate":{"type":"string","description":"开始日期/时间,格式 yyyy-MM-dd 或 yyyy-MM-dd HH:mm:ss(只传日期时含当天 00:00:00)(按定位时间在工具内过滤)"}},"description":"定位筛选条件;collectTargetId/appType/startDate/endDate 均可选"}},"required":["query"]}', 'get_eds_geography_locations', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  23. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100013, 'get_eds_sms_records', '短信记录', '查询电子数据包的短信记录(一行一条),可按本方号码、对方号码、内容关键词、时间范围筛选;返回本方号码、对方号码、发送时间、短信内容、查看状态、收发方向、删除状态。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"account":{"type":"string","description":"本方(机主)号码,精确匹配;不传表示不限制本方号码"},"collectTargetId":{"type":"string","description":"电子数据包的采集目标编号(cid)。可选:不传时自动合并当前案件全部已解析数据包(多包结果带 collectTargetId/packageName 来源列);只想看某个包时再传。可先调用 list_eds_packages 获取。"},"endDate":{"type":"string","description":"结束日期/时间,格式 yyyy-MM-dd 或 yyyy-MM-dd HH:mm:ss(只传日期时含当天 23:59:59)"},"friendAccount":{"type":"string","description":"对方号码,精确匹配;查某个联系人的短信时传"},"keyword":{"type":"string","description":"短信内容关键词,模糊匹配(包含即命中)"},"startDate":{"type":"string","description":"开始日期/时间,格式 yyyy-MM-dd 或 yyyy-MM-dd HH:mm:ss(只传日期时含当天 00:00:00)"}},"description":"短信筛选条件;字段全部可选,但建议至少给号码或时间范围"}},"required":["query"]}', 'get_eds_sms_records', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  24. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100014, 'get_express_records', '查询快递明细', '查询快递原始明细(一行一张快递单):单号、收寄件人、电话、地址、寄件日期等。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"departurePlace":{"type":"string","description":"出发地,模糊匹配"},"destinationPlace":{"type":"string","description":"目的地,模糊匹配"},"ids":{"description":"快递记录 id 列表,取汇总结果里的 ids 列(逗号分隔,需自行拆成数组);不传则按其它条件查全量","type":"array","items":{"type":"string","description":"快递记录 id 列表,取汇总结果里的 ids 列(逗号分隔,需自行拆成数组);不传则按其它条件查全量"}},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500"},"recipientName":{"type":"string","description":"收件人姓名,模糊匹配"},"senderName":{"type":"string","description":"寄件人姓名,模糊匹配"}},"description":"快递明细筛选条件;建议传 ids 或姓名/地址条件"}},"required":["query"]}', 'get_express_records', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  25. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100015, 'get_file_sample', '读取材料正文片段', '读取某份非表格材料的正文片段(Tika 抽取的文本样本);fileId 从当前工具列表中的材料清单工具取。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"fileId":{"type":"integer","description":"材料 ID,必填;取自 list_file_profiles 返回表格的 fileId 列(或 stat 结果里对应分类下再列一次)"},"maxLength":{"type":"number","description":"最多返回多少字符,默认 2000,上限 4000(采集时定的样本上限就是 4000,传更大也只能拿到 4000)"}},"required":["fileId"],"description":"材料 ID 与返回长度"}},"required":["query"]}', 'get_file_sample', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  26. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100016, 'get_hotel_stay_detail', '旅馆住宿明细', '查旅馆住宿记录明细(一行一次入住):被调查对象与同住人在某家酒店的入住/退房时间、房间信息、疑似同住标记。问「某人和某人在某酒店住过几次、具体什么时间」时用本工具。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"hasTogether":{"type":"integer","description":"疑似同住标记:2=同时包含同行人住宿记录;不传则只查被调查对象本人"},"hotelName":{"type":"string","description":"酒店名称,必填且精确匹配;取同住汇总结果里的 hotelName 列"},"liveWithCertNo":{"type":"string","description":"同住人身份证号,精确匹配"},"liveWithName":{"type":"string","description":"同住人姓名,精确匹配;取同住汇总结果里的 liveWithName 列"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500"},"personName":{"type":"string","description":"被调查对象姓名,必填(系统按该姓名定位人员档案)"},"timeGap":{"type":"integer","description":"疑似同住的时间窗口(小时);不传则只统计确定同住"}},"required":["hotelName","personName"],"description":"旅馆住宿明细筛选条件;personName 与 hotelName 必填"}},"required":["query"]}', 'get_hotel_stay_detail', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  27. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100017, 'get_person_call_profile', '通话数据画像', '查询某人的通话画像:号码数/运营商、通话次数、对方号码数、日期范围、主被叫占比。personName 必传;只看汇总,逐通明细用当前工具列表中的话单明细工具。', '0', '{"type":"object","properties":{"personName":{"type":"string","description":"本方(机主)姓名,精确匹配,必传,如「张三」"}},"required":["personName"]}', 'get_person_call_profile', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  28. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100018, 'get_person_trans_profile', '交易数据画像', '查询某人的交易画像:卡数/银行、交易总额、收支、笔数、余额合计。personName 必传;明细用当前工具列表中的交易流水工具或其它分析工具。', '0', '{"type":"object","properties":{"personName":{"type":"string","description":"本方(机主)姓名,精确匹配,必传,如「张三」"}},"required":["personName"]}', 'get_person_trans_profile', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  29. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100019, 'get_together_live_info_detail', '同住服务记录明细', '查同住服务记录明细:基于「常住人口 + 同住服务」数据,返回某人与某同住人的同住次数、入住/退房时间等。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"hotelName":{"type":"string","description":"酒店名称,精确匹配;不传则同时匹配酒店名称为空或 null 的记录"},"inEndTime":{"type":"string","description":"入住时间上限,格式 yyyy-MM-dd HH:mm:ss"},"inStartTime":{"type":"string","description":"入住时间下限,格式 yyyy-MM-dd HH:mm:ss"},"liveWithCertNo":{"type":"string","description":"同住人身份证号,精确匹配;不传则同时匹配证件号为空或 null 的记录"},"liveWithName":{"type":"string","description":"同住人姓名,必填且精确匹配"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500"},"personName":{"type":"string","description":"被调查对象姓名,必填(系统按该姓名定位其同住服务数据)"}},"required":["liveWithName","personName"],"description":"同住服务明细筛选条件;personName 与 liveWithName 必填"}},"required":["query"]}', 'get_together_live_info_detail', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  30. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100020, 'get_trans_bank_card_info', '银行卡交易汇总', '按卡号汇总交易:收支、总额、笔数、最新余额、开户/销户信息。cardNoList 必传,bankName 建议传;最多 1 万行。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"bankName":{"type":"string","description":"银行名称,会原样回填到结果行的 bankName 列(如「工商银行」)"},"cardNoList":{"description":"要统计的银行卡号,可传多个,必填(至少一个)——底层 SQL 用 IN 展开,为空会报错","type":"array","items":{"type":"string","description":"要统计的银行卡号,可传多个,必填(至少一个)——底层 SQL 用 IN 展开,为空会报错"}},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500"}},"required":["cardNoList"],"description":"银行卡交易汇总条件,cardNoList 必传"}},"required":["query"]}', 'get_trans_bank_card_info', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  31. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100021, 'get_trans_records', '查询交易明细', '查询交易原始明细(一行一笔);按姓名/卡号/收付方向/金额/摘要/日期/现金筛选。汇总用当前工具列表中的交易统计工具,大额用其中的大额交易工具,不要用本工具逐笔拉全量。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"branchName":{"type":"string","description":"交易网点名称关键词,模糊匹配"},"cashOnly":{"type":"integer","description":"是否只看现金类交易:1=是(按「现金关键词」配置匹配交易扩展字段),不传=否"},"debitCreditFlag":{"type":"string","description":"收付方向,取值「收入」或「支出」,精确匹配"},"endDate":{"type":"string","description":"交易日期上限,格式 yyyy-MM-dd(含当天)"},"maxTransAmount":{"type":"number","description":"单笔金额上限(含)"},"minTransAmount":{"type":"number","description":"单笔金额下限(含)"},"otherCardNo":{"type":"string","description":"对方卡号,精确匹配;查「未知卡号」传「未知卡号」"},"otherName":{"type":"string","description":"对方姓名,精确匹配;查「未知对手」传「未知对手」"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500"},"personCardNo":{"type":"string","description":"本方银行卡号,精确匹配"},"personName":{"type":"string","description":"本方姓名,单值写法"},"personNames":{"description":"本方姓名,可传多个","type":"array","items":{"type":"string","description":"本方姓名,可传多个"}},"remark":{"type":"string","description":"备注关键词,模糊匹配"},"startDate":{"type":"string","description":"交易日期下限,格式 yyyy-MM-dd(含当天)"},"transAmount":{"type":"integer","description":"单笔金额阈值,配合 transAmountSymbol"},"transAmountSymbol":{"type":"string","description":"金额比较符,取值 GE(>=,默认) / LE(<=) / GT(>) / LT(<) / EQ(=)"},"transSummary":{"type":"string","description":"交易摘要关键词,模糊匹配(LIKE %值%)"}},"description":"交易明细筛选条件,字段全部可选(但至少要能定位到人/卡/时段)"}},"required":["query"]}', 'get_trans_records', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  32. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100022, 'get_travel_record_detail', '出行票务明细', '查询单条出行票务原始记录:按数据类型 + 主键返回该记录的全部字段(车次/航班号、出发到达站、时间、座位、证件号等)。问「这一条记录的完整信息」时用本工具。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"id":{"type":"string","description":"记录主键 id,必填;取同行明细结果里 id 列中「_」之后的纯数字部分"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50(本工具只返回单条记录,通常无需传)"},"type":{"type":"string","description":"数据类型,必填;取值 TOGETHER_FLIGHT(同航班)、TOGETHER_TRAIN(同火车)、RAIL_TICKET(铁路订票)、FLIGHT_TICKET(民航订票)、FLIGHT_DEPARTURE(民航离港)、CAR_TICKET(汽车票务)"}},"required":["id","type"],"description":"出行票务记录查询条件;type 与 id 必填"}},"required":["query"]}', 'get_travel_record_detail', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  33. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100023, 'list_eds_packages', '列出电子数据包', '列出当前案件已解析的电子数据包(手机取证 zip)及其采集编号 collectTargetId。', '0', '{"type":"object","properties":{}}', 'list_eds_packages', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  34. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100024, 'list_file_profiles', '检索材料清单', '检索非表格材料清单(txt/doc/pdf/ppt/压缩包),返回分类与摘要;看正文用当前工具列表中的材料正文工具。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"category":{"type":"string","description":"业务分类过滤,取值:TRANSACTION(交易) / STATISTICS(统计) / RECORD(笔录) / COMMUNICATION(通讯) / PERSON(人员) / DOCUMENT(文书) / OTHER(其他);也接受中文写法(如「笔录」)。不传表示不限分类"},"keyword":{"type":"string","description":"关键词,模糊匹配 文件名 / 摘要 / 关键词 三列(如「笔录」「银行流水」「合同」);不传表示不限"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500(用户可在前端表格翻页看全部)"},"parseStatus":{"type":"string","description":"识别状态过滤:SUCCESS(识别成功) / FAIL(识别失败) / PENDING(待识别) / RUNNING(识别中) / SKIP(已跳过);也接受中文写法(如「识别成功」)。不传表示不限(含识别失败与已跳过的记录,它们的 category / summary 为空)"}},"description":"筛选条件,全部可空(不传即查全部)"}},"required":["query"]}', 'list_file_profiles', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  35. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100025, 'list_persons', '列出案件人员', '列出案件全部对象人员及基本信息、名下号码与银行卡。无入参;问「本案有哪些人」时用本工具。', '0', '{"type":"object","properties":{}}', 'list_persons', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  36. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100026, 'list_tables', '列出数据表', '列出可查表及字段(模板表 + ai_clean_ 动态表 + wa_mforensics_ 取证表);已知表名看字段也用它,按语义找表用表结构检索工具(RAG 可用时)。', '0', '{"type":"object","properties":{}}', 'list_tables', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  37. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100027, 'query_table_data', '查询表格数据', '按「表名 + 条件」直查治理表;tableName 必填,conditions 为 {column,operator,value},支持 = != > >= < <= LIKE IS NULL/IS NOT NULL。复杂查询请拆分为多次条件查询,或使用其它已绑定工具。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"conditionRun":{"type":"string","description":"多条件连接符:AND(默认)或 OR"},"conditions":{"description":"过滤条件列表,每项 {column, operator, value};不传=取全量","type":"array","items":{"type":"object","properties":{"column":{"type":"string","description":"表列名(英文,必填;可用 list_tables 查询)"},"operator":{"type":"string","description":"比较符,必填;只能取 = != > >= < <= LIKE IS NULL IS NOT NULL"},"value":{"type":"string","description":"比较值;operator 为 IS NULL / IS NOT NULL 时不用传,其余比较符必填"}},"required":["column","operator"],"description":"过滤条件列表,每项 {column, operator, value};不传=取全量"}},"tableName":{"type":"string","description":"要查询的表英文名(必填,可用 list_tables 查询)"}},"required":["tableName"],"description":"查询对象,必填:tableName 必填(要查询的表英文名),conditions 可选(不传=取该表全量)"}},"required":["query"]}', 'query_table_data', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  38. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100028, 'search_table_schema', '检索表结构', '按语义检索表结构(模板表、ai_clean_ 动态表、wa_mforensics_ 取证表),返回表名/字段/注释;已知表名看字段用 list_tables。', '0', '{"type":"object","properties":{"query":{"type":"string","description":"自然语言查询,必填,例如:包含手机号和身份证号的表"},"top_k":{"type":"integer","description":"返回最相似的前 K 张表,默认 5"}},"required":["query"]}', 'search_table_schema', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  39. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100029, 'stat_call_continuous_detail', '持续通话明细', '统计持续联系的第二层明细:按「本方号码 + 对方姓名 + 对方号码」展开每对关系的连续通话起止月份与通话次数。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"endDate":{"type":"string","description":"通话日期上限,格式 yyyy-MM-dd(含当天)"},"monthVal":{"type":"integer","description":"连续月份阈值:只统计连续通话月数 ≥ 该值的对象,默认 2"},"otherName":{"type":"string","description":"对方姓名,精确匹配;查「未知对手」传「未知对手」"},"otherPhone":{"type":"string","description":"对方号码,精确匹配;查「未知号码」传「未知号码」"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500"},"personName":{"type":"string","description":"本方姓名,第二层(明细)下钻时用于定位某个人的持续联系明细"},"personNames":{"description":"本方(机主)姓名,可传多个;不传则统计全案所有对象人员","type":"array","items":{"type":"string","description":"本方(机主)姓名,可传多个;不传则统计全案所有对象人员"}},"startDate":{"type":"string","description":"通话日期下限,格式 yyyy-MM-dd(含当天)"}},"description":"持续联系明细筛选条件,字段全部可选"}},"required":["query"]}', 'stat_call_continuous_detail', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  40. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100030, 'stat_call_continuous_summary', '持续通话汇总', '统计持续联系(连续通话)的第一层汇总:找出「跨多个月份持续通话」的本方与对方组合,返回持续月份数、通话总次数、连续起止月份。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"endDate":{"type":"string","description":"通话日期上限,格式 yyyy-MM-dd(含当天)"},"monthVal":{"type":"integer","description":"连续月份阈值:只统计连续通话月数 ≥ 该值的对象,默认 2"},"otherName":{"type":"string","description":"对方姓名,精确匹配;查「未知对手」传「未知对手」"},"otherPhone":{"type":"string","description":"对方号码,精确匹配;查「未知号码」传「未知号码」"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500"},"personName":{"type":"string","description":"本方姓名,第二层(明细)下钻时用于定位某个人的持续联系明细"},"personNames":{"description":"本方(机主)姓名,可传多个;不传则统计全案所有对象人员","type":"array","items":{"type":"string","description":"本方(机主)姓名,可传多个;不传则统计全案所有对象人员"}},"startDate":{"type":"string","description":"通话日期下限,格式 yyyy-MM-dd(含当天)"}},"description":"持续联系筛选条件,字段全部可选"}},"required":["query"]}', 'stat_call_continuous_summary', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  41. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100031, 'stat_call_night_detail', '夜间通话明细', '统计夜间通话的第二层明细:在夜间时段内按「小时段」展开某个人与其对方的通话次数。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"endDate":{"type":"string","description":"通话日期上限,格式 yyyy-MM-dd(含当天)"},"monthVal":{"type":"integer","description":"连续月份阈值:只统计有夜间通话的月份数 ≥ 该值的对象,默认 2"},"nightEnd":{"type":"integer","description":"夜间时段结束小时(0-23),默认 6;小于起始小时表示跨零点(如 18 到次日 6)"},"nightStart":{"type":"integer","description":"夜间时段起始小时(0-23),默认 18"},"otherName":{"type":"string","description":"对方姓名,精确匹配;查「未知对手」传「未知对手」"},"otherPhone":{"type":"string","description":"对方号码,精确匹配;查「未知号码」传「未知号码」"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500"},"personName":{"type":"string","description":"本方姓名(单值写法)。明细工具:与 personNames 至少传一个,用于定位某个人的夜间通话明细;汇总统计:作为 personNames 的替代写法"},"personNames":{"description":"本方(机主)姓名,可传多个(OR)。汇总统计不传则统计全案;明细工具要求 personNames 或 personName 至少传一个","type":"array","items":{"type":"string","description":"本方(机主)姓名,可传多个(OR)。汇总统计不传则统计全案;明细工具要求 personNames 或 personName 至少传一个"}},"startDate":{"type":"string","description":"通话日期下限,格式 yyyy-MM-dd(含当天)"}},"description":"夜间通话明细筛选条件,personName 或 personNames 至少传一个"}},"required":["query"]}', 'stat_call_night_detail', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  42. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100032, 'stat_call_night_summary', '夜间通话汇总', '统计夜间通话的第一层汇总:按「本方姓名 + 对方姓名 + 对方号码」汇总夜间通话次数与涉及月份数。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"endDate":{"type":"string","description":"通话日期上限,格式 yyyy-MM-dd(含当天)"},"monthVal":{"type":"integer","description":"连续月份阈值:只统计有夜间通话的月份数 ≥ 该值的对象,默认 2"},"nightEnd":{"type":"integer","description":"夜间时段结束小时(0-23),默认 6;小于起始小时表示跨零点(如 18 到次日 6)"},"nightStart":{"type":"integer","description":"夜间时段起始小时(0-23),默认 18"},"otherName":{"type":"string","description":"对方姓名,精确匹配;查「未知对手」传「未知对手」"},"otherPhone":{"type":"string","description":"对方号码,精确匹配;查「未知号码」传「未知号码」"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500"},"personName":{"type":"string","description":"本方姓名(单值写法)。明细工具:与 personNames 至少传一个,用于定位某个人的夜间通话明细;汇总统计:作为 personNames 的替代写法"},"personNames":{"description":"本方(机主)姓名,可传多个(OR)。汇总统计不传则统计全案;明细工具要求 personNames 或 personName 至少传一个","type":"array","items":{"type":"string","description":"本方(机主)姓名,可传多个(OR)。汇总统计不传则统计全案;明细工具要求 personNames 或 personName 至少传一个"}},"startDate":{"type":"string","description":"通话日期下限,格式 yyyy-MM-dd(含当天)"}},"description":"夜间通话筛选条件,字段全部可选"}},"required":["query"]}', 'stat_call_night_summary', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  43. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100033, 'stat_call_record_summary', '通话记录汇总', '按「本方号码+对方姓名+号码」统计某人的通话次数。personName 必传,可选 otherName/otherPhone/日期;逐通明细或号码排行用当前工具列表中的对应工具。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"endDate":{"type":"string","description":"通话日期上限,格式 yyyy-MM-dd(含当天)"},"otherName":{"type":"string","description":"对方姓名,精确匹配;查「对方信息缺失」的话单传「未知对手」"},"otherPhone":{"type":"string","description":"对方号码,精确匹配(单值)"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500"},"personName":{"type":"string","description":"本方(机主)姓名,精确匹配,必传,如「张三」"},"startDate":{"type":"string","description":"通话日期下限,格式 yyyy-MM-dd(含当天)"}},"required":["personName"],"description":"通话记录汇总条件,personName 必传"}},"required":["query"]}', 'stat_call_record_summary', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  44. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100034, 'stat_call_sensitive_detail', '敏感日期通话明细', '查询敏感日期(特殊日期/节假日)内的通话原始明细,返回话单并带上命中的节日名称,按通话时间倒序。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"endDate":{"type":"string","description":"通话日期上限,格式 yyyy-MM-dd(含当天)"},"otherName":{"type":"string","description":"对方姓名,精确匹配;查「未知对手」传「未知对手」"},"otherPhone":{"type":"string","description":"对方号码,精确匹配;查「未知号码」传「未知号码」"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500"},"personName":{"type":"string","description":"本方(机主)姓名,精确匹配;通常用第一层结果里的 personName"},"startDate":{"type":"string","description":"通话日期下限,格式 yyyy-MM-dd(含当天)"}},"description":"敏感日期通话明细筛选条件,建议至少传一个定位参数"}},"required":["query"]}', 'stat_call_sensitive_detail', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  45. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100035, 'stat_call_sensitive_summary', '敏感日期通话汇总', '统计敏感日期(案件配置的特殊日期/节假日)内的通话联系第一层:按「本方姓名 + 对方姓名 + 对方号码」汇总落在特殊日期内的通话次数,按次数降序。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"endDate":{"type":"string","description":"通话日期上限,格式 yyyy-MM-dd(含当天)"},"keyword":{"type":"string","description":"按对方姓名「或」对方号码精确匹配(单值,不是模糊搜索),用于只看某个特定对象;不传则返回全部对方"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500"},"personNames":{"description":"本方(机主)姓名,可传多个;不传则统计全案所有对象人员","type":"array","items":{"type":"string","description":"本方(机主)姓名,可传多个;不传则统计全案所有对象人员"}},"startDate":{"type":"string","description":"通话日期下限,格式 yyyy-MM-dd(含当天)"}},"description":"敏感日期联系筛选条件,字段全部可选"}},"required":["query"]}', 'stat_call_sensitive_summary', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  46. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100036, 'stat_express_by_phone', '按号码查快递', '按收/寄件人电话聚合快递地址:直接按号码查全量快递数据,返回每个「姓名 + 地址」的快递量、收件数、寄件数(ids 列为逗号分隔的记录 id)。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"endDate":{"type":"string","description":"寄件日期上限,格式 yyyy-MM-dd(含当天)"},"location":{"type":"string","description":"收/寄件地址,精确匹配(与汇总工具的模糊不同)"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500"},"personPhones":{"description":"收/寄件人号码,可传多个(OR 关系,精确匹配);不传则统计全量快递数据","type":"array","items":{"type":"string","description":"收/寄件人号码,可传多个(OR 关系,精确匹配);不传则统计全量快递数据"}},"startDate":{"type":"string","description":"寄件日期下限,格式 yyyy-MM-dd(含当天)"}},"description":"快递按号码聚合筛选条件;建议至少传 personPhones"}},"required":["query"]}', 'stat_express_by_phone', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  47. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100037, 'stat_express_summary', '快递收寄汇总', '按「人员 + 地址」汇总快递收寄情况:返回每个人在每个地址的快递总量、收件数、寄件数,并给出该组合对应的记录 id 集合(ids 列)。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"endDate":{"type":"string","description":"寄件日期上限,格式 yyyy-MM-dd(含当天)"},"location":{"type":"string","description":"收/寄件地址关键词,包含即命中(在聚合结果上做内存过滤)"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500"},"personNames":{"description":"本方(机主)姓名,可传多个(OR 关系,精确匹配);不传则统计案件内全部人员","type":"array","items":{"type":"string","description":"本方(机主)姓名,可传多个(OR 关系,精确匹配);不传则统计案件内全部人员"}},"startDate":{"type":"string","description":"寄件日期下限,格式 yyyy-MM-dd(含当天)"}},"description":"快递汇总筛选条件,字段全部可选"}},"required":["query"]}', 'stat_express_summary', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  48. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100038, 'stat_file_profiles_by_category', '材料分类统计', '按业务分类统计非表格材料的数量分布,用于先摸清案件材料构成。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"parseStatus":{"type":"string","description":"只统计该识别状态的记录,取值同上(SUCCESS / FAIL / PENDING / RUNNING / SKIP);不传表示统计全部"}},"description":"筛选条件,可空(不传即统计全部)"}},"required":["query"]}', 'stat_file_profiles_by_category', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  49. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100039, 'stat_intimacy_summary', '亲密度总览', '汇总某人的亲密度:八类行为按关系人合并,返回分值、命中标签、行为计数,按分值降序,最多 100 人。personName 必传;明细用对应 stat_intimacy 工具。', '0', '{"type":"object","properties":{"personName":{"type":"string","description":"本方(机主)姓名,精确匹配,必传,如「张三」"}},"required":["personName"]}', 'stat_intimacy_summary', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  50. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100040, 'stat_person_call_station', '通话基站分布', '按基站汇总某人的通话分布:通话次数、基站名称、经纬度。personName 必传;无日期条件。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500(用户可在前端表格翻页看全部)"},"personName":{"type":"string","description":"本方(机主)姓名,精确匹配,必传,如「张三」"}},"required":["personName"],"description":"基站统计条件,字段全部可选(personName 必传)"}},"required":["query"]}', 'stat_person_call_station', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  51. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100041, 'stat_person_call_top10', '最常联系人 TOP10', '按对方号码统计某人的通话次数排行。personName 必传,日期可选;综合汇总用当前工具列表中的通话汇总工具。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"endDate":{"type":"string","description":"通话日期上限,格式 yyyy-MM-dd(含当天)"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500"},"personName":{"type":"string","description":"本方(机主)姓名,精确匹配,必传,如「张三」"},"startDate":{"type":"string","description":"通话日期下限,格式 yyyy-MM-dd(含当天)"}},"required":["personName"],"description":"常联系对象统计条件,personName 必传"}},"required":["query"]}', 'stat_person_call_top10', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  52. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100042, 'stat_person_trans_top10', '最常交易对手 TOP10', '按对方姓名/卡号/IP/MAC/网点统计某人的交易对手排行(笔数、金额、收支)。personName 必传;可用 transCount/transAmount 设阈值。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"dimension":{"type":"string","description":"排序指标,取值「交易金额」(默认,按交易总金额降序)或「交易次数」(按交易笔数降序)"},"endDate":{"type":"string","description":"交易日期上限,格式 yyyy-MM-dd(含当天)"},"indicator":{"type":"string","description":"按哪个字段聚合交易对手,取值:personName(交易对方姓名,默认)/ otherCardNo(对方卡号)/ personIpAddress(IP 地址)/ personMacAddress(MAC 地址)/ branchName(交易网点名称)"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500"},"personName":{"type":"string","description":"本方(机主)姓名,精确匹配,必传,如「张三」"},"startDate":{"type":"string","description":"交易日期下限,格式 yyyy-MM-dd(含当天)"},"transAmount":{"type":"number","description":"交易金额阈值(元),配合 transAmountSymbol 使用"},"transAmountSymbol":{"type":"string","description":"交易金额比较符号,取值 ge(>=) / le(<=) / gt(>) / lt(<) / eq(=),默认 ge"},"transCount":{"type":"integer","description":"交易次数阈值,配合 transCountSymbol 使用(如「交易次数 >= 3」)"},"transCountSymbol":{"type":"string","description":"交易次数比较符号,取值 ge(>=) / le(<=) / gt(>) / lt(<) / eq(=),默认 ge"}},"required":["personName"],"description":"常交易对象统计条件,personName 必传"}},"required":["query"]}', 'stat_person_trans_top10', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  53. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100043, 'stat_together_live_detail', '同住关系明细', '查同住关系明细(一行一条同住关系):被调查对象、同住人、同住酒店、同住次数、入住时间、疑似同住标记。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"endDate":{"type":"string","description":"住宿日期上限,格式 yyyy-MM-dd(含当天)"},"hasTogether":{"type":"integer","description":"疑似同住标记:1=时间窗口内的疑似同住,2=同行且 24 小时内住宿的疑似同住;不传则只保留确定同住"},"liveWithCertNo":{"type":"string","description":"同住人身份证号,精确匹配;取汇总结果里的 liveWithCertNo 列"},"liveWithName":{"type":"string","description":"同住人姓名,精确匹配;取汇总结果里的 liveWithName 列"},"outCount":{"type":"integer","description":"同住次数阈值,配合 outCountSymbol 使用;不传则不按次数过滤"},"outCountSymbol":{"type":"string","description":"同住次数比较符,取值 GE(>=)或 LE(<=),默认 LE"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500"},"personName":{"type":"string","description":"被调查对象姓名,精确匹配;一般取汇总结果里的 personName"},"startDate":{"type":"string","description":"住宿日期下限,格式 yyyy-MM-dd(含当天)"},"timeGap":{"type":"integer","description":"疑似同住的时间窗口(小时);不传则只统计确定同住"}},"description":"同住明细筛选条件;建议传 personName 或 liveWithName 收窄范围"}},"required":["query"]}', 'stat_together_live_detail', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  54. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100044, 'stat_together_live_summary', '同住关系汇总', '统计同住关系:综合旅馆住宿与同行服务数据,推导「确定同住」(同酒店且住宿时段有交集)与「疑似同住」(同行 + 24 小时内住宿,或同酒店且入住时间在 timeGap 小时内),按被调查对象分组并展开每个同住人。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"endDate":{"type":"string","description":"住宿日期上限,格式 yyyy-MM-dd(含当天)"},"hasTogether":{"type":"integer","description":"疑似同住标记:1=时间窗口内的疑似同住,2=同行且 24 小时内住宿的疑似同住;不传则只保留确定同住"},"outCount":{"type":"integer","description":"同住次数阈值,配合 outCountSymbol 使用;不传则不按次数过滤"},"outCountSymbol":{"type":"string","description":"同住次数比较符,取值 GE(>=)或 LE(<=),默认 LE;仅在传了 outCount 时生效"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500"},"personNames":{"description":"本方(机主)姓名,可传多个(OR 关系,精确匹配);不传则统计案件内全部人员","type":"array","items":{"type":"string","description":"本方(机主)姓名,可传多个(OR 关系,精确匹配);不传则统计案件内全部人员"}},"startDate":{"type":"string","description":"住宿日期下限,格式 yyyy-MM-dd(含当天)"},"timeGap":{"type":"integer","description":"疑似同住的时间窗口(小时),传入后才会统计「同酒店且入住时间在该窗口内」的疑似同住;不传则只统计确定同住"}},"description":"同住汇总筛选条件;outCount 配合 outCountSymbol 过滤同住次数"}},"required":["query"]}', 'stat_together_live_summary', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  55. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100045, 'stat_together_travel_detail', '同行出行明细', '查同行出行的行程明细:按同行汇总结果里的 idList 拉取原始出行记录,按出行日期分组返回(一行一个行程段)。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"ids":{"description":"同行记录 id 列表,必填;取同行汇总结果里的 idList 列。元素形如 TOGETHER_FLIGHT_123、TOGETHER_TRAIN_456、RAIL_TICKET_789、FLIGHT_TICKET_1、FLIGHT_DEPARTURE_2、CAR_TICKET_3(前缀由汇总工具给出,不要自己编)","type":"array","items":{"type":"string","description":"同行记录 id 列表,必填;取同行汇总结果里的 idList 列。元素形如 TOGETHER_FLIGHT_123、TOGETHER_TRAIN_456、RAIL_TICKET_789、FLIGHT_TICKET_1、FLIGHT_DEPARTURE_2、CAR_TICKET_3(前缀由汇总工具给出,不要自己编)"}},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500"},"personNames":{"description":"本方(机主)姓名,可传多个;用于把记录里的证件号回填成姓名,不传则姓名为空","type":"array","items":{"type":"string","description":"本方(机主)姓名,可传多个;用于把记录里的证件号回填成姓名,不传则姓名为空"}}},"required":["ids"],"description":"同行明细筛选条件;ids 必填"}},"required":["query"]}', 'stat_together_travel_detail', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  56. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100046, 'stat_together_travel_summary', '同行出行汇总', '统计同行出行:综合同航班/同火车服务、铁路订票、民航离港、民航订票、汽车票务数据,找出「同一时间、同一车次/航班」出现的人员配对,返回配对与对应的记录 id 列表(idList 列)。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"endDate":{"type":"string","description":"出行日期上限,格式 yyyy-MM-dd(含当天)"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500"},"personNames":{"description":"本方(机主)姓名,可传多个(OR 关系,精确匹配);不传则统计案件内全部人员","type":"array","items":{"type":"string","description":"本方(机主)姓名,可传多个(OR 关系,精确匹配);不传则统计案件内全部人员"}},"startDate":{"type":"string","description":"出行日期下限,格式 yyyy-MM-dd(含当天)"}},"description":"同行汇总筛选条件,字段全部可选"}},"required":["query"]}', 'stat_together_travel_summary', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  57. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100047, 'stat_track_cell_tower_detail', '基站轨迹明细', '查指定基站下的通联明细:某人在某个基站(按 LAC/CID 或基站名称定位)与各号码的通话次数。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"endDate":{"type":"string","description":"通话日期上限,格式 yyyy-MM-dd(含当天)"},"otherPhone":{"type":"string","description":"对方号码,精确匹配"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500"},"personCellId":{"type":"string","description":"基站小区编号 CID,精确匹配;取汇总结果里的 personCellId 列"},"personName":{"type":"string","description":"本方(机主)姓名,精确匹配;取汇总结果里的 personName 列"},"personRegionId":{"type":"string","description":"基站区域编号 LAC,精确匹配;取汇总结果里的 personRegionId 列"},"personStationName":{"type":"string","description":"基站名称,精确匹配;取汇总结果里的 personStationName 列(与汇总工具不同,这里不支持模糊)"},"startDate":{"type":"string","description":"通话日期下限,格式 yyyy-MM-dd(含当天)"}},"description":"基站通联明细筛选条件;建议至少传 personName 加一个基站定位条件(LAC/CID 或基站名称)"}},"required":["query"]}', 'stat_track_cell_tower_detail', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  58. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100048, 'stat_track_cell_tower_summary', '基站轨迹汇总', '按「人员 + 基站」汇总基站轨迹:返回每个人在每个基站下的通话次数、首末通话日期与基站经纬度。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"endDate":{"type":"string","description":"通话日期上限,格式 yyyy-MM-dd(含当天)"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500(用户可在前端表格翻页看全部)"},"personNames":{"description":"本方(机主)姓名,可传多个(OR 关系,精确匹配);不传则统计案件内全部人员","type":"array","items":{"type":"string","description":"本方(机主)姓名,可传多个(OR 关系,精确匹配);不传则统计案件内全部人员"}},"personStationName":{"type":"string","description":"基站名称,模糊匹配(包含即命中);如「望京」「火车站」"},"startDate":{"type":"string","description":"通话日期下限,格式 yyyy-MM-dd(含当天)"}},"description":"基站轨迹汇总筛选条件,字段全部可选"}},"required":["query"]}', 'stat_track_cell_tower_summary', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  59. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100049, 'stat_track_en_local_detail', '境外昼夜活动明细', '查昼夜活动的通话明细:返回满足昼夜时段条件的原始通话记录(一行一通)。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"endDate":{"type":"string","description":"通话日期上限,格式 yyyy-MM-dd(含当天)"},"morningTime":{"type":"integer","description":"白天时段截止小时,取值 0-23,默认 8;需与汇总查询保持一致"},"nightTime":{"type":"integer","description":"夜间时段起始小时,取值 0-23,默认 20;需与汇总查询保持一致"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500"},"personCellId":{"type":"string","description":"基站小区编号 CID,精确匹配;取汇总结果里的 personCellId 列"},"personNames":{"description":"本方(机主)姓名,可传多个(OR 关系,精确匹配);一般取汇总结果里的 personName","type":"array","items":{"type":"string","description":"本方(机主)姓名,可传多个(OR 关系,精确匹配);一般取汇总结果里的 personName"}},"personRegionId":{"type":"string","description":"基站区域编号 LAC,精确匹配;取汇总结果里的 personRegionId 列"},"personStationName":{"type":"string","description":"基站名称,精确匹配;取汇总结果里的 personStationName 列"},"startDate":{"type":"string","description":"通话日期下限,格式 yyyy-MM-dd(含当天)"}},"description":"昼夜活动明细筛选条件;建议传 personNames 加一个基站定位条件"}},"required":["query"]}', 'stat_track_en_local_detail', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  60. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100050, 'stat_track_en_local_summary', '境外昼夜活动汇总', '按「人员 + 基站」统计昼夜活动次数:统计白天(06:00 至 morningTime)与夜间(nightTime 起)出现在同一基站的次数合计,可用 dayNightTotal 卡阈值挑出高频活动点。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"dayNightTotal":{"type":"integer","description":"昼夜活动次数下限,只返回活动次数 >= 该值的人员-基站组合;不传则不限制"},"endDate":{"type":"string","description":"通话日期上限,格式 yyyy-MM-dd(含当天)"},"morningTime":{"type":"integer","description":"白天时段截止小时,取值 0-23,默认 8(即统计 06:00 至该时刻的活动);通常不用改"},"nightTime":{"type":"integer","description":"夜间时段起始小时,取值 0-23,默认 20;传 20/21/22/23 表示当晚到次日凌晨 05:59,传 0-19 表示凌晨到 05:59。通常不用改"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500"},"personNames":{"description":"本方(机主)姓名,可传多个(OR 关系,精确匹配);不传则统计案件内全部人员","type":"array","items":{"type":"string","description":"本方(机主)姓名,可传多个(OR 关系,精确匹配);不传则统计案件内全部人员"}},"startDate":{"type":"string","description":"通话日期下限,格式 yyyy-MM-dd(含当天)"}},"description":"昼夜活动汇总筛选条件;morningTime / nightTime 一般不用传,保持默认即可"}},"required":["query"]}', 'stat_track_en_local_summary', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  61. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100051, 'stat_track_meet_detail', '人员碰面明细', '查某对人员在某基站的具体碰面记录:返回碰面时间、时间差(分钟)、基站名称等。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"cid":{"type":"string","description":"基站小区编号 CID,必填;取汇总结果里的 cid 列"},"endDate":{"type":"string","description":"通话日期上限,格式 yyyy-MM-dd(含当天)"},"lac":{"type":"string","description":"基站区域编号 LAC,必填;取汇总结果里的 lac 列"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500"},"persona":{"type":"string","description":"人员 A 姓名,必填;取汇总结果里的 persona 列(两个姓名有先后顺序,需与汇总结果一致)"},"personb":{"type":"string","description":"人员 B 姓名,必填;取汇总结果里的 personb 列"},"startDate":{"type":"string","description":"通话日期下限,格式 yyyy-MM-dd(含当天)"},"timeInterval":{"type":"integer","description":"碰面判定时间窗口(分钟),默认 30;需与汇总查询保持一致"}},"required":["cid","lac","persona","personb"],"description":"碰面明细筛选条件;lac / cid / persona / personb 均必填"}},"required":["query"]}', 'stat_track_meet_detail', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  62. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100052, 'stat_track_meet_summary', '人员碰面汇总', '统计轨迹碰面:找出「在同一基站、且通话时间相差不超过 timeInterval 分钟」的人员配对,按配对汇总碰面总次数,并展开每个基站的碰面次数。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"endDate":{"type":"string","description":"通话日期上限,格式 yyyy-MM-dd(含当天)"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500"},"personNames":{"description":"本方(机主)姓名,可传多个(OR 关系,精确匹配);不传则统计案件内全部人员","type":"array","items":{"type":"string","description":"本方(机主)姓名,可传多个(OR 关系,精确匹配);不传则统计案件内全部人员"}},"startDate":{"type":"string","description":"通话日期下限,格式 yyyy-MM-dd(含当天)"},"timeInterval":{"type":"integer","description":"碰面判定时间窗口(分钟),默认 30;两人在同一基站且通话时间相差不超过该值即视为碰面"}},"description":"碰面汇总筛选条件;timeInterval 默认 30 分钟"}},"required":["query"]}', 'stat_track_meet_summary', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  63. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100053, 'stat_trans_amount_trend_month', '交易金额月度趋势', '按月统计交易金额趋势(收入/支出)。personName 通常传,可筛对手/日期;按年用当前工具列表中的年度趋势工具。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"endDate":{"type":"string","description":"交易日期上限,格式 yyyy-MM-dd(含当天)"},"otherName":{"type":"string","description":"对方姓名,精确匹配;查「对方信息缺失」的交易传「未知对手」"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500"},"personName":{"type":"string","description":"本方(机主)姓名,精确匹配;不传则统计全案所有对象"},"startDate":{"type":"string","description":"交易日期下限,格式 yyyy-MM-dd(含当天)"}},"description":"交易趋势条件,字段全部可选(建议传 personName)"}},"required":["query"]}', 'stat_trans_amount_trend_month', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  64. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100054, 'stat_trans_amount_trend_year', '交易金额年度趋势', '按年统计交易金额趋势(收入/支出)。personName 通常传,可筛对手/日期;按月用当前工具列表中的月度趋势工具。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"endDate":{"type":"string","description":"交易日期上限,格式 yyyy-MM-dd(含当天)"},"otherName":{"type":"string","description":"对方姓名,精确匹配;查「对方信息缺失」的交易传「未知对手」"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500"},"personName":{"type":"string","description":"本方(机主)姓名,精确匹配;不传则统计全案所有对象"},"startDate":{"type":"string","description":"交易日期下限,格式 yyyy-MM-dd(含当天)"}},"description":"交易趋势条件,字段全部可选(建议传 personName)"}},"required":["query"]}', 'stat_trans_amount_trend_year', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  65. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100055, 'stat_trans_big_by_date', '大额交易按日统计', '统计大额交易第二层:按交易日期聚合某对手的大额笔数与金额。逐笔用当前工具列表中的大额明细工具。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"endDate":{"type":"string","description":"交易日期上限,格式 yyyy-MM-dd(含当天)"},"otherName":{"type":"string","description":"对方姓名,精确匹配;查「未知对手」传「未知对手」"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500"},"personName":{"type":"string","description":"本方姓名,单值写法,等价于 personNames 只有一个元素"},"personNames":{"description":"本方(被调查对象)姓名,可传多个;不传则统计全案所有对象人员","type":"array","items":{"type":"string","description":"本方(被调查对象)姓名,可传多个;不传则统计全案所有对象人员"}},"startDate":{"type":"string","description":"交易日期下限,格式 yyyy-MM-dd(含当天)"},"transAmount":{"type":"number","description":"交易金额阈值,配合 transAmountSymbol 使用(如 50000 表示金额 ≥ 5 万)"},"transAmountSymbol":{"type":"string","description":"金额比较符,取值 GE(>=,默认) / LE(<=) / GT(>) / LT(<) / EQ(=)"},"transCount":{"type":"integer","description":"交易次数阈值,配合 transCountSymbol 使用"},"transCountSymbol":{"type":"string","description":"次数比较符,取值 GE(>=,默认) / LE(<=) / GT(>) / LT(<) / EQ(=)"}},"description":"大额交易筛选条件,建议传 otherName 定位对手"}},"required":["query"]}', 'stat_trans_big_by_date', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  66. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100056, 'stat_trans_big_detail', '大额交易明细', '统计大额交易第三层:按日期分组列出逐笔明细(日期、金额、收付方向、交易ID)。先按对手汇总或按日期定位,再下钻本工具。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"endDate":{"type":"string","description":"交易日期上限,格式 yyyy-MM-dd(含当天)"},"otherName":{"type":"string","description":"对方姓名,精确匹配;查「未知对手」传「未知对手」"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500"},"personName":{"type":"string","description":"本方姓名,单值写法,等价于 personNames 只有一个元素"},"personNames":{"description":"本方(被调查对象)姓名,可传多个;不传则统计全案所有对象人员","type":"array","items":{"type":"string","description":"本方(被调查对象)姓名,可传多个;不传则统计全案所有对象人员"}},"startDate":{"type":"string","description":"交易日期下限,格式 yyyy-MM-dd(含当天)"},"transAmount":{"type":"number","description":"交易金额阈值,配合 transAmountSymbol 使用(如 50000 表示金额 ≥ 5 万)"},"transAmountSymbol":{"type":"string","description":"金额比较符,取值 GE(>=,默认) / LE(<=) / GT(>) / LT(<) / EQ(=)"},"transCount":{"type":"integer","description":"交易次数阈值,配合 transCountSymbol 使用"},"transCountSymbol":{"type":"string","description":"次数比较符,取值 GE(>=,默认) / LE(<=) / GT(>) / LT(<) / EQ(=)"}},"description":"大额交易筛选条件,建议传 otherName 定位对手"}},"required":["query"]}', 'stat_trans_big_detail', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  67. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100057, 'stat_trans_big_summary', '大额交易汇总', '统计大额交易第一层:按「本方姓名+对方姓名+对方卡号」汇总笔数与金额。看日期分布用当前工具列表中的按日期统计工具,逐笔用其中的大额明细工具。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"endDate":{"type":"string","description":"交易日期上限,格式 yyyy-MM-dd(含当天)"},"otherName":{"type":"string","description":"对方姓名,精确匹配;查「未知对手」传「未知对手」"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500"},"personName":{"type":"string","description":"本方姓名,单值写法,等价于 personNames 只有一个元素"},"personNames":{"description":"本方(被调查对象)姓名,可传多个;不传则统计全案所有对象人员","type":"array","items":{"type":"string","description":"本方(被调查对象)姓名,可传多个;不传则统计全案所有对象人员"}},"startDate":{"type":"string","description":"交易日期下限,格式 yyyy-MM-dd(含当天)"},"transAmount":{"type":"number","description":"交易金额阈值,配合 transAmountSymbol 使用(如 50000 表示金额 ≥ 5 万)"},"transAmountSymbol":{"type":"string","description":"金额比较符,取值 GE(>=,默认) / LE(<=) / GT(>) / LT(<) / EQ(=)"},"transCount":{"type":"integer","description":"交易次数阈值,配合 transCountSymbol 使用"},"transCountSymbol":{"type":"string","description":"次数比较符,取值 GE(>=,默认) / LE(<=) / GT(>) / LT(<) / EQ(=)"}},"description":"大额交易筛选条件,字段全部可选"}},"required":["query"]}', 'stat_trans_big_summary', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  68. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100058, 'stat_trans_card_hold', '代持卡分析', '分析「疑似他人代持的银行卡」:在指定人员分组内,找出非本人开户、但预留手机号 / 登录 MAC / 登录 IP 与主体对象一致的银行卡(异卡同号、异卡同 MAC、异卡同 IP)。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"groupId":{"type":"integer","description":"人员分组ID(必填);可用 list_person_groups 工具查询分组列表"},"mainIpList":{"description":"主体对象的 IP 地址列表;一般不用传","type":"array","items":{"type":"string","description":"主体对象的 IP 地址列表;一般不用传"}},"mainMacList":{"description":"主体对象的 MAC 地址列表;一般不用传","type":"array","items":{"type":"string","description":"主体对象的 MAC 地址列表;一般不用传"}},"samePhoneCards":{"description":"参与「异卡同号」比对的卡号列表;一般不用传,留空由服务端全量比对","type":"array","items":{"type":"string","description":"参与「异卡同号」比对的卡号列表;一般不用传,留空由服务端全量比对"}},"transAmount":{"type":"number","description":"交易金额阈值,配合 transAmountSymbol"},"transAmountSymbol":{"type":"string","description":"金额比较符,取值 GE(>=,默认) / LE(<=) / GT(>) / LT(<) / EQ(=)"}},"required":["groupId"],"description":"卡持有分析筛选条件,groupId 必传"}},"required":["query"]}', 'stat_trans_card_hold', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  69. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100059, 'stat_trans_cash_flow', '交易现金流汇总', '按人员/卡号维度汇总交易笔数与金额(交易摘要统计),并自动套用「现金关键词」配置识别现金类交易。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"endDate":{"type":"string","description":"交易日期上限,格式 yyyy-MM-dd(含当天)"},"otherCardNo":{"type":"string","description":"对方卡号,精确匹配"},"otherName":{"type":"string","description":"对方姓名,精确匹配"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500"},"personCardNo":{"type":"string","description":"本方银行卡号,精确匹配"},"personName":{"type":"string","description":"本方姓名,单值写法"},"personNames":{"description":"本方姓名,可传多个;不传则统计全案所有对象人员","type":"array","items":{"type":"string","description":"本方姓名,可传多个;不传则统计全案所有对象人员"}},"startDate":{"type":"string","description":"交易日期下限,格式 yyyy-MM-dd(含当天)"},"transAmount":{"type":"number","description":"单笔交易金额阈值,配合 transAmountSymbol"},"transAmountSymbol":{"type":"string","description":"金额比较符,取值 GE(>=,默认) / LE(<=) / GT(>) / LT(<) / EQ(=)"},"transCount":{"type":"integer","description":"交易次数阈值,配合 transCountSymbol"},"transCountSymbol":{"type":"string","description":"次数比较符,取值 GE(>=,默认) / LE(<=) / GT(>) / LT(<) / EQ(=)"}},"description":"交易摘要筛选条件,字段全部可选"}},"required":["query"]}', 'stat_trans_cash_flow', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  70. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100060, 'stat_trans_continuous_detail', '持续交易明细', '统计持续交易第二层:按「本方卡号 + 对方姓名 + 对方卡号 + 连续分组」展开每段持续交易关系的起止月份、交易笔数与金额。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"endDate":{"type":"string","description":"交易日期上限,格式 yyyy-MM-dd(含当天)"},"maxTransMoney":{"type":"number","description":"单笔金额上限(含)"},"minTransMoney":{"type":"number","description":"单笔金额下限(含)"},"monthVal":{"type":"integer","description":"连续月份阈值:只统计连续交易月数 ≥ 该值的对象,默认 1"},"otherCardNo":{"type":"string","description":"对方卡号,精确匹配;查「未知卡号」传「未知卡号」"},"otherName":{"type":"string","description":"对方姓名,精确匹配;查「未知对手」传「未知对手」"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500"},"personName":{"type":"string","description":"本方姓名,单值写法"},"personNames":{"description":"本方姓名,可传多个;不传则统计全案所有对象人员","type":"array","items":{"type":"string","description":"本方姓名,可传多个;不传则统计全案所有对象人员"}},"startDate":{"type":"string","description":"交易日期下限,格式 yyyy-MM-dd(含当天)"}},"description":"持续交易筛选条件,建议传 otherName/otherCardNo 定位对手"}},"required":["query"]}', 'stat_trans_continuous_detail', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  71. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100061, 'stat_trans_continuous_summary', '持续交易汇总', '统计持续交易第一层:找出「跨多个月份持续交易」的本方与对方组合,返回连续月份数、交易总笔数、交易总金额、连续起止月份。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"endDate":{"type":"string","description":"交易日期上限,格式 yyyy-MM-dd(含当天)"},"maxTransMoney":{"type":"number","description":"单笔金额上限(含)"},"minTransMoney":{"type":"number","description":"单笔金额下限(含)"},"monthVal":{"type":"integer","description":"连续月份阈值:只统计连续交易月数 ≥ 该值的对象,默认 1"},"otherCardNo":{"type":"string","description":"对方卡号,精确匹配;查「未知卡号」传「未知卡号」"},"otherName":{"type":"string","description":"对方姓名,精确匹配;查「未知对手」传「未知对手」"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500"},"personName":{"type":"string","description":"本方姓名,单值写法"},"personNames":{"description":"本方姓名,可传多个;不传则统计全案所有对象人员","type":"array","items":{"type":"string","description":"本方姓名,可传多个;不传则统计全案所有对象人员"}},"startDate":{"type":"string","description":"交易日期下限,格式 yyyy-MM-dd(含当天)"}},"description":"持续交易筛选条件,字段全部可选"}},"required":["query"]}', 'stat_trans_continuous_summary', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  72. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100062, 'stat_trans_fast_fund_flow', '资金快转分析', '分析资金快转(快进快出):同一张卡在指定时间窗口内先收到一笔钱、随后又转出,识别「过账卡 / 中转账户」特征。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"debitCreditFlag":{"type":"string","description":"收付方向,取值「收入」或「支出」;一般不用传,服务端会分别取收入和支出做配对"},"endDate":{"type":"string","description":"交易日期上限,格式 yyyy-MM-dd(含当天)"},"hour":{"type":"integer","description":"「先收后支」的时间窗口小时数,如 24 表示 24 小时内进出;建议传,否则结果偏多"},"personCardNo":{"type":"string","description":"本方银行卡号,精确匹配"},"personName":{"type":"string","description":"本方(被调查对象)姓名,建议必传,否则结果可能过多"},"startDate":{"type":"string","description":"交易日期下限,格式 yyyy-MM-dd(含当天)"},"transAmount":{"type":"number","description":"单笔金额阈值,配合 transAmountSymbol"},"transAmountSymbol":{"type":"string","description":"金额比较符,取值 GE(>=,默认) / LE(<=) / GT(>) / LT(<) / EQ(=)"}},"description":"资金快转筛选条件,建议传 personName 与 hour"}},"required":["query"]}', 'stat_trans_fast_fund_flow', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  73. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100063, 'stat_trans_financial', '金融交易筛选', '按「金融关键词」配置筛选金融类交易(如理财、贷款、保险等),返回命中关键词的交易明细并标注 tags。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"endDate":{"type":"string","description":"交易日期上限,格式 yyyy-MM-dd(含当天)"},"financialKeyTag":{"type":"string","description":"金融关键词标签(在「金融关键词配置」里维护,如「理财」「贷款」);不传则用全部已配置关键词"},"otherName":{"type":"string","description":"对方姓名,精确匹配"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500"},"personName":{"type":"string","description":"本方姓名,单值写法"},"personNames":{"description":"本方姓名,可传多个;不传则统计全案所有对象人员","type":"array","items":{"type":"string","description":"本方姓名,可传多个;不传则统计全案所有对象人员"}},"startDate":{"type":"string","description":"交易日期下限,格式 yyyy-MM-dd(含当天)"}},"description":"金融关键词交易筛选条件,字段全部可选"}},"required":["query"]}', 'stat_trans_financial', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  74. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100064, 'stat_trans_fixed_deposit', '定期存款汇总', '统计定期存款第一层:按人员汇总定期存款相关的收入/支出总额与净额。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"endDate":{"type":"string","description":"交易日期上限,格式 yyyy-MM-dd(含当天)"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500(仅第二层明细用)"},"personName":{"type":"string","description":"本方姓名,单值写法"},"personNames":{"description":"本方姓名,可传多个;不传则统计全案所有对象人员","type":"array","items":{"type":"string","description":"本方姓名,可传多个;不传则统计全案所有对象人员"}},"startDate":{"type":"string","description":"交易日期下限,格式 yyyy-MM-dd(含当天)"}},"description":"定期存款筛选条件,字段全部可选"}},"required":["query"]}', 'stat_trans_fixed_deposit', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  75. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100065, 'stat_trans_fixed_deposit_detail', '定期存款明细', '统计定期存款第二层:返回定期存款的逐笔交易明细与账户变动明细(含分页)。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"endDate":{"type":"string","description":"交易日期上限,格式 yyyy-MM-dd(含当天)"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500(仅第二层明细用)"},"personName":{"type":"string","description":"本方姓名,单值写法"},"personNames":{"description":"本方姓名,可传多个;不传则统计全案所有对象人员","type":"array","items":{"type":"string","description":"本方姓名,可传多个;不传则统计全案所有对象人员"}},"startDate":{"type":"string","description":"交易日期下限,格式 yyyy-MM-dd(含当天)"}},"description":"定期存款筛选条件,字段全部可选"}},"required":["query"]}', 'stat_trans_fixed_deposit_detail', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  76. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100066, 'stat_trans_frequency', '交易频次统计', '统计交易频次:按本方与对方维度汇总交易次数,可用 transCount/transCountSymbol 设门槛(如只看交易 ≥ 10 次的对手)。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"endDate":{"type":"string","description":"交易日期上限,格式 yyyy-MM-dd(含当天)"},"otherCardNo":{"type":"string","description":"对方卡号,精确匹配"},"otherName":{"type":"string","description":"对方姓名,精确匹配"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500"},"personName":{"type":"string","description":"本方姓名,单值写法"},"personNames":{"description":"本方姓名,可传多个;不传则统计全案所有对象人员","type":"array","items":{"type":"string","description":"本方姓名,可传多个;不传则统计全案所有对象人员"}},"startDate":{"type":"string","description":"交易日期下限,格式 yyyy-MM-dd(含当天)"},"transCount":{"type":"integer","description":"交易次数阈值,配合 transCountSymbol"},"transCountSymbol":{"type":"string","description":"次数比较符,取值 GE(>=,默认) / LE(<=) / GT(>) / LT(<) / EQ(=)"}},"description":"交易频次筛选条件,字段全部可选"}},"required":["query"]}', 'stat_trans_frequency', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  77. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100067, 'stat_trans_record_summary', '交易记录汇总', '按「本方姓名+卡号、对方姓名+卡号、银行」统计交易笔数与金额。personNames 可多传(不传全案),可筛 otherName/otherCardNo/日期/现金;逐笔明细用当前工具列表中的交易流水工具。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"endDate":{"type":"string","description":"交易日期上限,格式 yyyy-MM-dd(含当天)"},"otherCardNo":{"type":"string","description":"对方银行卡号,精确匹配(单值)"},"otherName":{"type":"string","description":"对方姓名,精确匹配;查「对方信息缺失」的交易传「未知对手」"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500"},"personCardNo":{"type":"string","description":"本方银行卡号,精确匹配(单值)"},"personNames":{"description":"本方(机主)姓名,可传多个;不传则统计全案所有对象的交易(注意:本接口只认这个列表字段)","type":"array","items":{"type":"string","description":"本方(机主)姓名,可传多个;不传则统计全案所有对象的交易(注意:本接口只认这个列表字段)"}},"source":{"type":"integer","description":"传 1 表示只看现金交易(按案件配置的现金关键字过滤摘要字段);不传或传 0 表示不限制"},"startDate":{"type":"string","description":"交易日期下限,格式 yyyy-MM-dd(含当天)"},"transAmount":{"type":"number","description":"交易金额阈值(元),配合 transAmountSymbol 使用"},"transAmountSymbol":{"type":"string","description":"交易金额比较符号,取值 ge(>=) / le(<=) / gt(>) / lt(<) / eq(=),默认 ge"},"transCount":{"type":"integer","description":"交易次数阈值,配合 transCountSymbol 使用"},"transCountSymbol":{"type":"string","description":"交易次数比较符号,取值 ge(>=) / le(<=) / gt(>) / lt(<) / eq(=),默认 ge"}},"description":"交易记录汇总条件,字段全部可选"}},"required":["query"]}', 'stat_trans_record_summary', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  78. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100068, 'stat_trans_sensitive_detail', '敏感日期交易明细', '查询敏感日期(特殊日期/节假日)内的交易原始明细,返回话单并带上命中的节日名称。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"endDate":{"type":"string","description":"交易日期上限,格式 yyyy-MM-dd(含当天)"},"otherCardNo":{"type":"string","description":"对方卡号,精确匹配;查「未知卡号」传「未知卡号」"},"otherName":{"type":"string","description":"对方姓名,精确匹配;查「未知对手」传「未知对手」"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500"},"personName":{"type":"string","description":"本方姓名,单值写法"},"personNames":{"description":"本方姓名,可传多个;不传则统计全案所有对象人员","type":"array","items":{"type":"string","description":"本方姓名,可传多个;不传则统计全案所有对象人员"}},"startDate":{"type":"string","description":"交易日期下限,格式 yyyy-MM-dd(含当天)"}},"description":"敏感日期交易筛选条件,建议传 otherName/otherCardNo 定位"}},"required":["query"]}', 'stat_trans_sensitive_detail', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  79. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100069, 'stat_trans_sensitive_summary', '敏感日期交易汇总', '统计敏感日期(案件配置的特殊日期/节假日)内的交易第一层:按「本方姓名 + 对方姓名 + 对方卡号」汇总落在特殊日期内的交易笔数。问「敏感日期期间和谁有资金往来」时用本工具。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"endDate":{"type":"string","description":"交易日期上限,格式 yyyy-MM-dd(含当天)"},"otherCardNo":{"type":"string","description":"对方卡号,精确匹配;查「未知卡号」传「未知卡号」"},"otherName":{"type":"string","description":"对方姓名,精确匹配;查「未知对手」传「未知对手」"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500"},"personName":{"type":"string","description":"本方姓名,单值写法"},"personNames":{"description":"本方姓名,可传多个;不传则统计全案所有对象人员","type":"array","items":{"type":"string","description":"本方姓名,可传多个;不传则统计全案所有对象人员"}},"startDate":{"type":"string","description":"交易日期下限,格式 yyyy-MM-dd(含当天)"}},"description":"敏感日期交易筛选条件,字段全部可选"}},"required":["query"]}', 'stat_trans_sensitive_summary', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  80. insert into ai_tool (id, tool_code, tool_name, description, tool_type, params_schema, impl_name, status, mcp_exposed, remark, create_by, create_time, update_by, update_time) values (1761500000000100070, 'stat_trans_together', '共同交易分析', '分析同一「人员分组」内的人是否在相近时间内向同一对手交易(共同交易)。', '0', '{"type":"object","properties":{"query":{"type":"object","properties":{"cardNum":{"type":"integer","description":"涉及交易卡数量阈值,配合 cardNumSymbol(服务端在内存中按此过滤)"},"cardNumSymbol":{"type":"string","description":"卡数比较符,取值 GE(>=) / LE(<=) / GT(>) / LT(<) / EQ(=)"},"dayGap":{"type":"integer","description":"共同交易的时间间隔(天)阈值,配合 daySymbol;如 dayGap=3 表示 3 天内共同交易"},"daySymbol":{"type":"string","description":"天数比较符,取值 GE(>=) / LE(<=) / GT(>) / LT(<) / EQ(=)"},"debitCreditFlag":{"type":"string","description":"收付方向,取值「支出」(默认)或「收入」"},"endDate":{"type":"string","description":"交易日期上限,格式 yyyy-MM-dd(含当天)"},"groupId":{"type":"integer","description":"人员分组ID(必填);可用 list_person_groups 工具查询分组列表"},"pageSize":{"type":"integer","description":"返回给模型的首屏行数,默认 50,上限 500"},"startDate":{"type":"string","description":"交易日期下限,格式 yyyy-MM-dd(含当天)"},"transAmount":{"type":"number","description":"单笔交易金额阈值,配合 transAmountSymbol"},"transAmountSymbol":{"type":"string","description":"金额比较符,取值 GE(>=,默认) / LE(<=) / GT(>) / LT(<) / EQ(=)"}},"required":["groupId"],"description":"共同交易筛选条件,groupId 必传"}},"required":["query"]}', 'stat_trans_together', '0', '0', '迁移自旧 Agent 工具,适配见 BusinessToolCatalog', 1761100000000000001, now(), 1761100000000000001, now()) on conflict (tool_code) do update set tool_name=excluded.tool_name, description=excluded.description, tool_type=excluded.tool_type, params_schema=excluded.params_schema, impl_name=excluded.impl_name, status=excluded.status, update_time=now();
  81. -- 二、内置专家:案件数据分析专家
  82. insert into ai_expert_agent (id, agent_name, agent_code, description, sys_prompt, model_id, max_iters, status, remark, capability_desc, expert_write_enabled, auto_route, create_by, create_time, update_by, update_time, is_builtin) values (1761500000000200001, '案件数据分析专家', 'case_analysis_expert', '案件数据分析:通话、交易、轨迹、人物画像、非材料档案与电子数据包', '你是「案件数据分析专家」,负责基于当前案件库回答通话、交易、轨迹、人物画像、关系图谱、非表格材料与电子数据包相关的分析问题。
  83. 【工作纪律】
  84. 1. 先明确要分析的对象与时间范围;缺少定位信息时先用 list_persons 等工具了解案件里有哪些人/包。
  85. 2. 取数必须调用工具,禁止编造数据;简单条件筛选用专用工具;JOIN/聚合等复杂分析在现有工具不支持时如实说明。
  86. 3. 案件库只读;需要产出文件时使用工作区文件工具。
  87. 4. 不确定表名/字段时先用 list_tables 或 search_table_schema;不要凭猜测拼列名。
  88. 5. 结论要给出依据(工具名 + 关键数字),并说明口径与时间范围;数据不足时如实说明。
  89. 6. 关系图请引导用户使用关系图页面查看或维护。
  90. 【输出风格】简体中文,先给结论,再给明细依据,避免复述原始表格。', 1761400000000020400, 100, '0', '平台内置专家:迁移旧 Agent 的领域分析工具,绑定全部业务工具', '基于当前案件库做通话/交易/轨迹/人物/材料/电子数据包分析', '1', '1', 1761100000000000001, now(), 1761100000000000001, now(), '1') on conflict (agent_code) do update set agent_name=excluded.agent_name, description=excluded.description, sys_prompt=excluded.sys_prompt, model_id=excluded.model_id, max_iters=excluded.max_iters, status=excluded.status, capability_desc=excluded.capability_desc, expert_write_enabled=excluded.expert_write_enabled, auto_route=excluded.auto_route, is_builtin=excluded.is_builtin, update_time=now();
  91. -- 三、专家工具绑定(全部允许)
  92. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201001, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'get_call_records', '0', '查询通话明细(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  93. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201003, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'get_eds_applications', '0', '已安装应用(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  94. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201004, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'get_eds_call_records', '0', '通话记录(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  95. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201005, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'get_eds_case_info', '0', '案件信息(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  96. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201006, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'get_eds_catalog', '0', '读取电子数据目录树(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  97. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201007, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'get_eds_chat_account_info', '0', '即时通信账号信息(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  98. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201008, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'get_eds_chat_friends', '0', '即时通信好友(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  99. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201009, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'get_eds_chat_groups', '0', '即时通信群组(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  100. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201010, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'get_eds_chat_messages', '0', '聊天记录(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  101. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201011, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'get_eds_contacts', '0', '通讯录(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  102. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201012, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'get_eds_geography_locations', '0', '地理定位记录(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  103. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201013, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'get_eds_sms_records', '0', '短信记录(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  104. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201014, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'get_express_records', '0', '查询快递明细(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  105. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201015, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'get_file_sample', '0', '读取材料正文片段(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  106. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201016, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'get_hotel_stay_detail', '0', '旅馆住宿明细(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  107. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201017, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'get_person_call_profile', '0', '通话数据画像(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  108. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201018, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'get_person_trans_profile', '0', '交易数据画像(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  109. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201019, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'get_together_live_info_detail', '0', '同住服务记录明细(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  110. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201020, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'get_trans_bank_card_info', '0', '银行卡交易汇总(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  111. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201021, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'get_trans_records', '0', '查询交易明细(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  112. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201022, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'get_travel_record_detail', '0', '出行票务明细(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  113. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201023, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'list_eds_packages', '0', '列出电子数据包(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  114. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201024, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'list_file_profiles', '0', '检索材料清单(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  115. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201025, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'list_persons', '0', '列出案件人员(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  116. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201026, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'list_tables', '0', '列出数据表(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  117. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201027, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'query_table_data', '0', '查询表格数据(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  118. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201028, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'search_table_schema', '0', '检索表结构(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  119. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201029, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_call_continuous_detail', '0', '持续通话明细(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  120. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201030, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_call_continuous_summary', '0', '持续通话汇总(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  121. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201031, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_call_night_detail', '0', '夜间通话明细(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  122. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201032, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_call_night_summary', '0', '夜间通话汇总(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  123. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201033, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_call_record_summary', '0', '通话记录汇总(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  124. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201034, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_call_sensitive_detail', '0', '敏感日期通话明细(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  125. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201035, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_call_sensitive_summary', '0', '敏感日期通话汇总(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  126. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201036, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_express_by_phone', '0', '按号码查快递(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  127. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201037, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_express_summary', '0', '快递收寄汇总(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  128. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201038, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_file_profiles_by_category', '0', '材料分类统计(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  129. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201039, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_intimacy_summary', '0', '亲密度总览(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  130. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201040, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_person_call_station', '0', '通话基站分布(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  131. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201041, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_person_call_top10', '0', '最常联系人 TOP10(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  132. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201042, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_person_trans_top10', '0', '最常交易对手 TOP10(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  133. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201043, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_together_live_detail', '0', '同住关系明细(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  134. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201044, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_together_live_summary', '0', '同住关系汇总(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  135. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201045, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_together_travel_detail', '0', '同行出行明细(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  136. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201046, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_together_travel_summary', '0', '同行出行汇总(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  137. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201047, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_track_cell_tower_detail', '0', '基站轨迹明细(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  138. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201048, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_track_cell_tower_summary', '0', '基站轨迹汇总(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  139. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201049, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_track_en_local_detail', '0', '境外昼夜活动明细(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  140. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201050, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_track_en_local_summary', '0', '境外昼夜活动汇总(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  141. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201051, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_track_meet_detail', '0', '人员碰面明细(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  142. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201052, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_track_meet_summary', '0', '人员碰面汇总(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  143. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201053, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_trans_amount_trend_month', '0', '交易金额月度趋势(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  144. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201054, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_trans_amount_trend_year', '0', '交易金额年度趋势(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  145. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201055, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_trans_big_by_date', '0', '大额交易按日统计(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  146. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201056, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_trans_big_detail', '0', '大额交易明细(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  147. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201057, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_trans_big_summary', '0', '大额交易汇总(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  148. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201058, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_trans_card_hold', '0', '代持卡分析(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  149. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201059, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_trans_cash_flow', '0', '交易现金流汇总(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  150. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201060, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_trans_continuous_detail', '0', '持续交易明细(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  151. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201061, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_trans_continuous_summary', '0', '持续交易汇总(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  152. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201062, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_trans_fast_fund_flow', '0', '资金快转分析(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  153. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201063, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_trans_financial', '0', '金融交易筛选(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  154. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201064, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_trans_fixed_deposit', '0', '定期存款汇总(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  155. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201065, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_trans_fixed_deposit_detail', '0', '定期存款明细(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  156. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201066, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_trans_frequency', '0', '交易频次统计(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  157. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201067, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_trans_record_summary', '0', '交易记录汇总(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  158. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201068, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_trans_sensitive_detail', '0', '敏感日期交易明细(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  159. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201069, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_trans_sensitive_summary', '0', '敏感日期交易汇总(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  160. insert into ai_agent_tool (id, agent_id, tool_code, decision, remark, create_by, create_time) values (1761500000000201070, (select id from ai_expert_agent where agent_code = 'case_analysis_expert'), 'stat_trans_together', '0', '共同交易分析(迁移工具,只读/写按 ai_tool.tool_type)', 1761100000000000001, now()) on conflict (agent_id, tool_code) do nothing;
  161. -- Python 执行能力已移除:清理历史登记、专家绑定与用户信任(可重复执行)
  162. delete from ai_agent_tool_trust where tool_code = 'execute_python';
  163. delete from ai_agent_tool where tool_code = 'execute_python';
  164. delete from ai_tool where tool_code = 'execute_python';