Text 2 SQL

ttian7.eth

https://docs.llamaindex.ai/en/stable/examples/index_structs/struct_indices/SQLIndexDemo.html
I read the text 2 sql demo but haven't found where openai is used here. Is there a complete code rather than step by step?

5 comments

WWhiteFang_Jr

https://docs.llamaindex.ai/en/stable/examples/index_structs/struct_indices/SQLIndexDemo.html#part-1-text-to-sql-query-engine

NLSQLTableQueryEngine uses llm to convert queries into sql queries. It can be either openai or any opensource llm.

ttian7.eth

well. So when a sqldatabase instance is initialized there should be an engine and that's where the open ai input?
https://docs.llamaindex.ai/en/stable/examples/index_structs/struct_indices/SQLIndexDemo.html#define-sql-database

Plain Text

from llama_index import SQLDatabase, ServiceContext
from llama_index.llms import OpenAI
llm = OpenAI(temperature=0.1, model="gpt-3.5-turbo")
service_context = ServiceContext.from_defaults(llm=llm)
sql_database = SQLDatabase(~~engine~~ service_context , include_tables=["city_stats"])

Just need to replace engine with service_context, right?

LLogan M

@tian7.eth just add the service context as a kwarg when constructing the query engine

LLogan M

Here

https://docs.llamaindex.ai/en/stable/examples/index_structs/struct_indices/SQLIndexDemo.html#part-1-text-to-sql-query-engine

ttian7.eth

Thanks. I wonder why it doesn't add the service context arg when declaring the query engine. And where I can more examples using query engine. I want to know which parameters it supports

Add a reply

Find answers from the community

Text 2 SQL