SQLAI.ai

AI Generator Mode

Table of contents

Generator Modes

The AI Generator controls what you want AI to do with the input prompt (i.e. what you asked AI using everyday language) and any connected data source. The AI generator provides the different functionality:

  • Generate query: This will turn the input prompt and connected data source into a SQL or NoSQL query. See example and example 2.
  • Explain query: This explains the SQL or NoSQL query added to the input prompt See example.
  • Optimize query: This explains and suggestion optimizations for the SQL or NoSQL query added to the input prompt. See example.
  • Format query: This formats inputted SQL or NoSQL query. See example.
  • Generate Excel: This generates Microsoft Excel formulas based on your input, e.g. "Finds the median value in column G where the corresponding value in column H is 'Sales'"
  • Generate Google Sheets: This generates Google Sheets formulas based on your input, e.g. "Finds the median value in column G where the corresponding value in column H is 'Sales'"
  • Generate Regex: This generates Regex expressions based on your input, e.g. find all emails who include @cloud.

Change Generator Mode

The AI Generator functionality empowers you to control the actions taken by the AI. You can find it under:

  • Navigate to the AI Generator.
  • Click the "Settings" button.
AI Generator drop down
AI Generator drop down