ChatGPT + Omniscope Evo Integration: Use NLP to Create Custom SQL

Modified on Thu, 18 May, 2023 at 10:54 AM


By integrating ChatGPT, a language model developed by OpenAI, with Omniscope Evo, users can leverage natural language processing capabilities to generate custom SQL queries within the database block. This enables users to ask questions in a more intuitive and natural way, making data analysis and exploration more accessible and efficient.


The integration process is fairly simple:


  1. Ensure you have Omniscope installed and have access to a supported database.
  2. Access OpenAI API: Obtain an API key from OpenAI by following their documentation  (see https://platform.openai.com/ ). This API key will allow you to interact with the ChatGPT model.
  3. Enter the API key into the Omniscope's Admin > AI Integration section, as per image. 
  4. Now integrate ChatGPT into Omniscope: Open Omniscope and navigate to the database block. 

    Pick the Custom SQL option and enter the question in the Auto-generate box e.g. "what are the top ten regions by rainfall".  ChatGPT will translate the question into a Custom SQL statement, including JOIN operation, if needed, to combine multiple tables and retrieve the data needed to answer the question (see image below)



The application - see below the Options tab and how you can ask a question in the auto-generate section.


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article