2026-01-28 16:37:23 - root - INFO - [logger_config.py:151] - 日志系统初始化完成 - 日志目录: E:\yh-ai\project\lzwcai-szyg\lzwcai-mcp-server-package\lzwcai_mcp_sqlexecutor\lzwcai_mcp_sqlexecutor\logs
2026-01-28 16:37:23 - root - INFO - [logger_config.py:152] - 日志配置 - 级别: INFO, 文件大小限制: 10MB, 备份数量: 5
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.server.lowlevel.server - INFO - [server.py:619] - Processing request of type ListToolsRequest
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 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:71] - 正在调用API: http://192.168.11.24:8088/datasource/skill/getBySkillId/2016416951958351874
2026-01-28 16:37:24 - httpx - INFO - [_client.py:1025] - HTTP Request: GET http://192.168.11.24:8088/datasource/skill/getBySkillId/2016416951958351874 "HTTP/1.1 200 "
2026-01-28 16:37:24 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:85] - API调用成功: http://192.168.11.24:8088/datasource/skill/getBySkillId/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 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:322] - 成功处理 3 条技能数据
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 - root - INFO - [logger_config.py:151] - 日志系统初始化完成 - 日志目录: E:\yh-ai\project\lzwcai-szyg\lzwcai-mcp-server-package\lzwcai_mcp_sqlexecutor\lzwcai_mcp_sqlexecutor\logs
2026-01-28 21:35:19 - root - INFO - [logger_config.py:152] - 日志配置 - 级别: INFO, 文件大小限制: 10MB, 备份数量: 5
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.server.lowlevel.server - INFO - [server.py:619] - Processing request of type ListToolsRequest
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 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:71] - 正在调用API: http://192.168.11.24:8088/datasource/skill/getBySkillId/2016416951958351874
2026-01-28 21:35:20 - httpx - INFO - [_client.py:1025] - HTTP Request: GET http://192.168.11.24:8088/datasource/skill/getBySkillId/2016416951958351874 "HTTP/1.1 200 "
2026-01-28 21:35:20 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:85] - API调用成功: http://192.168.11.24:8088/datasource/skill/getBySkillId/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 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:322] - 成功处理 3 条技能数据
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 - root - INFO - [logger_config.py:151] - 日志系统初始化完成 - 日志目录: E:\yh-ai\project\lzwcai-szyg\lzwcai-mcp-server-package\lzwcai_mcp_sqlexecutor\lzwcai_mcp_sqlexecutor\logs
2026-01-28 21:44:42 - root - INFO - [logger_config.py:152] - 日志配置 - 级别: INFO, 文件大小限制: 10MB, 备份数量: 5
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.server.lowlevel.server - INFO - [server.py:619] - Processing request of type CallToolRequest
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 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:71] - 正在调用API: http://192.168.11.24:8088/datasource/skill/getBySkillId/2016416951958351874
2026-01-28 21:49:54 - httpx - INFO - [_client.py:1025] - HTTP Request: GET http://192.168.11.24:8088/datasource/skill/getBySkillId/2016416951958351874 "HTTP/1.1 200 "
2026-01-28 21:49:54 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:85] - API调用成功: http://192.168.11.24:8088/datasource/skill/getBySkillId/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 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:322] - 成功处理 3 条技能数据
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 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:132] - ================================================================================
2026-01-28 21:49:54 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:133] - test_sql_with_schema 接口接收到的数据:
2026-01-28 21:49:54 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:134] - 数据类型: <class 'dict'>
2026-01-28 21:49:54 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:135] - 数据内容: {
  "datasourceId": "37",
  "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"
        ]
      },
      "targetDatabaseName": {
        "type": "string",
        "description": "目标数据库名称",
        "default": ""
      }
    }
  },
  "testParams": {
    "payerAccountNo": "667866722135",
    "transactionDate": "2026-01-26",
    "targetDatabaseName": ""
  }
}
2026-01-28 21:49:54 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:136] - 数据源ID: 37
2026-01-28 21:49:54 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:137] - 业务名称: anfukuanrenzhanghaohejiaoyiriqichaxunzijinribao_b38c6d44
2026-01-28 21:49:54 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:138] - 业务描述: anfukuanrenzhanghaohejiaoyiriqichaxunzijinribao_b38c6d44: anfukuanrenzhanghaohejiaoyiriqichaxunzijinribao_b38c6d44: anfukuanrenzhanghaohejiaoyiriqichaxunzijinribao_b38c6d44: 根据指定的付款人账号和交易日期查询资金日报表中的详细交易记录，包括交易类型、金额、双方信息等完整交易明细
2026-01-28 21:49:54 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:139] - SQL模板: 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
2026-01-28 21:49:54 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:140] - 参数定义: {'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': '目标数据库名称', 'default': ''}}}
2026-01-28 21:49:54 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:141] - 测试参数: {'payerAccountNo': '667866722135', 'transactionDate': '2026-01-26', 'targetDatabaseName': ''}
2026-01-28 21:49:54 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:142] - ================================================================================
2026-01-28 21:49:54 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:151] - 正在调用测试SQL API: http://192.168.11.24:8088/datasource/sqlExecutionLog/testSqlWithSchema
2026-01-28 21:49:54 - httpx - INFO - [_client.py:1025] - HTTP Request: POST http://192.168.11.24:8088/datasource/sqlExecutionLog/testSqlWithSchema "HTTP/1.1 200 "
2026-01-28 21:49:54 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:168] - ================================================================================
2026-01-28 21:49:54 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:169] - test_sql_with_schema 接口返回的数据:
2026-01-28 21:49:54 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:170] - HTTP状态码: 200
2026-01-28 21:49:54 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:171] - 响应数据类型: <class 'dict'>
2026-01-28 21:49:54 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:172] - 响应数据内容: {
  "msg": "操作成功",
  "code": 200,
  "data": {
    "resultCount": 6,
    "data": [
      {
        "记录标识号": "2",
        "交易类型": "往账",
        "业务类型": "转账支出",
        "付款人账号": "667866722135",
        "付款人名称": "广东海圆圆农业科技有限公司",
        "收款人账号": "6217852000006363041",
        "收款人名称": "范红霞",
        "交易日期": "2026-01-26T00:00:00.000+08:00",
        "交易时间": "17:40:25",
        "交易货币": "CNY",
        "交易金额": -787.5,
        "交易后余额": 170220.05,
        "起息日期": "2026-01-26T00:00:00.000+08:00",
        "汇率": 1,
        "交易流水号": "282055238690",
        "摘要": "282055238999986690999986690",
        "用途": "OBSS003756213754GIRO000000000000"
      },
      {
        "记录标识号": "3",
        "交易类型": "往账",
        "业务类型": "网上支付",
        "付款人账号": "667866722135",
        "付款人名称": "广东海圆圆农业科技有限公司",
        "收款人账号": "6212263602092911221",
        "收款人名称": "吴小敏",
        "交易日期": "2026-01-26T00:00:00.000+08:00",
        "交易时间": "17:40:27",
        "交易货币": "CNY",
        "交易金额": -419.3,
        "交易后余额": 169800.75,
        "起息日期": "2026-01-26T00:00:00.000+08:00",
        "汇率": 1,
        "交易流水号": "282058995688",
        "摘要": "282058995999986688999986688",
        "用途": "OBSS003756219241GIRO000000000000"
      },
      {
        "记录标识号": "4",
        "交易类型": "往账",
        "业务类型": "收费",
        "付款人账号": "667866722135",
        "付款人名称": "广东海圆圆农业科技有限公司",
        "收款人账号": null,
        "收款人名称": null,
        "交易日期": "2026-01-26T00:00:00.000+08:00",
        "交易时间": "17:40:27",
        "交易货币": "CNY",
        "交易金额": -4.5,
        "交易后余额": 169796.25,
        "起息日期": "2026-01-26T00:00:00.000+08:00",
        "汇率": 1,
        "交易流水号": "282058995686",
        "摘要": "282058995999986686999986686",
        "用途": "对公跨行转账汇款手续费"
      },
      {
        "记录标识号": "5",
        "交易类型": "往账",
        "业务类型": "网上支付",
        "付款人账号": "667866722135",
        "付款人名称": "广东海圆圆农业科技有限公司",
        "收款人账号": "7559016582106213872732048",
        "收款人名称": "深圳市腾讯计算机系统有限公司",
        "交易日期": "2026-01-26T00:00:00.000+08:00",
        "交易时间": "17:40:27",
        "交易货币": "CNY",
        "交易金额": -0.14,
        "交易后余额": 169796.11,
        "起息日期": "2026-01-26T00:00:00.000+08:00",
        "汇率": 1,
        "交易流水号": "282056095685",
        "摘要": "282056095999986685999986685",
        "用途": "OBSS003756206850GIRO000000000000"
      },
      {
        "记录标识号": "6",
        "交易类型": "往账",
        "业务类型": "收费",
        "付款人账号": "667866722135",
        "付款人名称": "广东海圆圆农业科技有限公司",
        "收款人账号": null,
        "收款人名称": null,
        "交易日期": "2026-01-26T00:00:00.000+08:00",
        "交易时间": "17:40:27",
        "交易货币": "CNY",
        "交易金额": -4.5,
        "交易后余额": 169791.61,
        "起息日期": "2026-01-26T00:00:00.000+08:00",
        "汇率": 1,
        "交易流水号": "282056095683",
        "摘要": "282056095999986683999986683",
        "用途": "对公跨行转账汇款手续费"
      },
      {
        "记录标识号": "7",
        "交易类型": "往账",
        "业务类型": "转账支出",
        "付款人账号": "667866722135",
        "付款人名称": "广东海圆圆农业科技有限公司",
        "收款人账号": "6217852000006363041",
        "收款人名称": "范红霞",
        "交易日期": "2026-01-26T00:00:00.000+08:00",
        "交易时间": "17:40:36",
        "交易货币": "CNY",
        "交易金额": -67.97,
        "交易后余额": 169723.64,
        "起息日期": "2026-01-26T00:00:00.000+08:00",
        "汇率": 1,
        "交易流水号": "282098067682",
        "摘要": "282098067999986682999986682",
        "用途": "OBSS003756216834GIRO000000000000"
      }
    ],
    "databaseName": "fund_daily_report_db_37",
    "businessDescription": "anfukuanrenzhanghaohejiaoyiriqichaxunzijinribao_b38c6d44: anfukuanrenzhanghaohejiaoyiriqichaxunzijinribao_b38c6d44: anfukuanrenzhanghaohejiaoyiriqichaxunzijinribao_b38c6d44: 根据指定的付款人账号和交易日期查询资金日报表中的详细交易记录，包括交易类型、金额、双方信息等完整交易明细",
    "originalTemplate": "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",
    "convertedTemplate": "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",
    "executionStatus": "success",
    "businessName": "anfukuanrenzhanghaohejiaoyiriqichaxunzijinribao_b38c6d44",
    "testParams": {
      "payerAccountNo": "667866722135",
      "transactionDate": "2026-01-26",
      "targetDatabaseName": ""
    },
    "errorMessage": null,
    "executionTime": 7,
    "datasourceId": "37",
    "logId": "1497",
    "executableSql": "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 = '667866722135' AND transaction_date::date = '2026-01-26'::date",
    "datasourceName": "fund_daily_report_db_37"
  }
}
2026-01-28 21:49:54 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:174] - 响应code: 200
2026-01-28 21:49:54 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:175] - 响应msg: 操作成功
2026-01-28 21:49:54 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:176] - 响应data: {'resultCount': 6, 'data': [{'记录标识号': '2', '交易类型': '往账', '业务类型': '转账支出', '付款人账号': '667866722135', '付款人名称': '广东海圆圆农业科技有限公司', '收款人账号': '6217852000006363041', '收款人名称': '范红霞', '交易日期': '2026-01-26T00:00:00.000+08:00', '交易时间': '17:40:25', '交易货币': 'CNY', '交易金额': -787.5, '交易后余额': 170220.05, '起息日期': '2026-01-26T00:00:00.000+08:00', '汇率': 1, '交易流水号': '282055238690', '摘要': '282055238999986690999986690', '用途': 'OBSS003756213754GIRO000000000000'}, {'记录标识号': '3', '交易类型': '往账', '业务类型': '网上支付', '付款人账号': '667866722135', '付款人名称': '广东海圆圆农业科技有限公司', '收款人账号': '6212263602092911221', '收款人名称': '吴小敏', '交易日期': '2026-01-26T00:00:00.000+08:00', '交易时间': '17:40:27', '交易货币': 'CNY', '交易金额': -419.3, '交易后余额': 169800.75, '起息日期': '2026-01-26T00:00:00.000+08:00', '汇率': 1, '交易流水号': '282058995688', '摘要': '282058995999986688999986688', '用途': 'OBSS003756219241GIRO000000000000'}, {'记录标识号': '4', '交易类型': '往账', '业务类型': '收费', '付款人账号': '667866722135', '付款人名称': '广东海圆圆农业科技有限公司', '收款人账号': None, '收款人名称': None, '交易日期': '2026-01-26T00:00:00.000+08:00', '交易时间': '17:40:27', '交易货币': 'CNY', '交易金额': -4.5, '交易后余额': 169796.25, '起息日期': '2026-01-26T00:00:00.000+08:00', '汇率': 1, '交易流水号': '282058995686', '摘要': '282058995999986686999986686', '用途': '对公跨行转账汇款手续费'}, {'记录标识号': '5', '交易类型': '往账', '业务类型': '网上支付', '付款人账号': '667866722135', '付款人名称': '广东海圆圆农业科技有限公司', '收款人账号': '7559016582106213872732048', '收款人名称': '深圳市腾讯计算机系统有限公司', '交易日期': '2026-01-26T00:00:00.000+08:00', '交易时间': '17:40:27', '交易货币': 'CNY', '交易金额': -0.14, '交易后余额': 169796.11, '起息日期': '2026-01-26T00:00:00.000+08:00', '汇率': 1, '交易流水号': '282056095685', '摘要': '282056095999986685999986685', '用途': 'OBSS003756206850GIRO000000000000'}, {'记录标识号': '6', '交易类型': '往账', '业务类型': '收费', '付款人账号': '667866722135', '付款人名称': '广东海圆圆农业科技有限公司', '收款人账号': None, '收款人名称': None, '交易日期': '2026-01-26T00:00:00.000+08:00', '交易时间': '17:40:27', '交易货币': 'CNY', '交易金额': -4.5, '交易后余额': 169791.61, '起息日期': '2026-01-26T00:00:00.000+08:00', '汇率': 1, '交易流水号': '282056095683', '摘要': '282056095999986683999986683', '用途': '对公跨行转账汇款手续费'}, {'记录标识号': '7', '交易类型': '往账', '业务类型': '转账支出', '付款人账号': '667866722135', '付款人名称': '广东海圆圆农业科技有限公司', '收款人账号': '6217852000006363041', '收款人名称': '范红霞', '交易日期': '2026-01-26T00:00:00.000+08:00', '交易时间': '17:40:36', '交易货币': 'CNY', '交易金额': -67.97, '交易后余额': 169723.64, '起息日期': '2026-01-26T00:00:00.000+08:00', '汇率': 1, '交易流水号': '282098067682', '摘要': '282098067999986682999986682', '用途': 'OBSS003756216834GIRO000000000000'}], 'databaseName': 'fund_daily_report_db_37', 'businessDescription': 'anfukuanrenzhanghaohejiaoyiriqichaxunzijinribao_b38c6d44: anfukuanrenzhanghaohejiaoyiriqichaxunzijinribao_b38c6d44: anfukuanrenzhanghaohejiaoyiriqichaxunzijinribao_b38c6d44: 根据指定的付款人账号和交易日期查询资金日报表中的详细交易记录，包括交易类型、金额、双方信息等完整交易明细', 'originalTemplate': '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', 'convertedTemplate': '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', 'executionStatus': 'success', 'businessName': 'anfukuanrenzhanghaohejiaoyiriqichaxunzijinribao_b38c6d44', 'testParams': {'payerAccountNo': '667866722135', 'transactionDate': '2026-01-26', 'targetDatabaseName': ''}, 'errorMessage': None, 'executionTime': 7, 'datasourceId': '37', 'logId': '1497', 'executableSql': '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 = \'667866722135\' AND transaction_date::date = \'2026-01-26\'::date', 'datasourceName': 'fund_daily_report_db_37'}
2026-01-28 21:49:54 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:177] - ================================================================================
2026-01-28 21:49:54 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:179] - 测试SQL API调用成功
2026-01-28 21:49:54 - mcp_services - INFO - [main.py:227] - 测试SQL API调用成功
2026-01-28 21:50:18 - mcp.server.lowlevel.server - INFO - [server.py:619] - Processing request of type CallToolRequest
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 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:132] - ================================================================================
2026-01-28 21:50:18 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:133] - test_sql_with_schema 接口接收到的数据:
2026-01-28 21:50:18 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:134] - 数据类型: <class 'dict'>
2026-01-28 21:50:18 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:135] - 数据内容: {
  "datasourceId": "37",
  "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"
        ]
      },
      "targetDatabaseName": {
        "type": "string",
        "description": "目标数据库名称",
        "default": ""
      }
    }
  },
  "testParams": {
    "transactionDate": "2026-01-02",
    "targetDatabaseName": ""
  }
}
2026-01-28 21:50:18 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:136] - 数据源ID: 37
2026-01-28 21:50:18 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:137] - 业务名称: anjiaoyiriqichaxunsuoyouzhanghaohezhanghuming_0bf10c98
2026-01-28 21:50:18 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:138] - 业务描述: anjiaoyiriqichaxunsuoyouzhanghaohezhanghuming_0bf10c98: anjiaoyiriqichaxunsuoyouzhanghaohezhanghuming_0bf10c98: anjiaoyiriqichaxunsuoyouzhanghaohezhanghuming_0bf10c98: 根据指定的交易日期，从资金日报表中去重查询所有付款人和收款人的账号及对应的账户名，用于了解特定日期涉及的银行账户信息
2026-01-28 21:50:18 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:139] - SQL模板: 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
2026-01-28 21:50:18 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:140] - 参数定义: {'type': 'object', 'required': ['transactionDate'], 'properties': {'transactionDate': {'type': 'string', 'description': '交易日期，格式为YYYY-MM-DD', 'examples': ['2026-01-26']}, 'targetDatabaseName': {'type': 'string', 'description': '目标数据库名称', 'default': ''}}}
2026-01-28 21:50:18 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:141] - 测试参数: {'transactionDate': '2026-01-02', 'targetDatabaseName': ''}
2026-01-28 21:50:18 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:142] - ================================================================================
2026-01-28 21:50:18 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:151] - 正在调用测试SQL API: http://192.168.11.24:8088/datasource/sqlExecutionLog/testSqlWithSchema
2026-01-28 21:50:18 - httpx - INFO - [_client.py:1025] - HTTP Request: POST http://192.168.11.24:8088/datasource/sqlExecutionLog/testSqlWithSchema "HTTP/1.1 200 "
2026-01-28 21:50:18 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:168] - ================================================================================
2026-01-28 21:50:18 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:169] - test_sql_with_schema 接口返回的数据:
2026-01-28 21:50:18 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:170] - HTTP状态码: 200
2026-01-28 21:50:18 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:171] - 响应数据类型: <class 'dict'>
2026-01-28 21:50:18 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:172] - 响应数据内容: {
  "msg": "操作成功",
  "code": 200,
  "data": {
    "resultCount": 0,
    "data": [],
    "databaseName": "fund_daily_report_db_37",
    "businessDescription": "anjiaoyiriqichaxunsuoyouzhanghaohezhanghuming_0bf10c98: anjiaoyiriqichaxunsuoyouzhanghaohezhanghuming_0bf10c98: anjiaoyiriqichaxunsuoyouzhanghaohezhanghuming_0bf10c98: 根据指定的交易日期，从资金日报表中去重查询所有付款人和收款人的账号及对应的账户名，用于了解特定日期涉及的银行账户信息",
    "originalTemplate": "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",
    "convertedTemplate": "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",
    "executionStatus": "success",
    "businessName": "anjiaoyiriqichaxunsuoyouzhanghaohezhanghuming_0bf10c98",
    "testParams": {
      "transactionDate": "2026-01-02",
      "targetDatabaseName": ""
    },
    "errorMessage": null,
    "executionTime": 7,
    "datasourceId": "37",
    "logId": "1498",
    "executableSql": "SELECT DISTINCT payer_account_no AS \"账号\", payer_name AS \"账户名\" FROM funds_daily_report WHERE transaction_date::date = '2026-01-02'::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 = '2026-01-02'::date AND payee_account_no IS NOT NULL AND payee_name IS NOT NULL",
    "datasourceName": "fund_daily_report_db_37"
  }
}
2026-01-28 21:50:18 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:174] - 响应code: 200
2026-01-28 21:50:18 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:175] - 响应msg: 操作成功
2026-01-28 21:50:18 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:176] - 响应data: {'resultCount': 0, 'data': [], 'databaseName': 'fund_daily_report_db_37', 'businessDescription': 'anjiaoyiriqichaxunsuoyouzhanghaohezhanghuming_0bf10c98: anjiaoyiriqichaxunsuoyouzhanghaohezhanghuming_0bf10c98: anjiaoyiriqichaxunsuoyouzhanghaohezhanghuming_0bf10c98: 根据指定的交易日期，从资金日报表中去重查询所有付款人和收款人的账号及对应的账户名，用于了解特定日期涉及的银行账户信息', 'originalTemplate': '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', 'convertedTemplate': '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', 'executionStatus': 'success', 'businessName': 'anjiaoyiriqichaxunsuoyouzhanghaohezhanghuming_0bf10c98', 'testParams': {'transactionDate': '2026-01-02', 'targetDatabaseName': ''}, 'errorMessage': None, 'executionTime': 7, 'datasourceId': '37', 'logId': '1498', 'executableSql': 'SELECT DISTINCT payer_account_no AS "账号", payer_name AS "账户名" FROM funds_daily_report WHERE transaction_date::date = \'2026-01-02\'::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 = \'2026-01-02\'::date AND payee_account_no IS NOT NULL AND payee_name IS NOT NULL', 'datasourceName': 'fund_daily_report_db_37'}
2026-01-28 21:50:18 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:177] - ================================================================================
2026-01-28 21:50:18 - lzwcai_mcp_sqlexecutor.utils.api_client - INFO - [api_client.py:179] - 测试SQL API调用成功
2026-01-28 21:50:18 - mcp_services - INFO - [main.py:227] - 测试SQL API调用成功
