AI SQL Agent with Dynamic Charting

This template combines the power of an AI-driven SQL Agent with automated chart generation. It allows you to query your database in natural language and, when relevant, automatically generates charts to enhance data interpretation. By leveraging OpenAI’s structured output and QuickChart.io, this workflow transforms plain SQL responses into interactive, easy-to-read visualizations.

Features

• 💬 Natural Language to SQL – Ask questions in plain English and get SQL queries executed against your database.
• 📈 Dynamic Chart Generation – Automatically decides when a chart is helpful and generates one for clearer insights.
• 🤖 AI-Powered Responses – Uses OpenAI for structured outputs and smart chart configuration.
• 🔄 Flexible Database Support – Works with PostgreSQL, MySQL, or SQLite (using provided credentials).
• ⚡ Integrated Workflow Automation – Seamlessly combines querying, classification, and visualization into one flow.
• 🗂️ Dataset Ready – Works out-of-the-box with datasets like the Coffee Sales dataset from Kaggle, but can be adapted to your own data.