Function createSQLPrompt

frontend/src/lib/ai/prompts/sqlPrompts.ts:368–409

(
  userPrompt: string,
  context: AIContextData,
  options?: {
    includeExplanation?: boolean;
    maxRows?: number;
    includeOptimization?: boolean;
  }
)

};

export const createSQLPrompt = (
  userPrompt: string,
  context: AIContextData,
  options?: {
    includeExplanation?: boolean;
    maxRows?: number;
    includeOptimization?: boolean;
  }
): string => {
  const maxRows = options?.maxRows || 100;
  let prompt = `Generate a SQL query for: "${userPrompt}"

Table: ${context.tableName}
Available columns: ${context.schema
    .map((col) => `${col.name} (${col.type})`)
    .join(', ')}

Requirements:
- Use DuckDB syntax
- Include LIMIT ${maxRows} unless the user specifically requests more
- Ensure column names match exactly
- Handle data types properly`;

  if (options?.includeExplanation) {
    prompt += '\n- Include a brief explanation of the query';
  }

  if (options?.includeOptimization) {
    prompt += '\n- Suggest any performance optimizations';
  }

  if (context.sampleData && context.sampleData.length > 0) {
    const sampleDataStr = context.sampleData
      .slice(0, 3)
      .map((row) => JSON.stringify(row))
      .join('\n');
    prompt += `\n\nSample data for reference:
${sampleDataStr}`;
  }

  return prompt;
};

export const createDataAnalysisPrompt = (
  userPrompt: string,