The community member is trying to build a chat engine on their tabular database (pandas or SQL) and is looking for an example of how to do that. The comments suggest that the index.as_chat_engine() function may not work for SQL databases, and the community member is having trouble finding a solution in the GPT-Index documentation. Another community member suggests using the NLSQLTableQueryEngine class, but the community member notes that it creates a query engine directly and does not support creating a chat engine. Finally, a community member suggests trying a module from Llamahub that allows chatting with database records, but no explicit answer is provided.
I'm trying to build a chat engine on my tabular databse. (pandas or sql) Can someone share an example how can we do that? I'm able to built query engine, but it has to support conversations hence resorting to chat engine.
Can you be kind enough to spot where and how to place index? Here is my code: engine = create_engine("sqlite:////content/Master_data_v2.db") sql_database = SQLDatabase(engine)