@spec parse_suggestions(String.t()) :: [map()]

Parse the AI response into a list of suggestion maps.

Returns a list of validated suggestion maps or an empty list if parsing fails.

@spec system_prompt(atom()) :: String.t()

Generate system prompt for query optimization analysis.

Parameters

• database_type - Database type (e.g., :postgres, :mysql, :sqlite)

@spec user_prompt(String.t(), String.t() | nil, String.t() | nil) :: String.t()

Build the user prompt containing the SQL and execution plan.

Parameters

• sql - The SQL query to optimize
• execution_plan - The execution plan string (from EXPLAIN)
• schema_context - Optional schema context string