Templates / Query n8n credentials with AI SQL agent

Query n8n credentials with AI SQL agent

Needs changes

by Jimleuk ✓ · 5,413 views · created 2024-07-15 · DevOps, AI RAG

Needs changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.

What this workflow does

This AI workflow has 9 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects OpenAI Chat Model.

How it runs

Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).

  1. n8n: uses n8n
  2. Workflow Credentials Helper Agent (AI Agent): runs an AI agent, with model: OpenAI Chat Model; 1 tool (Query Workflow Credentials Database); memory: Window Buffer Memory
  3. Map Workflows & Credentials (Edit Fields (Set)): sets 3 fields: workflow_id, workflow_name, credentials
  4. Save to Database (Code): runs custom Python code

Services it uses

OpenAI Chat Model

Before you upgrade to n8n 3.0

1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:

  • AI Agent v1 (old agent modes) in Workflow Credentials Helper Agent (v1.6): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Removed in 3.0Replace with
AI Agent v1 (old agent modes)
Workflow Credentials Helper Agent (v1.6)
Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.

Nodes used (9)

From the author

This n8n workflow is a fun way to query and search over your credentials on your n8n instance. Good to know Your credentials should remain safe as this workflow does not decrypt or use any decrypted data. Example Usage "Which workflows are using Slack and…

Excerpt from Jimleuk's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.