Use Cases
- Generate visual representations of SQL query results for enhanced data analysis.
- Provide users with immediate insights from database queries through chat interactions.
- Automatically create charts based on user requests for better data comprehension.
How It Works
Extract user questions from chat inputs using an information extractor. Query the connected SQL database to retrieve relevant data. Determine if a chart is required based on the response context. Generate a Chart.js definition using OpenAI's structured output. Return both textual and visual data outputs to the user.
Setup Steps
- 1Import the workflow into your n8n instance.
- 2Connect your SQL database credentials.
- 3Set up OpenAI credentials for API access.
- 4Activate the workflow and start interacting with the AI SQL Agent.
Apps Used
OpenAI
Quickchart.io
PostgreSQL
Categories
Target Roles
Tags
#ai chatbots
#ai content generation
#process automation