Canner / WrenAI

🚀 Open-source SQL AI Agent for Text-to-SQL. Make Text2SQL Easy! 🙌
https://www.getwren.ai/oss
GNU Affero General Public License v3.0
1.67k stars 146 forks source link

Suggestion for Expanding Wren AI Capabilities to Business Users #513

Open ikasymov opened 1 month ago

ikasymov commented 1 month ago

Dear Wren AI Team,

I hope this message finds you well. I am writing to share some thoughts and suggestions regarding the future direction of Wren AI.

First, I would like to commend your efforts in developing a robust tool that significantly enhances the productivity of SQL developers and specialists. The ability to process natural language queries into precise SQL outputs and manage complex data relationships through your semantic engine is impressive and highly beneficial for technical users.

However, I believe there is a substantial opportunity to expand Wren AI’s capabilities to better serve business users who may not have a technical background. Specifically, I suggest developing a chatbot interface that allows users to ask questions directly and receive user-friendly answers in plain language, without the need to interact with SQL tables. This approach would make data more accessible to non-technical stakeholders, enabling them to obtain valuable insights without requiring an understanding of SQL.

Here are a few key points to consider for this enhancement:

I am confident that such an enhancement would broaden the appeal of Wren AI and make it an indispensable tool not just for developers and SQL specialists, but also for business professionals across various industries.

Thank you for considering this suggestion. I would be delighted to discuss this idea further and explore how we might collaborate to bring it to fruition.

wwwy3y3 commented 1 month ago

@ikasymov thanks for sharing your thoughts with us. They are really valuable to us.

User-Friendly Interface: Implementing a conversational chatbot that interprets business questions and provides clear, actionable responses would greatly benefit users who are unfamiliar with SQL. This would democratize access to data and insights across the organization.

We've received feedback that step-by-step explanations and data previewing are still difficult for business users to understand. Therefore, we are considering generating a summarized answer directly for users. However, this means your data might be sent to OpenAI (unless you're using a local LLM, in which case this isn't an issue). Is this something that would concern you?

Natural Language Processing (NLP): Leveraging advanced NLP techniques to ensure that the chatbot can understand a wide range of business queries and provide accurate, context-aware responses.

I agree this is important. We are working on designing a clarification process to ensure the LLM understands users' questions through interactions. It's still at early stage discussion though.

Contextual Responses: Ensuring that the responses are not only accurate but also presented in a format that is easily understood by business users, potentially including visual aids like charts and graphs.

We have provided an Excel add-in that allows users to export data to Excel and create graphs there (https://blog.getwren.ai/easily-query-your-database-using-llms-without-writing-sql-and-then-import-the-data-into-microsoft-871c9672c656). Do you think this integration serves your needs, or do you find it crucial to have answers and automatically generated graphs within the chatting interface?

Developer Configuration: The setup and configuration of Wren AI would still be managed by developers, ensuring that the system is correctly integrated and optimized. However, the chatbot interface would empower business users to interact with the data directly, making the system more versatile and user-friendly.

I see. Just a quick thought—perhaps we could integrate with Slack (or Teams) so that business users could interact with Wren AI from Slack. What are your thoughts on this integration?