Analyze Zabbix infrastructure health with Gemini and PostgreSQL
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 21 nodes and runs when an HTTP GET request hits its webhook URL. Along the way it connects Postgres, Redis Chat Memory and Google Gemini Chat Model.
How it runs
Trigger: When an HTTP GET request hits its webhook URL.
- Normalize Payload (Code): runs custom JavaScript code
- Prepare Context (Code): runs custom JavaScript code
- Gemini · Infra Agent (AI Agent): runs an AI agent, with model: Gemini 2.0 Flash; 11 tools (search_hosts, get_host_items, get_disk_growth, get_group_hosts…); memory: Redis Chat Memory
- Render SVG Charts (Code): runs custom JavaScript code
- Fallback Response (Edit Fields (Set)): sets or maps fields
- Respond (Respond to Webhook): sends the response back to the webhook caller
- Prepare Context (Code): runs custom JavaScript code
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in Gemini · Infra Agent (v1.7): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) Gemini · Infra Agent (v1.7) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (8)
- Respond to Webhook
n8n-nodes-base.respondToWebhook - Webhook
n8n-nodes-base.webhook - Edit Fields (Set)
n8n-nodes-base.set - Postgres Tool
n8n-nodes-base.postgresTool - Code
n8n-nodes-base.code - Redis Chat Memory
@n8n/n8n-nodes-langchain.memoryRedisChat - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - AI Agent
@n8n/n8n-nodes-langchain.agent
From the author
Quick overview This workflow exposes a Basic Auth webhook that routes infrastructure questions to a IA agent, which queries a Zabbix PostgreSQL database for host, alert, and performance metrics and returns a Markdown response with inline SVG charts, using…