Automate OEE Data Analysis with n8n & PostgreSQL π€
Learn to set up n8n AI Agent for OEE data analysis with PostgreSQL in this step-by-step tutorial.

Yaser Ali Husen
4.4K views β’ Aug 15, 2025

About this video
In this video, Iβll walk you through how to set up an n8n AI Agent to interact with a PostgreSQL database for OEE (Overall Equipment Effectiveness) data analysis.
β Configure AI to read and analyze real database data
β Use PostgreSQL tools like Table List, Table Schema, and Execute Query
β Create clear rules with System Message to ensure accurate and consistent AI responses
β Understand how Simple Memory works and when to use it
β Test AI queries and validate them against your database
π‘ This is a basic implementation
β In a more advanced setup, you can integrate it with WhatsApp or Telegram for direct userβAI interaction
π What youβll need:
β n8n installed (VPS or local)
β PostgreSQL database with OEE data or another data
β API key for your AI model (e.g., Google Gemini)
π Useful Links:
β n8n Installation Guide on VPS: https://www.youtube.com/watch?v=R6HsF8Ndeas
β n8n Documentation: https://docs.n8n.io/
Example Code: https://yaseralie.github.io/Example-OEE-n8n-PostgreSQL/
π‘ Enjoying my content? Support my work and help me keep sharing tech tips!
β Buy me a coffee via PayPal:
π $3: https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=yaseralie@gmail.com&item_name=Support+My+Tech+Projects¤cy_code=USD&amount=3
π $5: https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=yaseralie@gmail.com&item_name=Support+My+Tech+Projects¤cy_code=USD&amount=5
π Choose your own amount: https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=yaseralie@gmail.com&item_name=Support+My+Tech+Projects¤cy_code=USD
#n8n #PostgreSQL #AI #OEE #DataAnalysis #Automation #GoogleGemini #AIAgent
β Configure AI to read and analyze real database data
β Use PostgreSQL tools like Table List, Table Schema, and Execute Query
β Create clear rules with System Message to ensure accurate and consistent AI responses
β Understand how Simple Memory works and when to use it
β Test AI queries and validate them against your database
π‘ This is a basic implementation
β In a more advanced setup, you can integrate it with WhatsApp or Telegram for direct userβAI interaction
π What youβll need:
β n8n installed (VPS or local)
β PostgreSQL database with OEE data or another data
β API key for your AI model (e.g., Google Gemini)
π Useful Links:
β n8n Installation Guide on VPS: https://www.youtube.com/watch?v=R6HsF8Ndeas
β n8n Documentation: https://docs.n8n.io/
Example Code: https://yaseralie.github.io/Example-OEE-n8n-PostgreSQL/
π‘ Enjoying my content? Support my work and help me keep sharing tech tips!
β Buy me a coffee via PayPal:
π $3: https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=yaseralie@gmail.com&item_name=Support+My+Tech+Projects¤cy_code=USD&amount=3
π $5: https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=yaseralie@gmail.com&item_name=Support+My+Tech+Projects¤cy_code=USD&amount=5
π Choose your own amount: https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=yaseralie@gmail.com&item_name=Support+My+Tech+Projects¤cy_code=USD
#n8n #PostgreSQL #AI #OEE #DataAnalysis #Automation #GoogleGemini #AIAgent
Video Information
Views
4.4K
Likes
127
Duration
11:33
Published
Aug 15, 2025
User Reviews
4.6
(4) Related Trending Topics
LIVE TRENDSRelated trending topics. Click any trend to explore more videos.
Trending Now