search

nyanp / chat2plot

chat to visualization with LLM
MIT License
203 stars 29 forks source link

will this library support SQL databases in the future ? #3

Open tarek-kerbedj opened 1 year ago

tarek-kerbedj commented 1 year ago

Hello , i tried to find a way to contact the author but couldn't find any emails attached , so my question is will this library support SQL databases/agents in the future , given that in my use case they always perform better than csv agents , i'd really love to hear an answer Thank you !

R4j4n commented 1 year ago

You could use SQL agent to generate SQL queries and use pandas to execute those queries. Now you can feed that data frame to Chat2plot. I am using this approach.

prameelareddi commented 1 year ago

Hello @tarek-kerbedj If you find anything related to the database using plots please share me.. Thank you !!!

prameelareddi commented 1 year ago

Hello @R4j4n Great thanks !!! I am working on Chart generation using SQL queries, I have LLM for generating SQL queries but I need to change that SQL query into a plot with considering my database can you please help with this ..... Thank you .....

shankarsharma8089 commented 11 months ago

@prameelareddi you can use sqlalchemy , you have to give your database connection parameters along with defining the SQLAlchemy engine ..

shankarsharma8089 commented 11 months ago

@tarek-kerbedj try sqlalchemy from sqlalchemy import create_engine