I m trying to build a chat engine on my

Does engine = index.as_chat_engine() not work?

index is for pdf docs right?
For sql , I can't find anythin here - https://gpt-index.readthedocs.io/en/v0.7.3/guides/tutorials/sql_guide.html

index is for pdf docs right?
For sql , I can't find anythin here - https://gpt-index.readthedocs.io/en/v0.7.3/guides/tutorials/sql_guide.html

Index is for every item. You can give this a try

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)

query_engine = NLSQLTableQueryEngine(
sql_database=sql_database,
synthesize_response=True,
# tables=["Master_data_v2"],
service_context=service_context
)

response = query_engine.query("How many records are there?")

Oh so NLSQLTableQueryEngine is directly creating a query engine. Crating a chat engine is not possible in this case.

yea, so how we do that? Sorry have I done it wrong?

No you have not!. Actually the Class that youa re currently using creates engine directly.

Found one module on llamahub:https://llamahub.ai/l/tools-database
This allows you to chat with your record. Give it a try