Spaces:
Sleeping
Sleeping
Download llm_utils.py from prithvi55/talk2data: direct link, hf CLI and curl.
- Browser
- Download file 2.38 kB
-
https://huggingface.co/spaces/prithvi55/talk2data/resolve/main/llm_utils.py
- Command line
-
hf download hf://spaces/prithvi55/talk2data/llm_utils.py
-
curl -L -o llm_utils.py https://huggingface.co/spaces/prithvi55/talk2data/resolve/main/llm_utils.py
2.38 kB
| from langchain_groq import ChatGroq | |
| from langchain.prompts import PromptTemplate | |
| from langchain.chains import LLMChain | |
| import os | |
| def get_llm(): | |
| return ChatGroq( | |
| model="llama-3.3-70b-versatile", | |
| temperature=0.0, | |
| max_retries=2, | |
| api_key=os.environ.get("groq_key") | |
| ) | |
| def get_sql_prompt(): | |
| return PromptTemplate( | |
| input_variables=["question", "schema"], | |
| template=""" | |
| You are an expert SQL query generator and database assistant for a SQLite database. Given the following database schema: | |
| {schema} | |
| For any question that is not about the schema or database structure, ALWAYS generate a valid SQL query that answers the user's request. Do not ask for clarification, do not return explanations, just return the SQL query. | |
| If the user asks for a list of tables, schema details, or information about the database structure, provide a clear and concise answer using the schema provided, not SQL. | |
| If the user asks for a SQL query, generate an optimized SQL query for this user request: | |
| "{question}" | |
| Guidelines: | |
| - Only use functions and syntax supported by SQLite. Do NOT use EXTRACT, INTERVAL, DATEADD, or other non-SQLite features. | |
| - For date filtering, use strftime (e.g., strftime('%Y', "Table"."Date") = strftime('%Y', 'now', '-1 year')). | |
| - Use proper JOINs if necessary. | |
| - Always prefix column names with their table names to avoid ambiguity. | |
| - Ensure column and table names are used exactly as in the schema, including case, spaces, and special characters. | |
| - Always enclose both table and column names in double quotes, e.g., "TableName"."Column Name". This is required for names with spaces or special characters. | |
| - Order results logically and apply LIMIT where needed (e.g., for 'top N' queries). | |
| - Only use columns and tables present in the schema above. Do not invent or guess names. | |
| - If unsure, ask the user to clarify or show the schema. | |
| Example for date filtering in SQLite: | |
| To get records from the previous year: | |
| WHERE strftime('%Y', "Table"."Date") = strftime('%Y', 'now', '-1 year') | |
| Return only the SQL query—no explanations. | |
| """ | |
| ) | |