chat2plot icon indicating copy to clipboard operation
chat2plot copied to clipboard

will this library support SQL databases in the future ?

Open tarek-kerbedj opened this issue 2 years ago • 5 comments

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 !

tarek-kerbedj avatar Jul 14 '23 12:07 tarek-kerbedj

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.

R4j4n avatar Jul 17 '23 07:07 R4j4n

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

prameelareddi avatar Jul 17 '23 10:07 prameelareddi

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 .....

prameelareddi avatar Jul 17 '23 10:07 prameelareddi

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

shankarsharma8089 avatar Nov 08 '23 08:11 shankarsharma8089

@tarek-kerbedj try sqlalchemy from sqlalchemy import create_engine

shankarsharma8089 avatar Nov 08 '23 08:11 shankarsharma8089