Zum Inhalt springen
NEUMarktplatz und dein Team: Verkaufe, was du baust, und bekomm Pläne und Änderungen, die getestet sind, bevor du sie siehst. Neuigkeiten ansehen

Bibliothek / KI-Agenten & Assistenten

KI-Agenten & Assistenten

Mit OpenAI und QuickChart SQL-Fragen mit Diagrammen beantworten

Wird von einem anderen Workflow aufgerufen, extrahiert die Datenfrage eines Nutzers, führt eine Abfrage mit dem SQL Agent aus und nutzt die strukturierte Ausgabe von OpenAI sowie QuickChart, um eine Visualisierung zurückzugeben.

Was sie bewirkt

### Overview - This workflow aims to provide data visualization capabilities to a native SQL Agent. - Together, they can help foster data analysis and data visualization within a team. - It uses the native SQL Agent that works well and adds visualization capabilities thanks to OpenAI’s Structured Output and Quickchart.io. ### How it works 1. Information Extraction: - The Information Extractor identifies and extracts the user's question. - If the question includes a visualization aspect, the SQL Agent alone may not respond accurately. 2. SQL Querying: - It leverages a regular SQL Agent: it connects to a database, queries it, and translates the response into a human-readable format. 3. Chart Decision: - The Text Classifier determines whether the user would benefit from a chart to support the SQL Agent's response. 4. Chart Generation: - If a chart is needed, the sub-workflow dynamically generates a chart and appends it to the SQL Agent’s response. - If not, the SQL Agent’s response is output as is. 5. Calling OpenAI for Chart Definition: - The sub-workflow calls OpenAI via the HTTP Request node to retrieve a chart definition. 6. Building and Returning the Chart: - In the "Set Response" node, the chart definition is appended to a Quickchart.io URL, generating the final chart image. - The AI Agent returns the response along with the chart. ### How to use it - Use an existing database or create a new one. - For example, I've used this Kaggle dataset.

Die Schritte

  1. OpenAI Chat Model
  2. Execute Workflow
  3. Execute "Generate a chart" tool
  4. OpenAI - Generate Chart definition with Structured Output
  5. Set response
  6. When chat message received
  7. Set Text output
  8. Set Text + Chart output
  9. AI Agent
  10. Window Buffer Memory
  11. OpenAI Chat Model Classifier
  12. Text Classifier - Chart required?
  13. User question + Agent initial response
  14. Information Extractor - User question

Ähnliche Automatisierungen