Zum Inhalt springen
NEUMarktplatz und trig8n Agent: Verkaufen Sie, was Sie bauen, und erhalten Sie Pläne und Änderungen, die getestet sind, bevor Sie sie sehen. Neuigkeiten ansehen

Bibliothek / KI-Agenten & Assistenten

KI-Agenten & Assistenten

Diagramme aus SQL-Agent-Antworten mit OpenAI und QuickChart erstellen

Unterworkflow, der von einem anderen Workflow aufgerufen wird, erkennt Visualisierungsanfragen mit OpenAI Structured Output und erstellt Diagramme über QuickChart.io zusammen mit den SQL-Agent-Ergebnissen.

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