2025-10-23 15:05:51 - mcp_services - INFO - [main.py:341] - 开始运行 MCP SQL Executor 服务器
2025-10-23 15:05:51 - mcp_services - INFO - [main.py:293] - ============================================================
2025-10-23 15:05:51 - mcp_services - INFO - [main.py:294] - 正在启动 MCP 服务器: lzwcai-mcp-sqlexecutor
2025-10-23 15:05:51 - mcp_services - INFO - [main.py:295] - 版本: 0.1.0
2025-10-23 15:05:51 - mcp_services - INFO - [main.py:296] - ============================================================
2025-10-23 15:05:51 - mcp_services - INFO - [main.py:300] - 环境配置 - Database ID: 29
2025-10-23 15:05:51 - mcp_services - INFO - [main.py:301] - 环境配置 - Skill ID: 1981195682443014146
2025-10-23 15:05:51 - mcp_services - INFO - [main.py:302] - 环境配置 - Backend Base URL: http://192.168.2.236:8088
2025-10-23 15:05:51 - mcp_services - INFO - [main.py:303] - ============================================================
2025-10-23 15:05:51 - mcp_services - INFO - [main.py:308] - MCP 服务器已启动，等待客户端连接...
2025-10-23 15:05:52 - mcp_services - INFO - [main.py:156] - 收到列出工具请求
2025-10-23 15:05:52 - mcp_services - INFO - [main.py:119] - 初始化查询配置（数据源: api）...
2025-10-23 15:05:52 - mcp_services - INFO - [main.py:272] - 调用第三方API，skill_id: 1981195682443014146
2025-10-23 15:05:52 - mcp_services - INFO - [main.py:277] - 成功{'msg': '查询失败: 技能不存在: 1981195682443014146', 'code': 500}
2025-10-23 15:05:52 - mcp_services - INFO - [main.py:282] - 成功获取并处理 0 条数据
2025-10-23 15:05:52 - mcp_services - INFO - [main.py:128] - API配置: 0 条
2025-10-23 15:05:52 - mcp_services - INFO - [main.py:129] - API配置数组: []
2025-10-23 15:05:52 - mcp_services - INFO - [main.py:165] - 成功生成 0 个 MCP 工具
2025-10-23 15:08:30 - mcp_services - INFO - [main.py:341] - 开始运行 MCP SQL Executor 服务器
2025-10-23 15:08:30 - mcp_services - INFO - [main.py:293] - ============================================================
2025-10-23 15:08:30 - mcp_services - INFO - [main.py:294] - 正在启动 MCP 服务器: lzwcai-mcp-sqlexecutor
2025-10-23 15:08:30 - mcp_services - INFO - [main.py:295] - 版本: 0.1.0
2025-10-23 15:08:30 - mcp_services - INFO - [main.py:296] - ============================================================
2025-10-23 15:08:30 - mcp_services - INFO - [main.py:300] - 环境配置 - Database ID: 29
2025-10-23 15:08:30 - mcp_services - INFO - [main.py:301] - 环境配置 - Skill ID: 1981245768471322626
2025-10-23 15:08:30 - mcp_services - INFO - [main.py:302] - 环境配置 - Backend Base URL: http://192.168.2.236:8088
2025-10-23 15:08:30 - mcp_services - INFO - [main.py:303] - ============================================================
2025-10-23 15:08:30 - mcp_services - INFO - [main.py:308] - MCP 服务器已启动，等待客户端连接...
2025-10-23 15:08:31 - mcp_services - INFO - [main.py:156] - 收到列出工具请求
2025-10-23 15:08:31 - mcp_services - INFO - [main.py:119] - 初始化查询配置（数据源: api）...
2025-10-23 15:08:31 - mcp_services - INFO - [main.py:272] - 调用第三方API，skill_id: 1981245768471322626
2025-10-23 15:08:31 - mcp_services - INFO - [main.py:277] - 成功{'msg': '查询成功', 'code': 200, 'data': [{'id': '1981245768769118209', 'createBy': 'yy8z6', 'createTime': '2025-10-23 14:26:16', 'updateBy': None, 'updateTime': None, 'serviceId': '1981245768475516930', 'uniqueName': '数字员工技能描述-SQL服务_数字员工列表查询', 'name': '数字员工列表查询', 'description': '查询系统中的所有数字员工信息，包括员工ID、名称、类型、状态等核心信息，用于展示数字员工管理列表', 'visualizable': 1, 'toolPrompt': '查询数字员工列表', 'toolType': 'sql', 'datasourceId': '32', 'sqlTemplate': 'SELECT id, employee_id, name, employee_type, status, created_at, updated_at, description FROM digital_employees WHERE is_deleted = 0 ORDER BY created_at DESC', 'sqlParams': '{"type":"object","required":[],"properties":{}}', 'resultType': 'list', 'sourceType': 'ai', 'trainingTaskId': None, 'tableMetadataIds': '889,890,891,892,893,894,895,896', 'executionCount': 0, 'visualizationConfigs': None, 'inputJsonSchema': '{}', 'outputJsonSchema': '{"type":"object","properties":{"data":{"type":"array"}}}', 'lastExecutionTime': None}]}
2025-10-23 15:08:31 - mcp_services - INFO - [main.py:282] - 成功获取并处理 1 条数据
2025-10-23 15:08:31 - mcp_services - INFO - [main.py:128] - API配置: 1 条
2025-10-23 15:08:31 - mcp_services - INFO - [main.py:129] - API配置数组: [{'id': '1981245768769118209', 'businessName': '数字员工列表查询', 'businessDescription': '查询系统中的所有数字员工信息，包括员工ID、名称、类型、状态等核心信息，用于展示数字员工管理列表', 'sqlTemplate': 'SELECT id, employee_id, name, employee_type, status, created_at, updated_at, description FROM digital_employees WHERE is_deleted = 0 ORDER BY created_at DESC', 'parameters': {'type': 'object', 'required': ['employeeId'], 'properties': {'employeeId': {'type': 'number', 'description': '员工ID，用于标识员工的唯一数字标识符', 'examples': [1001, 2002]}}}, 'datasourceId': '32'}]
2025-10-23 15:08:31 - mcp_services - INFO - [main.py:165] - 成功生成 1 个 MCP 工具
2025-12-31 12:57:27 - mcp_services - INFO - [main.py:347] - 开始运行 MCP SQL Executor 服务器
2025-12-31 12:57:27 - mcp_services - INFO - [main.py:299] - ============================================================
2025-12-31 12:57:27 - mcp_services - INFO - [main.py:300] - 正在启动 MCP 服务器: lzwcai-mcp-sqlexecutor
2025-12-31 12:57:27 - mcp_services - INFO - [main.py:301] - 版本: 0.1.0
2025-12-31 12:57:27 - mcp_services - INFO - [main.py:302] - ============================================================
2025-12-31 12:57:27 - mcp_services - INFO - [main.py:306] - 环境配置 - Database ID: 16
2025-12-31 12:57:27 - mcp_services - INFO - [main.py:307] - 环境配置 - Skill ID: 
2025-12-31 12:57:27 - mcp_services - INFO - [main.py:308] - 环境配置 - Backend Base URL: http://192.168.11.24:8088
2025-12-31 12:57:27 - mcp_services - INFO - [main.py:309] - ============================================================
2025-12-31 12:57:27 - mcp_services - INFO - [main.py:314] - MCP 服务器已启动，等待客户端连接...
2025-12-31 12:57:28 - mcp_services - INFO - [main.py:156] - 收到列出工具请求
2025-12-31 12:57:28 - mcp_services - INFO - [main.py:119] - 初始化查询配置（数据源: api）...
2025-12-31 12:57:28 - mcp_services - INFO - [main.py:278] - 调用第三方API，skill_id: 
2025-12-31 12:57:29 - mcp_services - ERROR - [main.py:292] - API调用失败: API请求失败 (HTTP 404): http://192.168.11.24:8088/datasource/skill/getBySkillId/
Traceback (most recent call last):
  File "E:\yh-ai\project\lzwcai-szyg\lzwcai-mcp-server-package\lzwcai_mcp_sqlexecutor\lzwcai_mcp_sqlexecutor\utils\api_client.py", line 80, in get_skill_by_id
    response.raise_for_status()
  File "D:\anaconda3\Lib\site-packages\httpx\_models.py", line 829, in raise_for_status
    raise HTTPStatusError(message, request=request, response=self)
httpx.HTTPStatusError: Client error '404 ' for url 'http://192.168.11.24:8088/datasource/skill/getBySkillId/'
For more information check: https://developer.mozilla.org/en-US/docs/Web/HTTP/Status/404

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "E:\yh-ai\project\lzwcai-szyg\lzwcai-mcp-server-package\lzwcai_mcp_sqlexecutor\lzwcai_mcp_sqlexecutor\main.py", line 281, in call_third_party_api
    raw_result = get_skill_by_id(skill_id)
                 ^^^^^^^^^^^^^^^^^^^^^^^^^
  File "E:\yh-ai\project\lzwcai-szyg\lzwcai-mcp-server-package\lzwcai_mcp_sqlexecutor\lzwcai_mcp_sqlexecutor\utils\api_client.py", line 208, in get_skill_by_id
    return default_client.get_skill_by_id(skill_id)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "E:\yh-ai\project\lzwcai-szyg\lzwcai-mcp-server-package\lzwcai_mcp_sqlexecutor\lzwcai_mcp_sqlexecutor\utils\api_client.py", line 99, in get_skill_by_id
    raise Exception(error_msg)
Exception: API请求失败 (HTTP 404): http://192.168.11.24:8088/datasource/skill/getBySkillId/
2025-12-31 12:57:29 - mcp_services - WARNING - [main.py:131] - API获取失败，降级使用本地配置: API请求失败 (HTTP 404): http://192.168.11.24:8088/datasource/skill/getBySkillId/
2025-12-31 12:57:29 - mcp_services - INFO - [main.py:55] - 成功加载 3 个业务查询配置
2025-12-31 12:57:29 - mcp_services - ERROR - [main.py:92] - 生成工具模式失败: 2006300000000000001, 错误: 'businessName'
Traceback (most recent call last):
  File "E:\yh-ai\project\lzwcai-szyg\lzwcai-mcp-server-package\lzwcai_mcp_sqlexecutor\lzwcai_mcp_sqlexecutor\main.py", line 80, in generate_tool_schema_from_query
    tool_name = query['businessName']
                ~~~~~^^^^^^^^^^^^^^^^
KeyError: 'businessName'
2025-12-31 12:57:29 - mcp_services - ERROR - [main.py:170] - 列出工具失败: 'businessName'
Traceback (most recent call last):
  File "E:\yh-ai\project\lzwcai-szyg\lzwcai-mcp-server-package\lzwcai_mcp_sqlexecutor\lzwcai_mcp_sqlexecutor\main.py", line 162, in handle_list_tools
    tool = generate_tool_schema_from_query(query)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "E:\yh-ai\project\lzwcai-szyg\lzwcai-mcp-server-package\lzwcai_mcp_sqlexecutor\lzwcai_mcp_sqlexecutor\main.py", line 80, in generate_tool_schema_from_query
    tool_name = query['businessName']
                ~~~~~^^^^^^^^^^^^^^^^
KeyError: 'businessName'
2025-12-31 12:57:29 - mcp_services - INFO - [main.py:156] - 收到列出工具请求
2025-12-31 12:57:29 - mcp_services - ERROR - [main.py:92] - 生成工具模式失败: 2006300000000000001, 错误: 'businessName'
Traceback (most recent call last):
  File "E:\yh-ai\project\lzwcai-szyg\lzwcai-mcp-server-package\lzwcai_mcp_sqlexecutor\lzwcai_mcp_sqlexecutor\main.py", line 80, in generate_tool_schema_from_query
    tool_name = query['businessName']
                ~~~~~^^^^^^^^^^^^^^^^
KeyError: 'businessName'
2025-12-31 12:57:29 - mcp_services - ERROR - [main.py:170] - 列出工具失败: 'businessName'
Traceback (most recent call last):
  File "E:\yh-ai\project\lzwcai-szyg\lzwcai-mcp-server-package\lzwcai_mcp_sqlexecutor\lzwcai_mcp_sqlexecutor\main.py", line 162, in handle_list_tools
    tool = generate_tool_schema_from_query(query)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "E:\yh-ai\project\lzwcai-szyg\lzwcai-mcp-server-package\lzwcai_mcp_sqlexecutor\lzwcai_mcp_sqlexecutor\main.py", line 80, in generate_tool_schema_from_query
    tool_name = query['businessName']
                ~~~~~^^^^^^^^^^^^^^^^
KeyError: 'businessName'
2025-12-31 12:57:54 - mcp_services - INFO - [main.py:347] - 开始运行 MCP SQL Executor 服务器
2025-12-31 12:57:54 - mcp_services - INFO - [main.py:299] - ============================================================
2025-12-31 12:57:54 - mcp_services - INFO - [main.py:300] - 正在启动 MCP 服务器: lzwcai-mcp-sqlexecutor
2025-12-31 12:57:54 - mcp_services - INFO - [main.py:301] - 版本: 0.1.0
2025-12-31 12:57:54 - mcp_services - INFO - [main.py:302] - ============================================================
2025-12-31 12:57:54 - mcp_services - INFO - [main.py:306] - 环境配置 - Database ID: 16
2025-12-31 12:57:54 - mcp_services - INFO - [main.py:307] - 环境配置 - Skill ID: 
2025-12-31 12:57:54 - mcp_services - INFO - [main.py:308] - 环境配置 - Backend Base URL: http://192.168.11.24:8088
2025-12-31 12:57:54 - mcp_services - INFO - [main.py:309] - ============================================================
2025-12-31 12:57:54 - mcp_services - INFO - [main.py:314] - MCP 服务器已启动，等待客户端连接...
2025-12-31 12:57:54 - mcp_services - INFO - [main.py:156] - 收到列出工具请求
2025-12-31 12:57:54 - mcp_services - INFO - [main.py:119] - 初始化查询配置（数据源: local）...
2025-12-31 12:57:54 - mcp_services - INFO - [main.py:55] - 成功加载 3 个业务查询配置
2025-12-31 12:57:54 - mcp_services - INFO - [main.py:123] - 本地配置: 3 条
2025-12-31 12:57:54 - mcp_services - ERROR - [main.py:92] - 生成工具模式失败: 2006300000000000001, 错误: 'businessName'
Traceback (most recent call last):
  File "E:\yh-ai\project\lzwcai-szyg\lzwcai-mcp-server-package\lzwcai_mcp_sqlexecutor\lzwcai_mcp_sqlexecutor\main.py", line 80, in generate_tool_schema_from_query
    tool_name = query['businessName']
                ~~~~~^^^^^^^^^^^^^^^^
KeyError: 'businessName'
2025-12-31 12:57:54 - mcp_services - ERROR - [main.py:170] - 列出工具失败: 'businessName'
Traceback (most recent call last):
  File "E:\yh-ai\project\lzwcai-szyg\lzwcai-mcp-server-package\lzwcai_mcp_sqlexecutor\lzwcai_mcp_sqlexecutor\main.py", line 162, in handle_list_tools
    tool = generate_tool_schema_from_query(query)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "E:\yh-ai\project\lzwcai-szyg\lzwcai-mcp-server-package\lzwcai_mcp_sqlexecutor\lzwcai_mcp_sqlexecutor\main.py", line 80, in generate_tool_schema_from_query
    tool_name = query['businessName']
                ~~~~~^^^^^^^^^^^^^^^^
KeyError: 'businessName'
2025-12-31 15:00:31 - mcp_services - INFO - [main.py:156] - 收到列出工具请求
2025-12-31 15:00:31 - mcp_services - ERROR - [main.py:92] - 生成工具模式失败: 2006300000000000001, 错误: 'businessName'
Traceback (most recent call last):
  File "E:\yh-ai\project\lzwcai-szyg\lzwcai-mcp-server-package\lzwcai_mcp_sqlexecutor\lzwcai_mcp_sqlexecutor\main.py", line 80, in generate_tool_schema_from_query
    tool_name = query['businessName']
                ~~~~~^^^^^^^^^^^^^^^^
KeyError: 'businessName'
2025-12-31 15:00:31 - mcp_services - ERROR - [main.py:170] - 列出工具失败: 'businessName'
Traceback (most recent call last):
  File "E:\yh-ai\project\lzwcai-szyg\lzwcai-mcp-server-package\lzwcai_mcp_sqlexecutor\lzwcai_mcp_sqlexecutor\main.py", line 162, in handle_list_tools
    tool = generate_tool_schema_from_query(query)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "E:\yh-ai\project\lzwcai-szyg\lzwcai-mcp-server-package\lzwcai_mcp_sqlexecutor\lzwcai_mcp_sqlexecutor\main.py", line 80, in generate_tool_schema_from_query
    tool_name = query['businessName']
                ~~~~~^^^^^^^^^^^^^^^^
KeyError: 'businessName'
2025-12-31 15:00:34 - mcp_services - INFO - [main.py:329] - MCP 服务器已关闭
2025-12-31 15:00:53 - mcp_services - INFO - [main.py:347] - 开始运行 MCP SQL Executor 服务器
2025-12-31 15:00:53 - mcp_services - INFO - [main.py:299] - ============================================================
2025-12-31 15:00:53 - mcp_services - INFO - [main.py:300] - 正在启动 MCP 服务器: lzwcai-mcp-sqlexecutor
2025-12-31 15:00:53 - mcp_services - INFO - [main.py:301] - 版本: 0.1.0
2025-12-31 15:00:53 - mcp_services - INFO - [main.py:302] - ============================================================
2025-12-31 15:00:53 - mcp_services - INFO - [main.py:306] - 环境配置 - Database ID: 29
2025-12-31 15:00:53 - mcp_services - INFO - [main.py:307] - 环境配置 - Skill ID: 
2025-12-31 15:00:53 - mcp_services - INFO - [main.py:308] - 环境配置 - Backend Base URL: http://lzwcai-demp-corp-manager:8086
2025-12-31 15:00:53 - mcp_services - INFO - [main.py:309] - ============================================================
2025-12-31 15:00:53 - mcp_services - INFO - [main.py:314] - MCP 服务器已启动，等待客户端连接...
2025-12-31 15:00:54 - mcp_services - INFO - [main.py:156] - 收到列出工具请求
2025-12-31 15:00:54 - mcp_services - INFO - [main.py:119] - 初始化查询配置（数据源: api）...
2025-12-31 15:00:54 - mcp_services - INFO - [main.py:278] - 调用第三方API，skill_id: 
2025-12-31 15:00:56 - mcp_services - ERROR - [main.py:292] - API调用失败: API请求异常: http://lzwcai-demp-corp-manager:8086/datasource/skill/getBySkillId/, 错误: [Errno 11001] getaddrinfo failed
Traceback (most recent call last):
  File "D:\anaconda3\Lib\site-packages\httpx\_transports\default.py", line 101, in map_httpcore_exceptions
    yield
  File "D:\anaconda3\Lib\site-packages\httpx\_transports\default.py", line 250, in handle_request
    resp = self._pool.handle_request(req)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "D:\anaconda3\Lib\site-packages\httpcore\_sync\connection_pool.py", line 216, in handle_request
    raise exc from None
  File "D:\anaconda3\Lib\site-packages\httpcore\_sync\connection_pool.py", line 196, in handle_request
    response = connection.handle_request(
               ^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "D:\anaconda3\Lib\site-packages\httpcore\_sync\connection.py", line 99, in handle_request
    raise exc
  File "D:\anaconda3\Lib\site-packages\httpcore\_sync\connection.py", line 76, in handle_request
    stream = self._connect(request)
             ^^^^^^^^^^^^^^^^^^^^^^
  File "D:\anaconda3\Lib\site-packages\httpcore\_sync\connection.py", line 122, in _connect
    stream = self._network_backend.connect_tcp(**kwargs)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "D:\anaconda3\Lib\site-packages\httpcore\_backends\sync.py", line 205, in connect_tcp
    with map_exceptions(exc_map):
         ^^^^^^^^^^^^^^^^^^^^^^^
  File "D:\anaconda3\Lib\contextlib.py", line 158, in __exit__
    self.gen.throw(value)
  File "D:\anaconda3\Lib\site-packages\httpcore\_exceptions.py", line 14, in map_exceptions
    raise to_exc(exc) from exc
httpcore.ConnectError: [Errno 11001] getaddrinfo failed

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "E:\yh-ai\project\lzwcai-szyg\lzwcai-mcp-server-package\lzwcai_mcp_sqlexecutor\lzwcai_mcp_sqlexecutor\utils\api_client.py", line 74, in get_skill_by_id
    response = self.client.get(
               ^^^^^^^^^^^^^^^^
  File "D:\anaconda3\Lib\site-packages\httpx\_client.py", line 1053, in get
    return self.request(
           ^^^^^^^^^^^^^
  File "D:\anaconda3\Lib\site-packages\httpx\_client.py", line 825, in request
    return self.send(request, auth=auth, follow_redirects=follow_redirects)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "D:\anaconda3\Lib\site-packages\httpx\_client.py", line 914, in send
    response = self._send_handling_auth(
               ^^^^^^^^^^^^^^^^^^^^^^^^^
  File "D:\anaconda3\Lib\site-packages\httpx\_client.py", line 942, in _send_handling_auth
    response = self._send_handling_redirects(
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "D:\anaconda3\Lib\site-packages\httpx\_client.py", line 979, in _send_handling_redirects
    response = self._send_single_request(request)
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "D:\anaconda3\Lib\site-packages\httpx\_client.py", line 1014, in _send_single_request
    response = transport.handle_request(request)
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "D:\anaconda3\Lib\site-packages\httpx\_transports\default.py", line 249, in handle_request
    with map_httpcore_exceptions():
         ^^^^^^^^^^^^^^^^^^^^^^^^^
  File "D:\anaconda3\Lib\contextlib.py", line 158, in __exit__
    self.gen.throw(value)
  File "D:\anaconda3\Lib\site-packages\httpx\_transports\default.py", line 118, in map_httpcore_exceptions
    raise mapped_exc(message) from exc
httpx.ConnectError: [Errno 11001] getaddrinfo failed

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "E:\yh-ai\project\lzwcai-szyg\lzwcai-mcp-server-package\lzwcai_mcp_sqlexecutor\lzwcai_mcp_sqlexecutor\main.py", line 281, in call_third_party_api
    raw_result = get_skill_by_id(skill_id)
                 ^^^^^^^^^^^^^^^^^^^^^^^^^
  File "E:\yh-ai\project\lzwcai-szyg\lzwcai-mcp-server-package\lzwcai_mcp_sqlexecutor\lzwcai_mcp_sqlexecutor\utils\api_client.py", line 208, in get_skill_by_id
    return default_client.get_skill_by_id(skill_id)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "E:\yh-ai\project\lzwcai-szyg\lzwcai-mcp-server-package\lzwcai_mcp_sqlexecutor\lzwcai_mcp_sqlexecutor\utils\api_client.py", line 104, in get_skill_by_id
    raise Exception(error_msg)
Exception: API请求异常: http://lzwcai-demp-corp-manager:8086/datasource/skill/getBySkillId/, 错误: [Errno 11001] getaddrinfo failed
2025-12-31 15:00:56 - mcp_services - WARNING - [main.py:131] - API获取失败，降级使用本地配置: API请求异常: http://lzwcai-demp-corp-manager:8086/datasource/skill/getBySkillId/, 错误: [Errno 11001] getaddrinfo failed
2025-12-31 15:00:56 - mcp_services - INFO - [main.py:55] - 成功加载 0 个业务查询配置
2025-12-31 15:00:56 - mcp_services - INFO - [main.py:165] - 成功生成 0 个 MCP 工具
2025-12-31 15:00:56 - mcp_services - INFO - [main.py:156] - 收到列出工具请求
2025-12-31 15:00:56 - mcp_services - INFO - [main.py:165] - 成功生成 0 个 MCP 工具
2026-01-28 16:37:23 - mcp_services - INFO - [main.py:347] - 开始运行 MCP SQL Executor 服务器
2026-01-28 16:37:23 - mcp_services - INFO - [main.py:299] - ============================================================
2026-01-28 16:37:23 - mcp_services - INFO - [main.py:300] - 正在启动 MCP 服务器: lzwcai-mcp-sqlexecutor
2026-01-28 16:37:23 - mcp_services - INFO - [main.py:301] - 版本: 0.1.0
2026-01-28 16:37:23 - mcp_services - INFO - [main.py:302] - ============================================================
2026-01-28 16:37:23 - mcp_services - INFO - [main.py:306] - 环境配置 - Database ID: 37
2026-01-28 16:37:23 - mcp_services - INFO - [main.py:307] - 环境配置 - Skill ID: 2016416951958351874
2026-01-28 16:37:23 - mcp_services - INFO - [main.py:308] - 环境配置 - Backend Base URL: http://192.168.11.24:8088
2026-01-28 16:37:23 - mcp_services - INFO - [main.py:309] - ============================================================
2026-01-28 16:37:23 - mcp_services - INFO - [main.py:314] - MCP 服务器已启动，等待客户端连接...
2026-01-28 16:37:24 - mcp_services - INFO - [main.py:156] - 收到列出工具请求
2026-01-28 16:37:24 - mcp_services - INFO - [main.py:119] - 初始化查询配置（数据源: api）...
2026-01-28 16:37:24 - mcp_services - INFO - [main.py:278] - 调用第三方API，skill_id: 2016416951958351874
2026-01-28 16:37:24 - mcp_services - INFO - [main.py:283] - 成功{'msg': '查询成功', 'code': 200, 'data': [{'id': '2016419268577308673', 'createBy': 'heshuangfeng', 'createTime': '2026-01-28 15:53:12', 'updateBy': None, 'updateTime': None, 'serviceId': '2016416951970934785', 'uniqueName': '按付款人账号和交易日期查询资金日报', 'name': 'anfukuanrenzhanghaohejiaoyiriqichaxunzijinribao_b38c6d44', 'description': '根据指定的付款人账号和交易日期查询资金日报表中的详细交易记录，包括交易类型、金额、双方信息等完整交易明细', 'visualizable': 1, 'toolPrompt': '查询成功，返回 6 行数据，执行时间: 7ms', 'toolType': 'sql', 'datasourceId': '37', 'sqlTemplate': 'SELECT record_id AS "记录标识号", transaction_type AS "交易类型", business_type AS "业务类型", payer_account_no AS "付款人账号", payer_name AS "付款人名称", payee_account_no AS "收款人账号", payee_name AS "收款人名称", transaction_date AS "交易日期", transaction_time AS "交易时间", trade_currency AS "交易货币", trade_amount AS "交易金额", after_transaction_balance AS "交易后余额", value_date AS "起息日期", exchange_rate AS "汇率", transaction_ref_no AS "交易流水号", reference AS "摘要", purpose AS "用途" FROM funds_daily_report WHERE payer_account_no = {payerAccountNo} AND transaction_date::date = {transactionDate}::date', 'sqlParams': '{"type":"object","required":["payerAccountNo","transactionDate"],"properties":{"payerAccountNo":{"type":"string","description":"付款人账号","examples":["667866722135"]},"transactionDate":{"type":"string","description":"交易日期，格式为YYYY-MM-DD","examples":["2026-01-26"]}}}', 'resultType': 'list', 'sourceType': 'ai', 'trainingTaskId': None, 'tableMetadataIds': '', 'executionCount': 0, 'visualizationConfigs': None, 'inputJsonSchema': '{}', 'outputJsonSchema': '{"type":"object","properties":{"data":{"type":"array"}}}', 'lastExecutionTime': None}, {'id': '2016419112255598594', 'createBy': 'heshuangfeng', 'createTime': '2026-01-28 15:52:34', 'updateBy': None, 'updateTime': None, 'serviceId': '2016416951970934785', 'uniqueName': '按收款人账号和交易日期查询资金日报', 'name': 'anshoukuanrenzhanghaohejiaoyiriqichaxunzijinribao_1af995f7', 'description': '根据指定的收款人账号和交易日期查询资金日报表中的详细交易记录，包括交易类型、金额、双方信息等完整交易明细', 'visualizable': 1, 'toolPrompt': '查询成功，返回 1 行数据，执行时间: 5ms', 'toolType': 'sql', 'datasourceId': '37', 'sqlTemplate': 'SELECT record_id AS "记录标识号", transaction_type AS "交易类型", business_type AS "业务类型", payer_account_no AS "付款人账号", payer_name AS "付款人名称", payee_account_no AS "收款人账号", payee_name AS "收款人名称", transaction_date AS "交易日期", transaction_time AS "交易时间", trade_currency AS "交易货币", trade_amount AS "交易金额", after_transaction_balance AS "交易后余额", value_date AS "起息日期", exchange_rate AS "汇率", transaction_ref_no AS "交易流水号", reference AS "摘要", purpose AS "用途" FROM funds_daily_report WHERE payee_account_no = {payeeAccountNo} AND transaction_date::date = {transactionDate}::date', 'sqlParams': '{"type":"object","required":["payeeAccountNo","transactionDate"],"properties":{"payeeAccountNo":{"type":"string","description":"收款人账号","examples":["667866722135"]},"transactionDate":{"type":"string","description":"交易日期，格式为YYYY-MM-DD","examples":["2026-01-26"]}}}', 'resultType': 'list', 'sourceType': 'ai', 'trainingTaskId': None, 'tableMetadataIds': '', 'executionCount': 0, 'visualizationConfigs': None, 'inputJsonSchema': '{}', 'outputJsonSchema': '{"type":"object","properties":{"data":{"type":"array"}}}', 'lastExecutionTime': None}, {'id': '2016418808822870017', 'createBy': 'heshuangfeng', 'createTime': '2026-01-28 15:51:22', 'updateBy': None, 'updateTime': None, 'serviceId': '2016416951970934785', 'uniqueName': '按交易日期查询所有账号和账户名', 'name': 'anjiaoyiriqichaxunsuoyouzhanghaohezhanghuming_0bf10c98', 'description': '根据指定的交易日期，从资金日报表中去重查询所有付款人和收款人的账号及对应的账户名，用于了解特定日期涉及的银行账户信息', 'visualizable': 1, 'toolPrompt': '查询成功，返回 5 行数据，执行时间: 6ms', 'toolType': 'sql', 'datasourceId': '37', 'sqlTemplate': 'SELECT DISTINCT payer_account_no AS "账号", payer_name AS "账户名" FROM funds_daily_report WHERE transaction_date::date = {transactionDate}::date AND payer_account_no IS NOT NULL AND payer_name IS NOT NULL UNION SELECT DISTINCT payee_account_no AS "账号", payee_name AS "账户名" FROM funds_daily_report WHERE transaction_date::date = {transactionDate}::date AND payee_account_no IS NOT NULL AND payee_name IS NOT NULL', 'sqlParams': '{"type":"object","required":["transactionDate"],"properties":{"transactionDate":{"type":"string","description":"交易日期，格式为YYYY-MM-DD","examples":["2026-01-26"]}}}', 'resultType': 'list', 'sourceType': 'ai', 'trainingTaskId': None, 'tableMetadataIds': '', 'executionCount': 0, 'visualizationConfigs': None, 'inputJsonSchema': '{}', 'outputJsonSchema': '{"type":"object","properties":{"data":{"type":"array"}}}', 'lastExecutionTime': None}]}
2026-01-28 16:37:24 - mcp_services - INFO - [main.py:288] - 成功获取并处理 3 条数据
2026-01-28 16:37:24 - mcp_services - INFO - [main.py:128] - API配置: 3 条
2026-01-28 16:37:24 - mcp_services - INFO - [main.py:129] - API配置数组: [{'id': '2016419268577308673', 'businessName': 'anfukuanrenzhanghaohejiaoyiriqichaxunzijinribao_b38c6d44', 'businessDescription': '根据指定的付款人账号和交易日期查询资金日报表中的详细交易记录，包括交易类型、金额、双方信息等完整交易明细', 'sqlTemplate': 'SELECT record_id AS "记录标识号", transaction_type AS "交易类型", business_type AS "业务类型", payer_account_no AS "付款人账号", payer_name AS "付款人名称", payee_account_no AS "收款人账号", payee_name AS "收款人名称", transaction_date AS "交易日期", transaction_time AS "交易时间", trade_currency AS "交易货币", trade_amount AS "交易金额", after_transaction_balance AS "交易后余额", value_date AS "起息日期", exchange_rate AS "汇率", transaction_ref_no AS "交易流水号", reference AS "摘要", purpose AS "用途" FROM funds_daily_report WHERE payer_account_no = {payerAccountNo} AND transaction_date::date = {transactionDate}::date', 'parameters': {'type': 'object', 'required': ['payerAccountNo', 'transactionDate'], 'properties': {'payerAccountNo': {'type': 'string', 'description': '付款人账号', 'examples': ['667866722135']}, 'transactionDate': {'type': 'string', 'description': '交易日期，格式为YYYY-MM-DD', 'examples': ['2026-01-26']}}}, 'datasourceId': '37'}, {'id': '2016419112255598594', 'businessName': 'anshoukuanrenzhanghaohejiaoyiriqichaxunzijinribao_1af995f7', 'businessDescription': '根据指定的收款人账号和交易日期查询资金日报表中的详细交易记录，包括交易类型、金额、双方信息等完整交易明细', 'sqlTemplate': 'SELECT record_id AS "记录标识号", transaction_type AS "交易类型", business_type AS "业务类型", payer_account_no AS "付款人账号", payer_name AS "付款人名称", payee_account_no AS "收款人账号", payee_name AS "收款人名称", transaction_date AS "交易日期", transaction_time AS "交易时间", trade_currency AS "交易货币", trade_amount AS "交易金额", after_transaction_balance AS "交易后余额", value_date AS "起息日期", exchange_rate AS "汇率", transaction_ref_no AS "交易流水号", reference AS "摘要", purpose AS "用途" FROM funds_daily_report WHERE payee_account_no = {payeeAccountNo} AND transaction_date::date = {transactionDate}::date', 'parameters': {'type': 'object', 'required': ['payeeAccountNo', 'transactionDate'], 'properties': {'payeeAccountNo': {'type': 'string', 'description': '收款人账号', 'examples': ['667866722135']}, 'transactionDate': {'type': 'string', 'description': '交易日期，格式为YYYY-MM-DD', 'examples': ['2026-01-26']}}}, 'datasourceId': '37'}, {'id': '2016418808822870017', 'businessName': 'anjiaoyiriqichaxunsuoyouzhanghaohezhanghuming_0bf10c98', 'businessDescription': '根据指定的交易日期，从资金日报表中去重查询所有付款人和收款人的账号及对应的账户名，用于了解特定日期涉及的银行账户信息', 'sqlTemplate': 'SELECT DISTINCT payer_account_no AS "账号", payer_name AS "账户名" FROM funds_daily_report WHERE transaction_date::date = {transactionDate}::date AND payer_account_no IS NOT NULL AND payer_name IS NOT NULL UNION SELECT DISTINCT payee_account_no AS "账号", payee_name AS "账户名" FROM funds_daily_report WHERE transaction_date::date = {transactionDate}::date AND payee_account_no IS NOT NULL AND payee_name IS NOT NULL', 'parameters': {'type': 'object', 'required': ['transactionDate'], 'properties': {'transactionDate': {'type': 'string', 'description': '交易日期，格式为YYYY-MM-DD', 'examples': ['2026-01-26']}}}, 'datasourceId': '37'}]
2026-01-28 16:37:24 - mcp_services - INFO - [main.py:165] - 成功生成 3 个 MCP 工具
2026-01-28 21:35:19 - mcp_services - INFO - [main.py:347] - 开始运行 MCP SQL Executor 服务器
2026-01-28 21:35:19 - mcp_services - INFO - [main.py:299] - ============================================================
2026-01-28 21:35:19 - mcp_services - INFO - [main.py:300] - 正在启动 MCP 服务器: lzwcai-mcp-sqlexecutor
2026-01-28 21:35:19 - mcp_services - INFO - [main.py:301] - 版本: 0.1.0
2026-01-28 21:35:19 - mcp_services - INFO - [main.py:302] - ============================================================
2026-01-28 21:35:19 - mcp_services - INFO - [main.py:306] - 环境配置 - Database ID: 37
2026-01-28 21:35:19 - mcp_services - INFO - [main.py:307] - 环境配置 - Skill ID: 2016416951958351874
2026-01-28 21:35:19 - mcp_services - INFO - [main.py:308] - 环境配置 - Backend Base URL: http://192.168.11.24:8088
2026-01-28 21:35:19 - mcp_services - INFO - [main.py:309] - ============================================================
2026-01-28 21:35:19 - mcp_services - INFO - [main.py:314] - MCP 服务器已启动，等待客户端连接...
2026-01-28 21:35:20 - mcp_services - INFO - [main.py:156] - 收到列出工具请求
2026-01-28 21:35:20 - mcp_services - INFO - [main.py:119] - 初始化查询配置（数据源: api）...
2026-01-28 21:35:20 - mcp_services - INFO - [main.py:278] - 调用第三方API，skill_id: 2016416951958351874
2026-01-28 21:35:20 - mcp_services - INFO - [main.py:283] - 成功{'msg': '查询成功', 'code': 200, 'data': [{'id': '2016419268577308673', 'createBy': 'heshuangfeng', 'createTime': '2026-01-28 15:53:12', 'updateBy': 'yy8z7', 'updateTime': '2026-01-28 20:53:14', 'serviceId': '2016416951970934785', 'uniqueName': '按付款人账号和交易日期查询资金日报', 'name': 'anfukuanrenzhanghaohejiaoyiriqichaxunzijinribao_b38c6d44', 'description': 'anfukuanrenzhanghaohejiaoyiriqichaxunzijinribao_b38c6d44: anfukuanrenzhanghaohejiaoyiriqichaxunzijinribao_b38c6d44: anfukuanrenzhanghaohejiaoyiriqichaxunzijinribao_b38c6d44: 根据指定的付款人账号和交易日期查询资金日报表中的详细交易记录，包括交易类型、金额、双方信息等完整交易明细', 'visualizable': 1, 'toolPrompt': '查询成功，返回 6 行数据，执行时间: 7ms', 'toolType': 'sql', 'datasourceId': '37', 'sqlTemplate': 'SELECT record_id AS "记录标识号", transaction_type AS "交易类型", business_type AS "业务类型", payer_account_no AS "付款人账号", payer_name AS "付款人名称", payee_account_no AS "收款人账号", payee_name AS "收款人名称", transaction_date AS "交易日期", transaction_time AS "交易时间", trade_currency AS "交易货币", trade_amount AS "交易金额", after_transaction_balance AS "交易后余额", value_date AS "起息日期", exchange_rate AS "汇率", transaction_ref_no AS "交易流水号", reference AS "摘要", purpose AS "用途" FROM funds_daily_report WHERE payer_account_no = {payerAccountNo} AND transaction_date::date = {transactionDate}::date', 'sqlParams': '{"type":"object","required":["payerAccountNo","transactionDate"],"properties":{"payerAccountNo":{"type":"string","description":"付款人账号","examples":["667866722135"]},"transactionDate":{"type":"string","description":"交易日期，格式为YYYY-MM-DD","examples":["2026-01-26"]}}}', 'resultType': 'list', 'sourceType': 'ai', 'trainingTaskId': None, 'tableMetadataIds': '', 'executionCount': 0, 'visualizationConfigs': None, 'inputJsonSchema': '{"type":"object","required":["payerAccountNo","transactionDate"],"properties":{"payerAccountNo":{"type":"string","description":"付款人账号","examples":["667866722135"]},"transactionDate":{"type":"string","description":"交易日期，格式为YYYY-MM-DD","examples":["2026-01-26"]},"targetDatabaseName":{"type":"string","description":"目标数据库名称"}}}', 'outputJsonSchema': '{"type":"object","properties":{"text":{"type":"string"}},"additionalProperties":false}', 'lastExecutionTime': None}, {'id': '2016419112255598594', 'createBy': 'heshuangfeng', 'createTime': '2026-01-28 15:52:34', 'updateBy': 'yy8z7', 'updateTime': '2026-01-28 20:53:14', 'serviceId': '2016416951970934785', 'uniqueName': '按收款人账号和交易日期查询资金日报', 'name': 'anshoukuanrenzhanghaohejiaoyiriqichaxunzijinribao_1af995f7', 'description': 'anshoukuanrenzhanghaohejiaoyiriqichaxunzijinribao_1af995f7: anshoukuanrenzhanghaohejiaoyiriqichaxunzijinribao_1af995f7: anshoukuanrenzhanghaohejiaoyiriqichaxunzijinribao_1af995f7: 根据指定的收款人账号和交易日期查询资金日报表中的详细交易记录，包括交易类型、金额、双方信息等完整交易明细', 'visualizable': 1, 'toolPrompt': '查询成功，返回 1 行数据，执行时间: 5ms', 'toolType': 'sql', 'datasourceId': '37', 'sqlTemplate': 'SELECT record_id AS "记录标识号", transaction_type AS "交易类型", business_type AS "业务类型", payer_account_no AS "付款人账号", payer_name AS "付款人名称", payee_account_no AS "收款人账号", payee_name AS "收款人名称", transaction_date AS "交易日期", transaction_time AS "交易时间", trade_currency AS "交易货币", trade_amount AS "交易金额", after_transaction_balance AS "交易后余额", value_date AS "起息日期", exchange_rate AS "汇率", transaction_ref_no AS "交易流水号", reference AS "摘要", purpose AS "用途" FROM funds_daily_report WHERE payee_account_no = {payeeAccountNo} AND transaction_date::date = {transactionDate}::date', 'sqlParams': '{"type":"object","required":["payeeAccountNo","transactionDate"],"properties":{"payeeAccountNo":{"type":"string","description":"收款人账号","examples":["667866722135"]},"transactionDate":{"type":"string","description":"交易日期，格式为YYYY-MM-DD","examples":["2026-01-26"]}}}', 'resultType': 'list', 'sourceType': 'ai', 'trainingTaskId': None, 'tableMetadataIds': '', 'executionCount': 0, 'visualizationConfigs': None, 'inputJsonSchema': '{"type":"object","required":["payeeAccountNo","transactionDate"],"properties":{"payeeAccountNo":{"type":"string","description":"收款人账号","examples":["667866722135"]},"transactionDate":{"type":"string","description":"交易日期，格式为YYYY-MM-DD","examples":["2026-01-26"]},"targetDatabaseName":{"type":"string","description":"目标数据库名称"}}}', 'outputJsonSchema': '{"type":"object","properties":{"text":{"type":"string"}},"additionalProperties":false}', 'lastExecutionTime': None}, {'id': '2016418808822870017', 'createBy': 'heshuangfeng', 'createTime': '2026-01-28 15:51:22', 'updateBy': 'yy8z7', 'updateTime': '2026-01-28 20:53:14', 'serviceId': '2016416951970934785', 'uniqueName': '按交易日期查询所有账号和账户名', 'name': 'anjiaoyiriqichaxunsuoyouzhanghaohezhanghuming_0bf10c98', 'description': 'anjiaoyiriqichaxunsuoyouzhanghaohezhanghuming_0bf10c98: anjiaoyiriqichaxunsuoyouzhanghaohezhanghuming_0bf10c98: anjiaoyiriqichaxunsuoyouzhanghaohezhanghuming_0bf10c98: 根据指定的交易日期，从资金日报表中去重查询所有付款人和收款人的账号及对应的账户名，用于了解特定日期涉及的银行账户信息', 'visualizable': 1, 'toolPrompt': '查询成功，返回 5 行数据，执行时间: 6ms', 'toolType': 'sql', 'datasourceId': '37', 'sqlTemplate': 'SELECT DISTINCT payer_account_no AS "账号", payer_name AS "账户名" FROM funds_daily_report WHERE transaction_date::date = {transactionDate}::date AND payer_account_no IS NOT NULL AND payer_name IS NOT NULL UNION SELECT DISTINCT payee_account_no AS "账号", payee_name AS "账户名" FROM funds_daily_report WHERE transaction_date::date = {transactionDate}::date AND payee_account_no IS NOT NULL AND payee_name IS NOT NULL', 'sqlParams': '{"type":"object","required":["transactionDate"],"properties":{"transactionDate":{"type":"string","description":"交易日期，格式为YYYY-MM-DD","examples":["2026-01-26"]}}}', 'resultType': 'list', 'sourceType': 'ai', 'trainingTaskId': None, 'tableMetadataIds': '', 'executionCount': 0, 'visualizationConfigs': None, 'inputJsonSchema': '{"type":"object","required":["transactionDate"],"properties":{"transactionDate":{"type":"string","description":"交易日期，格式为YYYY-MM-DD","examples":["2026-01-26"]},"targetDatabaseName":{"type":"string","description":"目标数据库名称"}}}', 'outputJsonSchema': '{"type":"object","properties":{"text":{"type":"string"}},"additionalProperties":false}', 'lastExecutionTime': None}]}
2026-01-28 21:35:20 - mcp_services - INFO - [main.py:288] - 成功获取并处理 3 条数据
2026-01-28 21:35:20 - mcp_services - INFO - [main.py:128] - API配置: 3 条
2026-01-28 21:35:20 - mcp_services - INFO - [main.py:129] - API配置数组: [{'id': '2016419268577308673', 'businessName': 'anfukuanrenzhanghaohejiaoyiriqichaxunzijinribao_b38c6d44', 'businessDescription': 'anfukuanrenzhanghaohejiaoyiriqichaxunzijinribao_b38c6d44: anfukuanrenzhanghaohejiaoyiriqichaxunzijinribao_b38c6d44: anfukuanrenzhanghaohejiaoyiriqichaxunzijinribao_b38c6d44: 根据指定的付款人账号和交易日期查询资金日报表中的详细交易记录，包括交易类型、金额、双方信息等完整交易明细', 'sqlTemplate': 'SELECT record_id AS "记录标识号", transaction_type AS "交易类型", business_type AS "业务类型", payer_account_no AS "付款人账号", payer_name AS "付款人名称", payee_account_no AS "收款人账号", payee_name AS "收款人名称", transaction_date AS "交易日期", transaction_time AS "交易时间", trade_currency AS "交易货币", trade_amount AS "交易金额", after_transaction_balance AS "交易后余额", value_date AS "起息日期", exchange_rate AS "汇率", transaction_ref_no AS "交易流水号", reference AS "摘要", purpose AS "用途" FROM funds_daily_report WHERE payer_account_no = {payerAccountNo} AND transaction_date::date = {transactionDate}::date', 'parameters': {'type': 'object', 'required': ['payerAccountNo', 'transactionDate'], 'properties': {'payerAccountNo': {'type': 'string', 'description': '付款人账号', 'examples': ['667866722135']}, 'transactionDate': {'type': 'string', 'description': '交易日期，格式为YYYY-MM-DD', 'examples': ['2026-01-26']}}}, 'datasourceId': '37'}, {'id': '2016419112255598594', 'businessName': 'anshoukuanrenzhanghaohejiaoyiriqichaxunzijinribao_1af995f7', 'businessDescription': 'anshoukuanrenzhanghaohejiaoyiriqichaxunzijinribao_1af995f7: anshoukuanrenzhanghaohejiaoyiriqichaxunzijinribao_1af995f7: anshoukuanrenzhanghaohejiaoyiriqichaxunzijinribao_1af995f7: 根据指定的收款人账号和交易日期查询资金日报表中的详细交易记录，包括交易类型、金额、双方信息等完整交易明细', 'sqlTemplate': 'SELECT record_id AS "记录标识号", transaction_type AS "交易类型", business_type AS "业务类型", payer_account_no AS "付款人账号", payer_name AS "付款人名称", payee_account_no AS "收款人账号", payee_name AS "收款人名称", transaction_date AS "交易日期", transaction_time AS "交易时间", trade_currency AS "交易货币", trade_amount AS "交易金额", after_transaction_balance AS "交易后余额", value_date AS "起息日期", exchange_rate AS "汇率", transaction_ref_no AS "交易流水号", reference AS "摘要", purpose AS "用途" FROM funds_daily_report WHERE payee_account_no = {payeeAccountNo} AND transaction_date::date = {transactionDate}::date', 'parameters': {'type': 'object', 'required': ['payeeAccountNo', 'transactionDate'], 'properties': {'payeeAccountNo': {'type': 'string', 'description': '收款人账号', 'examples': ['667866722135']}, 'transactionDate': {'type': 'string', 'description': '交易日期，格式为YYYY-MM-DD', 'examples': ['2026-01-26']}}}, 'datasourceId': '37'}, {'id': '2016418808822870017', 'businessName': 'anjiaoyiriqichaxunsuoyouzhanghaohezhanghuming_0bf10c98', 'businessDescription': 'anjiaoyiriqichaxunsuoyouzhanghaohezhanghuming_0bf10c98: anjiaoyiriqichaxunsuoyouzhanghaohezhanghuming_0bf10c98: anjiaoyiriqichaxunsuoyouzhanghaohezhanghuming_0bf10c98: 根据指定的交易日期，从资金日报表中去重查询所有付款人和收款人的账号及对应的账户名，用于了解特定日期涉及的银行账户信息', 'sqlTemplate': 'SELECT DISTINCT payer_account_no AS "账号", payer_name AS "账户名" FROM funds_daily_report WHERE transaction_date::date = {transactionDate}::date AND payer_account_no IS NOT NULL AND payer_name IS NOT NULL UNION SELECT DISTINCT payee_account_no AS "账号", payee_name AS "账户名" FROM funds_daily_report WHERE transaction_date::date = {transactionDate}::date AND payee_account_no IS NOT NULL AND payee_name IS NOT NULL', 'parameters': {'type': 'object', 'required': ['transactionDate'], 'properties': {'transactionDate': {'type': 'string', 'description': '交易日期，格式为YYYY-MM-DD', 'examples': ['2026-01-26']}}}, 'datasourceId': '37'}]
2026-01-28 21:35:20 - mcp_services - INFO - [main.py:165] - 成功生成 3 个 MCP 工具
2026-01-28 21:36:46 - mcp_services - INFO - [main.py:329] - MCP 服务器已关闭
2026-01-28 21:44:42 - mcp_services - INFO - [main.py:347] - 开始运行 MCP SQL Executor 服务器
2026-01-28 21:44:42 - mcp_services - INFO - [main.py:299] - ============================================================
2026-01-28 21:44:42 - mcp_services - INFO - [main.py:300] - 正在启动 MCP 服务器: lzwcai-mcp-sqlexecutor
2026-01-28 21:44:42 - mcp_services - INFO - [main.py:301] - 版本: 0.1.0
2026-01-28 21:44:42 - mcp_services - INFO - [main.py:302] - ============================================================
2026-01-28 21:44:42 - mcp_services - INFO - [main.py:306] - 环境配置 - Database ID: 37
2026-01-28 21:44:42 - mcp_services - INFO - [main.py:307] - 环境配置 - Skill ID: 2016416951958351874
2026-01-28 21:44:42 - mcp_services - INFO - [main.py:308] - 环境配置 - Backend Base URL: http://192.168.11.24:8088
2026-01-28 21:44:42 - mcp_services - INFO - [main.py:309] - ============================================================
2026-01-28 21:44:42 - mcp_services - INFO - [main.py:314] - MCP 服务器已启动，等待客户端连接...
2026-01-28 21:49:54 - mcp_services - INFO - [main.py:156] - 收到列出工具请求
2026-01-28 21:49:54 - mcp_services - INFO - [main.py:119] - 初始化查询配置（数据源: api）...
2026-01-28 21:49:54 - mcp_services - INFO - [main.py:278] - 调用第三方API，skill_id: 2016416951958351874
2026-01-28 21:49:54 - mcp_services - INFO - [main.py:283] - 成功{'msg': '查询成功', 'code': 200, 'data': [{'id': '2016419268577308673', 'createBy': 'heshuangfeng', 'createTime': '2026-01-28 15:53:12', 'updateBy': 'yy8z7', 'updateTime': '2026-01-28 20:53:14', 'serviceId': '2016416951970934785', 'uniqueName': '按付款人账号和交易日期查询资金日报', 'name': 'anfukuanrenzhanghaohejiaoyiriqichaxunzijinribao_b38c6d44', 'description': 'anfukuanrenzhanghaohejiaoyiriqichaxunzijinribao_b38c6d44: anfukuanrenzhanghaohejiaoyiriqichaxunzijinribao_b38c6d44: anfukuanrenzhanghaohejiaoyiriqichaxunzijinribao_b38c6d44: 根据指定的付款人账号和交易日期查询资金日报表中的详细交易记录，包括交易类型、金额、双方信息等完整交易明细', 'visualizable': 1, 'toolPrompt': '查询成功，返回 6 行数据，执行时间: 7ms', 'toolType': 'sql', 'datasourceId': '37', 'sqlTemplate': 'SELECT record_id AS "记录标识号", transaction_type AS "交易类型", business_type AS "业务类型", payer_account_no AS "付款人账号", payer_name AS "付款人名称", payee_account_no AS "收款人账号", payee_name AS "收款人名称", transaction_date AS "交易日期", transaction_time AS "交易时间", trade_currency AS "交易货币", trade_amount AS "交易金额", after_transaction_balance AS "交易后余额", value_date AS "起息日期", exchange_rate AS "汇率", transaction_ref_no AS "交易流水号", reference AS "摘要", purpose AS "用途" FROM funds_daily_report WHERE payer_account_no = {payerAccountNo} AND transaction_date::date = {transactionDate}::date', 'sqlParams': '{"type":"object","required":["payerAccountNo","transactionDate"],"properties":{"payerAccountNo":{"type":"string","description":"付款人账号","examples":["667866722135"]},"transactionDate":{"type":"string","description":"交易日期，格式为YYYY-MM-DD","examples":["2026-01-26"]}}}', 'resultType': 'list', 'sourceType': 'ai', 'trainingTaskId': None, 'tableMetadataIds': '', 'executionCount': 0, 'visualizationConfigs': None, 'inputJsonSchema': '{"type":"object","required":["payerAccountNo","transactionDate"],"properties":{"payerAccountNo":{"type":"string","description":"付款人账号","examples":["667866722135"]},"transactionDate":{"type":"string","description":"交易日期，格式为YYYY-MM-DD","examples":["2026-01-26"]},"targetDatabaseName":{"type":"string","description":"目标数据库名称"}}}', 'outputJsonSchema': '{"type":"object","properties":{"text":{"type":"string"}},"additionalProperties":false}', 'lastExecutionTime': None}, {'id': '2016419112255598594', 'createBy': 'heshuangfeng', 'createTime': '2026-01-28 15:52:34', 'updateBy': 'yy8z7', 'updateTime': '2026-01-28 20:53:14', 'serviceId': '2016416951970934785', 'uniqueName': '按收款人账号和交易日期查询资金日报', 'name': 'anshoukuanrenzhanghaohejiaoyiriqichaxunzijinribao_1af995f7', 'description': 'anshoukuanrenzhanghaohejiaoyiriqichaxunzijinribao_1af995f7: anshoukuanrenzhanghaohejiaoyiriqichaxunzijinribao_1af995f7: anshoukuanrenzhanghaohejiaoyiriqichaxunzijinribao_1af995f7: 根据指定的收款人账号和交易日期查询资金日报表中的详细交易记录，包括交易类型、金额、双方信息等完整交易明细', 'visualizable': 1, 'toolPrompt': '查询成功，返回 1 行数据，执行时间: 5ms', 'toolType': 'sql', 'datasourceId': '37', 'sqlTemplate': 'SELECT record_id AS "记录标识号", transaction_type AS "交易类型", business_type AS "业务类型", payer_account_no AS "付款人账号", payer_name AS "付款人名称", payee_account_no AS "收款人账号", payee_name AS "收款人名称", transaction_date AS "交易日期", transaction_time AS "交易时间", trade_currency AS "交易货币", trade_amount AS "交易金额", after_transaction_balance AS "交易后余额", value_date AS "起息日期", exchange_rate AS "汇率", transaction_ref_no AS "交易流水号", reference AS "摘要", purpose AS "用途" FROM funds_daily_report WHERE payee_account_no = {payeeAccountNo} AND transaction_date::date = {transactionDate}::date', 'sqlParams': '{"type":"object","required":["payeeAccountNo","transactionDate"],"properties":{"payeeAccountNo":{"type":"string","description":"收款人账号","examples":["667866722135"]},"transactionDate":{"type":"string","description":"交易日期，格式为YYYY-MM-DD","examples":["2026-01-26"]}}}', 'resultType': 'list', 'sourceType': 'ai', 'trainingTaskId': None, 'tableMetadataIds': '', 'executionCount': 0, 'visualizationConfigs': None, 'inputJsonSchema': '{"type":"object","required":["payeeAccountNo","transactionDate"],"properties":{"payeeAccountNo":{"type":"string","description":"收款人账号","examples":["667866722135"]},"transactionDate":{"type":"string","description":"交易日期，格式为YYYY-MM-DD","examples":["2026-01-26"]},"targetDatabaseName":{"type":"string","description":"目标数据库名称"}}}', 'outputJsonSchema': '{"type":"object","properties":{"text":{"type":"string"}},"additionalProperties":false}', 'lastExecutionTime': None}, {'id': '2016418808822870017', 'createBy': 'heshuangfeng', 'createTime': '2026-01-28 15:51:22', 'updateBy': 'yy8z7', 'updateTime': '2026-01-28 20:53:14', 'serviceId': '2016416951970934785', 'uniqueName': '按交易日期查询所有账号和账户名', 'name': 'anjiaoyiriqichaxunsuoyouzhanghaohezhanghuming_0bf10c98', 'description': 'anjiaoyiriqichaxunsuoyouzhanghaohezhanghuming_0bf10c98: anjiaoyiriqichaxunsuoyouzhanghaohezhanghuming_0bf10c98: anjiaoyiriqichaxunsuoyouzhanghaohezhanghuming_0bf10c98: 根据指定的交易日期，从资金日报表中去重查询所有付款人和收款人的账号及对应的账户名，用于了解特定日期涉及的银行账户信息', 'visualizable': 1, 'toolPrompt': '查询成功，返回 5 行数据，执行时间: 6ms', 'toolType': 'sql', 'datasourceId': '37', 'sqlTemplate': 'SELECT DISTINCT payer_account_no AS "账号", payer_name AS "账户名" FROM funds_daily_report WHERE transaction_date::date = {transactionDate}::date AND payer_account_no IS NOT NULL AND payer_name IS NOT NULL UNION SELECT DISTINCT payee_account_no AS "账号", payee_name AS "账户名" FROM funds_daily_report WHERE transaction_date::date = {transactionDate}::date AND payee_account_no IS NOT NULL AND payee_name IS NOT NULL', 'sqlParams': '{"type":"object","required":["transactionDate"],"properties":{"transactionDate":{"type":"string","description":"交易日期，格式为YYYY-MM-DD","examples":["2026-01-26"]}}}', 'resultType': 'list', 'sourceType': 'ai', 'trainingTaskId': None, 'tableMetadataIds': '', 'executionCount': 0, 'visualizationConfigs': None, 'inputJsonSchema': '{"type":"object","required":["transactionDate"],"properties":{"transactionDate":{"type":"string","description":"交易日期，格式为YYYY-MM-DD","examples":["2026-01-26"]},"targetDatabaseName":{"type":"string","description":"目标数据库名称"}}}', 'outputJsonSchema': '{"type":"object","properties":{"text":{"type":"string"}},"additionalProperties":false}', 'lastExecutionTime': None}]}
2026-01-28 21:49:54 - mcp_services - INFO - [main.py:288] - 成功获取并处理 3 条数据
2026-01-28 21:49:54 - mcp_services - INFO - [main.py:128] - API配置: 3 条
2026-01-28 21:49:54 - mcp_services - INFO - [main.py:129] - API配置数组: [{'id': '2016419268577308673', 'businessName': 'anfukuanrenzhanghaohejiaoyiriqichaxunzijinribao_b38c6d44', 'businessDescription': 'anfukuanrenzhanghaohejiaoyiriqichaxunzijinribao_b38c6d44: anfukuanrenzhanghaohejiaoyiriqichaxunzijinribao_b38c6d44: anfukuanrenzhanghaohejiaoyiriqichaxunzijinribao_b38c6d44: 根据指定的付款人账号和交易日期查询资金日报表中的详细交易记录，包括交易类型、金额、双方信息等完整交易明细', 'sqlTemplate': 'SELECT record_id AS "记录标识号", transaction_type AS "交易类型", business_type AS "业务类型", payer_account_no AS "付款人账号", payer_name AS "付款人名称", payee_account_no AS "收款人账号", payee_name AS "收款人名称", transaction_date AS "交易日期", transaction_time AS "交易时间", trade_currency AS "交易货币", trade_amount AS "交易金额", after_transaction_balance AS "交易后余额", value_date AS "起息日期", exchange_rate AS "汇率", transaction_ref_no AS "交易流水号", reference AS "摘要", purpose AS "用途" FROM funds_daily_report WHERE payer_account_no = {payerAccountNo} AND transaction_date::date = {transactionDate}::date', 'parameters': {'type': 'object', 'required': ['payerAccountNo', 'transactionDate'], 'properties': {'payerAccountNo': {'type': 'string', 'description': '付款人账号', 'examples': ['667866722135']}, 'transactionDate': {'type': 'string', 'description': '交易日期，格式为YYYY-MM-DD', 'examples': ['2026-01-26']}}}, 'datasourceId': '37'}, {'id': '2016419112255598594', 'businessName': 'anshoukuanrenzhanghaohejiaoyiriqichaxunzijinribao_1af995f7', 'businessDescription': 'anshoukuanrenzhanghaohejiaoyiriqichaxunzijinribao_1af995f7: anshoukuanrenzhanghaohejiaoyiriqichaxunzijinribao_1af995f7: anshoukuanrenzhanghaohejiaoyiriqichaxunzijinribao_1af995f7: 根据指定的收款人账号和交易日期查询资金日报表中的详细交易记录，包括交易类型、金额、双方信息等完整交易明细', 'sqlTemplate': 'SELECT record_id AS "记录标识号", transaction_type AS "交易类型", business_type AS "业务类型", payer_account_no AS "付款人账号", payer_name AS "付款人名称", payee_account_no AS "收款人账号", payee_name AS "收款人名称", transaction_date AS "交易日期", transaction_time AS "交易时间", trade_currency AS "交易货币", trade_amount AS "交易金额", after_transaction_balance AS "交易后余额", value_date AS "起息日期", exchange_rate AS "汇率", transaction_ref_no AS "交易流水号", reference AS "摘要", purpose AS "用途" FROM funds_daily_report WHERE payee_account_no = {payeeAccountNo} AND transaction_date::date = {transactionDate}::date', 'parameters': {'type': 'object', 'required': ['payeeAccountNo', 'transactionDate'], 'properties': {'payeeAccountNo': {'type': 'string', 'description': '收款人账号', 'examples': ['667866722135']}, 'transactionDate': {'type': 'string', 'description': '交易日期，格式为YYYY-MM-DD', 'examples': ['2026-01-26']}}}, 'datasourceId': '37'}, {'id': '2016418808822870017', 'businessName': 'anjiaoyiriqichaxunsuoyouzhanghaohezhanghuming_0bf10c98', 'businessDescription': 'anjiaoyiriqichaxunsuoyouzhanghaohezhanghuming_0bf10c98: anjiaoyiriqichaxunsuoyouzhanghaohezhanghuming_0bf10c98: anjiaoyiriqichaxunsuoyouzhanghaohezhanghuming_0bf10c98: 根据指定的交易日期，从资金日报表中去重查询所有付款人和收款人的账号及对应的账户名，用于了解特定日期涉及的银行账户信息', 'sqlTemplate': 'SELECT DISTINCT payer_account_no AS "账号", payer_name AS "账户名" FROM funds_daily_report WHERE transaction_date::date = {transactionDate}::date AND payer_account_no IS NOT NULL AND payer_name IS NOT NULL UNION SELECT DISTINCT payee_account_no AS "账号", payee_name AS "账户名" FROM funds_daily_report WHERE transaction_date::date = {transactionDate}::date AND payee_account_no IS NOT NULL AND payee_name IS NOT NULL', 'parameters': {'type': 'object', 'required': ['transactionDate'], 'properties': {'transactionDate': {'type': 'string', 'description': '交易日期，格式为YYYY-MM-DD', 'examples': ['2026-01-26']}}}, 'datasourceId': '37'}]
2026-01-28 21:49:54 - mcp_services - INFO - [main.py:165] - 成功生成 3 个 MCP 工具
2026-01-28 21:49:54 - mcp_services - INFO - [main.py:190] - 收到工具调用请求: anfukuanrenzhanghaohejiaoyiriqichaxunzijinribao_b38c6d44
2026-01-28 21:49:54 - mcp_services - INFO - [main.py:225] - 正在调用测试SQL API...
2026-01-28 21:49:54 - mcp_services - INFO - [main.py:227] - 测试SQL API调用成功
2026-01-28 21:50:18 - mcp_services - INFO - [main.py:190] - 收到工具调用请求: anjiaoyiriqichaxunsuoyouzhanghaohezhanghuming_0bf10c98
2026-01-28 21:50:18 - mcp_services - INFO - [main.py:225] - 正在调用测试SQL API...
2026-01-28 21:50:18 - mcp_services - INFO - [main.py:227] - 测试SQL API调用成功
