SQLServer采集data和log的体积推送到prometheus

{
 'messages': [{
        'role': 'system',
        'content': 'You are a helpful assistant for Elastic Observability. Your goal is to help the Elastic Observability users to quickly assess what is happening in their observed systems. You can help them visualise and analyze data, investigate their systems, perform root cause analysis or identify optimisation opportunities.\n\n    It\'s very important to not assume what the user is meaning. Ask them for clarification if needed.\n\n    If you are unsure about which function should be used and with what arguments, ask the user for clarification or confirmation.\n\n    In KQL ("kqlFilter")) escaping happens with double quotes, not single quotes. Some characters that need escaping are: \':()\\    /". Always put a field value in double quotes. Best: service.name:"opbeans-go". Wrong: service.name:opbeans-go. This is very important!\n\n    You can use Github-flavored Markdown in your responses. If a function returns an array, consider using a Markdown table to format the response.\n\n    Note that ES|QL (the Elasticsearch Query Language which is a new piped language) is the preferred query language.\n\n    If you want to call a function or tool, only call it a single time per message. Wait until the function has been executed and its results\n    returned to you, before executing the same tool or another tool again if needed.\n\n    DO NOT UNDER ANY CIRCUMSTANCES USE ES|QL syntax (service.name == "foo") with "kqlFilter" (service.name:"foo").\n\n    The user is able to change the language which they want you to reply in on the settings page of the AI Assistant for Observability and Search, which can be found in the Stack Management app under the option AI Assistants.\n    If the user asks how to change the language, reply in the same language the user asked in.\n\nYou MUST use the "query" function when the user wants to:\n  - visualize data\n  - run any arbitrary query\n  - breakdown or filter ES|QL queries that are displayed on the current page\n  - convert queries from another language to ES|QL\n  - asks general questions about ES|QL\n\n  DO NOT UNDER ANY CIRCUMSTANCES generate ES|QL queries or explain anything about the ES|QL query language yourself.\n  DO NOT UNDER ANY CIRCUMSTANCES try to correct an ES|QL query yourself - always use the "query" function for this.\n\n  If the user asks for a query, and one of the dataset info functions was called and returned no results, you should still call the query function to generate an example query.\n\n  Even if the "query" function was used before that, follow it up with the "query" function. If a query fails, do not attempt to correct it yourself. Again you should call the "query" function,\n  even if it has been called before.\n\n  When the "visualize_query" function has been called, a visualization has been displayed to the user. DO NOT UNDER ANY CIRCUMSTANCES follow up a "visualize_query" function call with your own visualization attempt.\n  If the "execute_query" function has been called, summarize these results for the user. The user does not see a visualization in this case.\n\nYou MUST use the "get_dataset_info"  function before calling the "query" or the "changes" functions.\n\nIf a function requires an index, you MUST use the results from the dataset info functions.\n\nYou do not have a working memory. If the user expects you to remember the previous conversations, tell them they can set up the knowledge base.\n\nWhen asked questions about the Elastic stack or products, You should use the retrieve_elastic_doc function before answering,\n      to retrieve documentation related to the question. Consider that the documentation returned by the function\n      is always more up to date and accurate than any own internal knowledge you might have.'
    }, {
        'role': 'user',
        'content': 'Hi'
    }, {
        'role': 'assistant',
        'content': '',
        'function_call': {
            'name': 'context',
            'arguments': '{}'
        }
    }, {
        'role': 'user',
        'content': '{"screen_description":"The user is looking at http://localhost:5601/app/observabilityAIAssistant/conversations/new. The current time range is 2025-03-10T07:30:39.405Z - 2025-03-10T07:45:39.405Z.","learnings":[]}',
        'name': 'context'
    }],
    'stream': True,
    'tools': [{
        'function': {
            'name': 'query',
            'description': "This function generates, executes and/or visualizes a query\n      based on the user's request. It also explains how ES|QL works and how to\n      convert queries from one language to another. Make sure you call one of\n      the get_dataset functions first if you need index or field names. This\n      function takes no input.",
            'parameters': {
                'type': 'object',
                'properties': {}
            }
        },
        'type': 'function'
    }, {
        'function': {
            'name': 'get_alerts_dataset_info',
            'description': 'Use this function to get information about alerts data.',
            'parameters': {
                'type': 'object',
                'properties': {
                    'start': {
                        'type': 'string',
                        'description': 'The start of the current time range, in datemath, like now-24h or an ISO timestamp'
                    },
                    'end': {
                        'type': 'string',
                        'description': 'The end of the current time range, in datemath, like now-24h or an ISO timestamp'
                    }
                }
            }
        },
        'type': 'function'
    }, {
        'function': {
            'name': 'alerts',
            'description': 'Get alerts for Observability.  Make sure get_alerts_dataset_info was called before.\n        Use this to get open (and optionally recovered) alerts for Observability assets, like services,\n        hosts or containers.\n        Display the response in tabular format if appropriate.\n      ',
            'parameters': {
                'type': 'object',
                'properties': {
                    'start': {
                        'type': 'string',
                        'description': 'The start of the time range, in Elasticsearch date math, like now.'
                    },
                    'end': {
                        'type': 'string',
                        'description': 'The end of the time range, in Elasticsearch date math, like now-24h.'
                    },
                    'kqlFilter': {
                        'type': 'string',
                        'description': 'Filter alerts by field:value pairs'
                    },
                    'includeRecovered': {
                        'type': 'boolean',
                        'description': 'Whether to include recovered/closed alerts. Defaults to false, which means only active alerts will be returned'
                    }
                },
                'required': ['start', 'end']
            }
        },
        'type': 'function'
    }, {
        'function': {
            'name': 'changes',
            'description': 'Returns change points like spikes and dips for logs and metrics.',
            'parameters': {
                'type': 'object',
                'properties': {
                    'start': {
                        'type': 'string',
                        'description': 'The beginning of the time range, in datemath, like now-24h, or an ISO timestamp'
                    },
                    'end': {
                        'type': 'string',
                        'description': 'The end of the time range, in datemath, like now, or an ISO timestamp'
                    },
                    'logs': {
                        'description': 'Analyze changes in log patterns. If no index is given, the default logs index pattern will be used',
                        'type': 'array',
                        'items': {
                            'type': 'object',
                            'properties': {
                                'name': {
                                    'type': 'string',
                                    'description': 'The name of this set of logs'
                                },
                                'index': {
                                    'type': 'string',
                                    'description': 'The index or index pattern where to find the logs'
                                },
                                'kqlFilter': {
                                    'type': 'string',
                                    'description': 'A KQL filter to filter the log documents by, e.g. my_field:foo'
                                },
                                'field': {
                                    'type': 'string',
                                    'description': 'The text field that contains the message to be analyzed, usually message. ONLY use field names from the conversation.'
                                }
                            },
                            'required': ['name']
                        }
                    },
                    'metrics': {
                        'description': 'Analyze changes in metrics. DO NOT UNDER ANY CIRCUMSTANCES use date or metric fields for groupBy, leave empty unless needed.',
                        'type': 'array',
                        'items': {
                            'type': 'object',
                            'properties': {
                                'name': {
                                    'type': 'string',
                                    'description': 'The name of this set of metrics'
                                },
                                'index': {
                                    'type': 'string',
                                    'description': 'The index or index pattern where to find the metrics'
                                },
                                'kqlFilter': {
                                    'type': 'string',
                                    'description': 'A KQL filter to filter the log documents by, e.g. my_field:foo'
                                },
                                'field': {
                                    'type': 'string',
                                    'description': 'Metric field that contains the metric. Only use if the metric aggregation type is not count.'
                                },
                                'type': {
                                    'type': 'string',
                                    'description': 'The type of metric aggregation to perform. Defaults to count',
                                    'enum': ['count', 'avg', 'sum', 'min', 'max', 'p95', 'p99']
                                },
                                'groupBy': {
                                    'type': 'array',
                                    'description': 'Optional keyword fields to group metrics by.',
                                    'items': {
                                        'type': 'string'
                                    }
                                }
                            },
                            'required': ['index', 'name']
                        }
                    }
                },
                'required': ['start', 'end']
            }
        },
        'type': 'function'
    }, {
        'function': {
            'name': 'elasticsearch',
            'description': 'Call Elasticsearch APIs on behalf of the user. Make sure the request body is valid for the API that you are using. Only call this function when the user has explicitly requested it.',
            'parameters': {
                'type': 'object',
                'properties': {
                    'method': {
                        'type': 'string',
                        'description': 'The HTTP method of the Elasticsearch endpoint',
                        'enum': ['GET', 'PUT', 'POST', 'DELETE', 'PATCH']
                    },
                    'path': {
                        'type': 'string',
                        'description': 'The path of the Elasticsearch endpoint, including query parameters'
                    },
                    'body': {
                        'type': 'object',
                        'description': 'The body of the request'
                    }
                },
                'required': ['method', 'path']
            }
        },
        'type': 'function'
    }, {
        'function': {
            'name': 'kibana',
            'description': 'Call Kibana APIs on behalf of the user. Only call this function when the user has explicitly requested it, and you know how to call it, for example by querying the knowledge base or having the user explain it to you. Assume that pathnames, bodies and query parameters may have changed since your knowledge cut off date.',
            'parameters': {
                'type': 'object',
                'properties': {
                    'method': {
                        'type': 'string',
                        'description': 'The HTTP method of the Kibana endpoint',
                        'enum': ['GET', 'PUT', 'POST', 'DELETE', 'PATCH']
                    },
                    'pathname': {
                        'type': 'string',
                        'description': 'The pathname of the Kibana endpoint, excluding query parameters'
                    },
                    'query': {
                        'type': 'object',
                        'description': 'The query parameters, as an object'
                    },
                    'body': {
                        'type': 'object',
                        'description': 'The body of the request'
                    }
                },
                'required': ['method', 'pathname']
            }
        },
        'type': 'function'
    }, {
        'function': {
            'name': 'get_dataset_info',
            'description': 'Use this function to get information about indices/datasets available and the fields available on them.\n\n      providing empty string as index name will retrieve all indices\n      else list of all fields for the given index will be given. if no fields are returned this means no indices were matched by provided index pattern.\n      wildcards can be part of index name.',
            'parameters': {
                'type': 'object',
                'properties': {
                    'index': {
                        'type': 'string',
                        'description': 'index pattern the user is interested in or empty string to get information about all available indices'
                    }
                },
                'required': ['index']
            }
        },
        'type': 'function'
    }, {
        'function': {
            'name': 'execute_connector',
            'description': 'Use this function when user explicitly asks to call a kibana connector.',
            'parameters': {
                'type': 'object',
                'properties': {
                    'id': {
                        'type': 'string',
                        'description': 'The id of the connector'
                    },
                    'params': {
                        'type': 'object',
                        'description': 'The connector parameters'
                    }
                },
                'required': ['id', 'params']
            }
        },
        'type': 'function'
    }, {
        'function': {
            'name': 'retrieve_elastic_doc',
            'description': 'Use this function to retrieve documentation about Elastic products.\n      You can retrieve documentation about the Elastic stack, such as Kibana and Elasticsearch,\n      or for Elastic solutions, such as Elastic Security, Elastic Observability or Elastic Enterprise Search\n      ',
            'parameters': {
                'type': 'object',
                'properties': {
                    'query': {
                        'description': 'The query to use to retrieve documentation\n            Examples:\n            - "How to enable TLS for Elasticsearch?"\n            - "What is Kibana Lens?"',
                        'type': 'string'
                    },
                    'product': {
                        'description': 'If specified, will filter the products to retrieve documentation for\n            Possible options are:\n            - "kibana": Kibana product\n            - "elasticsearch": Elasticsearch product\n            - "observability": Elastic Observability solution\n            - "security": Elastic Security solution\n            If not specified, will search against all products\n            ',
                        'type': 'string',
                        'enum': ['kibana', 'elasticsearch', 'observability', 'security']
                    }
                },
                'required': ['query']
            }
        },
        'type': 'function'
    }],
    'temperature': 0
}

# 系统指令强制分步执行
'system': '''
- 必须优先调用 `get_dataset_info` 获取元数据，再调用 `query` 执行查询
- 禁止自行生成 ES|QL 查询，必须通过工具调用
- 每次只能调用一个函数，需等待返回结果后再继续
'''

'tools': [
    {'name': 'query', 'desc': '执行查询'},          # 查询执行
    {'name': 'get_dataset_info', 'desc': '获取元数据'}, # 元数据获取
    {'name': 'alerts', 'desc': '告警处理'},         # 告警操作
    {'name': 'changes', 'desc': '变更分析'},        # 变更检测
    {'name': 'elasticsearch', 'desc': '直接调用 ES API'}, # 底层操作
    {'name': 'kibana', 'desc': '调用 Kibana API'},  # 可视化扩展
    {'name': 'retrieve_elastic_doc', 'desc': '文档检索'} # 知识增强
]

# 禁止 Agentic RAG 自由发挥
'DO NOT UNDER ANY CIRCUMSTANCES generate ES|QL queries yourself'
'If a query fails, do not attempt to correct it yourself. Call the "query" function again'

用户问题 → 检索文档 → 生成答案（End）

# Prompt 中明确规定
'If a query fails, do not attempt to correct it yourself. Again call the "query" function'