File size: 2,382 Bytes
c94208c
 
 
 
 
 
 
4d8021b
c94208c
 
101df2f
c94208c
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
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.
        """
    )