Generate Complete Database Schemas with Claude for SQL Databases

by Evervise ✓ · 1,862 views · created 2025-10-13 · Lead Generation, AI Chatbot

What this workflow does

This AI workflow has 20 nodes and runs when someone submits an n8n form (“AI Database Architect - By Evervise”). Along the way it connects Anthropic Chat Model and Postgres.

How it runs

Trigger: When someone submits an n8n form (“AI Database Architect - By Evervise”).

1. Initialize Variables (Edit Fields (Set)): sets 3 fields: iteration_count, previous_feedback, form_data
2. Agent 1: Database Architect (AI Agent): runs an AI agent, with model: Architect Model
3. Agent 2: Schema Reviewer (AI Agent): runs an AI agent, with model: Reviewer Model
4. Agent 3: Optimizer & Scorer (AI Agent): runs an AI agent, with model: Optimizer Model
5. Is Score A or B? (If): checks a condition and branches into true / false
6. Agent 4: Generate SQL Script (AI Agent): runs an AI agent, with model: SQL Generator Model
7. Track Iteration (Edit Fields (Set)): sets 3 fields: iteration_count, previous_feedback, form_data
8. If: checks a condition and branches into true / false
9. Can Retry? (If): checks a condition and branches into true / false
10. Execute SQL in PostgreSQL (Postgres): run a query

…plus 5 more steps. See the full node list below.

Services it uses

Anthropic Chat ModelPostgres

Before you upgrade to n8n 3.0

Nodes used (7)

• Edit Fields (Set)n8n-nodes-base.set
• Anthropic Chat Model@n8n/n8n-nodes-langchain.lmChatAnthropic
• AI Agent@n8n/n8n-nodes-langchain.agent
• Ifn8n-nodes-base.if
• n8n Formn8n-nodes-base.form
• Postgresn8n-nodes-base.postgres
• n8n Form Triggern8n-nodes-base.formTrigger

From the author

Transform database design from weeks to minutes with this intelligent multi-agent system. Perfect for agencies, consultancies, and SaaS companies offering database architecture as a lead magnet or service. 🤖 4 Specialized AI Agents: - Agent 1 (Architect):…

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