Is there a way to load the schema of the sqlite database in Index or VectorStore?

[rajendradewani]

I would like to store the schema of my SQLite database in index or VectorStore.

I can then ask questions about the database and get the SQL statement.
Once I have the SQL statement, I want them to execute it against the actual database on my machine and get the output.

Is it possible? If yes, please help me how to move ahead.

I have successfully implemented - https://python.langchain.com/en/latest/modules/chains/examples/sqlite.html
I am able to query small tables.
I have around 150 tables; each table may have 70 to 140 columns.

Thus it exceeds the token limit if I use something like
List the top 10 customers based on total sales this year

This involves two tables Customer (140 columns) , Sales (110) columns.
I get the token exceeded issue.

I thought I could load the schema in Index or VectorStore and get it to work.
FYI, I am using GPT-3.5.

Any help is highly appreciated.