search

Canner / WrenAI

🚀 An open-source SQL AI (Text-to-SQL) Agent that empowers data, product teams to chat with their data. 🤘
https://getwren.ai/oss
GNU Affero General Public License v3.0
2.04k stars 211 forks source link

MongoDB support #370

Open dlecan opened 5 months ago

dlecan commented 5 months ago

Is your feature request related to a problem? Please describe.

WrenAI is not compatible with MongoDB

Describe the solution you'd like

MongoDB support in WrenAI

wwwy3y3 commented 5 months ago

Hi @dlecan thanks for opening this feature request!

Could you also visit https://github.com/Canner/WrenAI/discussions/327#discussioncomment-9610640 and upvote the MongoDB comment ?

In addition, In order to support database faster, we're actually working on using the ibis-project to connect to the datasource. The concept is that WrenAI generates ibis-executable SQL, which is then transformed to the specific datasource using the appropriate dialect. You can see how we invoke a ibis service in this PR: https://github.com/Canner/WrenAI/pull/306. It's still a work in progress.

Thus, to support MongoDB in WrenAI, we could keep an eye on ibis support on MongoDB.

dlecan commented 5 months ago

Done @wwwy3y3 , thank you

Spirizeon commented 3 weeks ago

Hi, is this issue being worked on already? If not, can i give it a go?

grieve54706 commented 3 weeks ago

Hi @Spirizeon, cuz our basic data source connector is powered by ibis now. The ibis does not support MongoDB now. If you want to get this PR, you need to implement the MongoDB connector in ibis first. If you can, please let @wwwy3y3 know.