timescale / pgai

Bring AI models closer to your PostgreSQL data
PostgreSQL License
695 stars 36 forks source link

Add text-to-sql functionality to PopSQL #76

Open idclevxx opened 1 month ago

idclevxx commented 1 month ago

Pardon me for posting this here, but could not find a more suitable repo for it.

Right now, the workflow for developing complex queries involves asking e.g. ChatGPT, then pasting it into a new tab/query in PopSQL. It would be great if text-to-sql functionality was implemented directly to PopSQL, for instance via a new button/icon in the tab window (see screenshot below)

image

When the new button is clicked, it could bring up a prompt window where the user asks the question that is then translated into SQL.

murrayju commented 3 days ago

@idclevxx we do have something like this in the works, which will be made generally available soon. If you'd like to share your PopSQL organization id, I can give you early access.

Thanks for the feedback!

idclevxx commented 8 hours ago

@idclevxx we do have something like this in the works, which will be made generally available soon. If you'd like to share your PopSQL organization id, I can give you early access.

Thanks for the feedback!

Would love to, but would rather not paste it here, do you have an email/alias I can send it to?