Automate OEE Data Analysis with n8n & PostgreSQL 🤖

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&currency_code=USD&amount=3
👉 $5: https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=yaseralie@gmail.com&item_name=Support+My+Tech+Projects&currency_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&currency_code=USD

#n8n #PostgreSQL #AI #OEE #DataAnalysis #Automation #GoogleGemini #AIAgent