AI SQL Assistant

{% if success %}

{{ success }}

{% endif %} {% if summary %}

Database Summary

Overview

{{ summary.description }}

{% if summary.main_tables %}

Main Tables and Columns

    {% for table, columns in summary.main_tables.items() %}
  • {{ table }}: {{ columns | join(', ') }}
    • {% endfor %}
{% endif %} {% if summary.relationships %}

Key Relationships

    {% for relation in summary.relationships %}
  • {{ relation }}
    • {% endfor %}
{% endif %}

Suggestions

{{ summary.suggestions.evaluation }}

{{ summary.suggestions.note }}

{% if summary.suggestions.recommendations %}
    {% for rec in summary.suggestions.recommendations %}
  • {{ rec }}
    • {% endfor %}
{% endif %}
{% elif schema %}

Database Summary

Schema loaded, but no summary available. Tables: {{ schema.keys() | join(', ') }}.

{% endif %}
{% if error %}

{{ error }}

{% endif %} {% if query %} 
{{ query }}
{% endif %} {% if results %}

Query Results

{% for key in results[0].keys() %} {% endfor %} {% for row in results %} {% for key, value in row.items() %} {% endfor %} {% endfor %}
{{ key }}
{{ value }}
{% elif query and not error %}

No results found for the query. Check the data or try a different question.

{% endif %}