OpenAI Chat Assistant with Postgres Memory & MySQL

This n8n workflow builds a general-purpose OpenAI Assistant chatbot that remembers conversations using Postgres-backed chat memory while also being able to query a MySQL database and call external APIs to answer real-time questions. Rather than resetting with every session, the assistant retains context across conversations, making follow-up questions feel natural, and it can pull live data from your systems instead of relying on static training knowledge alone. Ideal for businesses that need a versatile internal chatbot connected to their existing data infrastructure, whether for support, operations, or internal tooling. The result is a flexible, persistent-memory AI assistant that acts as a true conversational interface to your databases and APIs.

Category: AI Chatbots