Skip to content
Nappai Documentation

Explain SQL Results

This component in Nappai’s dashboard makes it easy to understand the results of your database queries. It takes the technical output of a SQL query and explains it in simple terms, in your preferred language. This is perfect if you need to know what your data means but don’t want to deal with the technical details.

Relationship with Large Language Models (LLMs)

This component uses a powerful language model (LLM) to translate the results of your SQL queries into easy-to-understand language. The LLM is like a smart translator that understands both database information and human language.

Inputs

  • Result from the execution of SQL query: This is the output from your SQL query. Nappai will automatically provide this. You don’t need to do anything here.
  • User request: This is a brief description of what you were trying to find out with your SQL query. For example, “Show me the total sales for last month.” This helps the component give you a more relevant explanation.
  • User Language: Choose the language you want the explanation in (e.g., English, Spanish, French). This ensures you receive the explanation in a language you understand.
  • LLM: This is the language model Nappai uses to generate the explanation. You don’t need to interact with this directly; it’s handled automatically.

Outputs

  • Explanation results: This is the main output. It provides a clear and concise explanation of your SQL query results in plain language, tailored to your request and chosen language. You can use this explanation to make decisions based on your data.

Usage Example

Let’s say you ran a SQL query to find the number of customers in each city. The “Result from the execution of SQL query” input would contain the raw data from the database. If you entered “Show me the number of customers in each city” as the “User request” and “English” as the “User Language”, the “Explanation results” output would provide a summary like: “There are 150 customers in London, 100 in Paris, and 50 in Berlin.”

Templates

This component is used automatically within Nappai’s workflow. You don’t need to configure any templates directly.

[This section will be populated with links to other relevant components once they are defined.]

Tips and Best Practices

  • Be as clear and specific as possible in your “User request” to get the most accurate and helpful explanation.
  • If you get an unclear explanation, try rephrasing your “User request”.
  • Make sure to select the correct “User Language”.

Security Considerations

Nappai ensures the security of your data throughout the process. The LLM only receives the necessary information to generate the explanation and does not store your data.