search

ankane / blazer

Business intelligence made simple
MIT License
4.5k stars 471 forks source link

[Idea] ChatGPT integration #441

Open marckohlbrugge opened 1 year ago

marckohlbrugge commented 1 year ago

I love Blazer but I always struggled having to write complex SQL queries. I was too used to ActiveRecord’s simple interface.

These days I have ChatGPT write my Blazer SQL queries. It works surprisingly well.

Is there any interest in adding a native ChatGPT integration into Blazer?

The way I envision it is that users can configure their OpenAI key, add the openai-Ruby gem, and the Blazer “New query” interface will have an extra textarea that will submit to a new controller which calls the ChatGPT API and returns an SQL query.

A full back-and-forward chat interface is probably out of the scope of Blazer, but a one-shot approach should cover most use cases.

jac0320 commented 1 year ago

+1 On this thread. I wonder if there is any possibility of strengthening the plotting capability/query improvement capability using this chatgpt