will this library support SQL databases in the future ?

[tarek-kerbedj]

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]

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]

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

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

[shankarsharma8089]

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

[shankarsharma8089]

@tarek-kerbedj try sqlalchemy
from sqlalchemy import create_engine