Chat DB FAQ#
Q1: What difference between ChatData and ChatDB#
ChatData generates SQL from natural language and executes it. ChatDB involves conversing with metadata from the Database, including metadata about databases, tables, and fields.
Q2: The suitable llm model currently supported for text-to-SQL is?#
Now vicunna-13b-1.5 and llama2-70b is more suitable for text-to-SQL.
Q3: How to fine-tune Text-to-SQL in DB-GPT#
there is another github project for Text-to-SQL fine-tune (https://github.com/eosphoros-ai/DB-GPT-Hub)
Q4: chatdata with clickhouse clickhouse-sqlalchemy 0.2.4 requires sqlalchemy<1.5,>=1.4.24, but you have sqlalchemy 2.0.20 which is incompatible#
Just set sqlalchemy<1.5,>=1.4.24
pip install clickhouse-driver
pip install sqlalchemy==1.4.24