Hardware store product assistant with PostgreSQL & Google Gemini AI
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 12 nodes and runs when a chat message arrives (plus 1 other trigger). Along the way it connects Postgres, Google Gemini Chat Model and MCP Client.
How it runs
Trigger: When a chat message arrives (plus 1 other trigger).
- AI Agent: runs an AI agent, with model: Language Model (Google Gemini); 1 tool (DB Tools Client); memory: Chat Memory
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (7)
- MCP Server Trigger
@n8n/n8n-nodes-langchain.mcpTrigger - Postgres Tool
n8n-nodes-base.postgresTool - Chat Trigger
@n8n/n8n-nodes-langchain.chatTrigger - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - MCP Client Tool
@n8n/n8n-nodes-langchain.mcpClientTool
From the author
🤖 AI-Powered Hardware Store Assistant with PostgreSQL & MCP Supercharge your customer service with this conversational AI agent! This n8n workflow provides a complete solution for a hardware store chatbot that connects to a PostgreSQL database in real-time.…