AcademyWorkflowsData and reporting

Chat with a database using AI

Data and operations teams that want to ask questions about database records in a chat.

  • Recommendedour rating
  • 28,371views on n8n
Open on n8n.io ↗

Paste it straight onto an n8n canvas with Ctrl+V or Cmd+V.

chat-with-a-database-using-ai.json

Loading the file...

What it does

An n8n workflow that lets you ask questions in plain language about data stored in a database. An OpenAI model writes the answers, and it works with Postgres, MySQL and SQLite through n8n's embedded chat. It needs n8n version 1.19.4 or later.

Use cases

  1. 01Ask a question about records in a Postgres table
  2. 02Look up figures stored in a MySQL database
  3. 03Connect the chat to Slack or Microsoft Teams

Connects

AI Agent · OpenAI Chat Model

Questions about
Chat with a database using AI.

What is Chat with a database using AI used for?

Data and operations teams that want to ask questions about database records in a chat. An n8n workflow that lets you ask questions in plain language about data stored in a database. An OpenAI model writes the answers, and it works with Postgres, MySQL and SQLite through n8n's embedded chat. It needs n8n version 1.19.4 or later.

How do I import Chat with a database using AI into n8n?

Copy the workflow JSON from this page and paste it onto the n8n canvas with Ctrl+V or Cmd+V. Then connect your credentials in each node.

Is Chat with a database using AI safe to use?

It passed our automatic scan for credential theft, hidden instructions and risky install commands. Third party open source software. Sabemos AI does not maintain it. Check the code and permissions before you connect it to company data.