Support/document a duckdb connector

Sinaptik-AI / pandas-ai

Chat with your database (SQL, CSV, pandas, polars, mongodb, noSQL, etc). PandasAI makes data analysis conversational using LLMs (GPT 3.5 / 4, Anthropic, VertexAI) and RAG.

https://pandas-ai.com

Other

13.6k stars 1.32k forks source link

Support/document a duckdb connector #1331

Open cboettig opened 3 months ago

cboettig commented 3 months ago

🚀 The feature

duckdb is not listed among the supported connectors. It would be great to see support and/or documentation showing pandas-ai running with the latest duckdb-sql backend.

Motivation, pitch

duckdb has fantastic integration for python already. It offers an easier install / setup than most database backends and comparable or better performance than all of them. It supports direct access to remote parquet files over https or s3 and is very popular among data scientists. An ecosystem of extensions such as for spatial operations.

Alternatives

No response

Additional context

No response

dosubot[bot] commented 1 week ago

Hi, @cboettig. I'm Dosu, and I'm helping the pandas-ai team manage their backlog. I'm marking this issue as stale.

Issue Summary:

You suggested adding support and documentation for a duckdb connector in pandas-ai.
Highlighted duckdb's ease of installation, high performance, and popularity.
Noted its ability to access remote parquet files and its strong ecosystem of extensions.
No further comments or developments have been made on this issue.

Next Steps:

Please let us know if this issue is still relevant to the latest version of the pandas-ai repository by commenting here.
If there is no further activity, this issue will be automatically closed in 7 days.

Thank you for your understanding and contribution!

cboettig commented 1 week ago

thanks @dosubot, still an issue! Hopefully this is a simple fix since pandas-ai is already using duckdb internally.

dosubot[bot] commented 1 week ago

@gventuri, the user @cboettig has indicated that the issue regarding the duckdb connector is still relevant and hopes for a simple fix since pandas-ai is already using duckdb internally. Could you please assist them with this?