[Feature] DQL Tool #10712
Description
Is your feature request related to a problem? Please describe.
I am building a Dashboard in Opensearch that has a chat assistant for one of its components. User's visiting the dashboard are often non-technical and do not have the time to learn DQL.
Describe the solution you'd like
Agent Tool that is an expert with DQL. Since OS Dashboards support DQL the Agent connected to Chat Assistant gains the capability of formulating precise DQL queries for a user to support filtering. Currently have decent results with a MLModelTool and appropriate prompt engineering. This feature would apply strict logic and support non-technical users ability to build out the necessary filters for their use cases.
Describe alternatives you've considered
The current solution I am using is a MlModelTool with specific prompt engineering built from OS Documentation from DQL quick reference. https://docs.opensearch.org/latest/dashboards/dql/
This solution works through the implementation of a conversational agent with tools such as ListIndexTool, IndexMappingTool, and MLModelTool. Results are generally good but I believe this can be improved with the DQL Tool.
Additional context
