Skip to main content

Asking Questions

In the Home page, you can ask questions or data requests and get results with step-by-step breakdown generated by LLMs.

recommended In the center of the Home page, we will show recommended questions that are generated by AI based on the data models, including user-defined semantics and relationships. These recommendations are designed to help you explore your data more effectively and discover insights you might not have thought to ask about.

Ask Questions​

Enter your questions in the question block and click the Ask button. ask

Wren AI classifies your questions into three categories: Executable Queries, Database Schema Exploration, and Out-of-Scope Queries. This helps you get the most relevant data. If Wren AI is unable to generate a query, it will guide you to refine your question for better results.

Data Retrieval Requests​

These questions are clearly defined and can be directly converted into SQL queries to fetch data. If your request is unclear, the system will ask for additional information to ensure precise data retrieval.

ask_result

As shown above, Wren AI will respond with step-by-step breakdown of the query generation process and data results.

ask_clarification

As illustrated, if your question lacks clarity, Wren AI will ask for further details and suggest alternative questions you might consider.

Database Schema Exploration​

This feature allows you to inquire about the database's structure, such as requesting lists of tables, descriptions of table schemas, or explanations of relationships between tables. It provides detailed information to help you understand and navigate the database schema effectively.

Example questions you can ask:

  • "What tables do I have?"
  • "What can I ask?"
  • "Explain the customer table to me."
  • "How many tables do I have?"

ask_data_schema_exploration

These questions assist you in obtaining a list of available tables, comprehending the relationships between them, and acquiring detailed information about specific tables and their columns.

Additionally, Wren AI will offer suggested questions that can be turned into queries to get results.

Out-of-Scope Questions​

These inputs are unrelated to the database schema or data retrieval, such as casual greetings or questions beyond the system's intended functionality. In such cases, the system will prompt you to provide more specific information or clarify your intent.

ask_hello

Additionally, Wren AI will provide recommended questions to help you refine your question.

What if I'm asked to clarify my question?

If your question is unclear or not relevant to your data, you may receive a system prompt stating Clarification needed. This means you need to rephrase your question to make it more specific or relevant.

If your question is similar to a previously saved view's query, Wren AI will first search through views you saved, it there is no related SQL based on stored views, it will generate SQL queries based on the context it collects.

Answer Details​

After Wren AI generates an answer, you will be redirected to a thread page to view answer details.
See Know your answers to find out what answer contents you will get.

Follow-up Questions​

In each thread, you can ask following questions to continuously refine your requests and get more precise results.
See Know your answers for more details.