AutomationMart
Home/Browse/Build an AI-powered tech radar advisor with SQL DB, RAG, and routing agents
n8n

Build an AI-powered tech radar advisor with SQL DB, RAG, and routing agents

n8nn8n37 modulesv1.0
GitHub

AI-Powered Tech Radar Advisor This project is built on top of the famous open source ThoughtWorks Tech Radar. You can use this template to build your own AI-Powered Tech Radar Advisor for your company or group of companies. Target Audience This template is perfect for: - Tech Audit & Governance Leaders: Those seeking to build a tech landscape AI platform portal. - Tech Leaders & Architects: Those aiming to provide modern AI platforms that help others understand the rationale behind strategic te

At a glance

Build an AI-powered tech radar advisor with SQL DB, RAG, and routing agents is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects GitHub. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
GitHub
Modules
37
Price
Free
Version
v1.0
Build an AI-powered tech radar advisor with SQL DB, RAG, and routing agents workflow diagram

About this workflow

AI-Powered Tech Radar Advisor This project is built on top of the famous open source ThoughtWorks Tech Radar. You can use this template to build your own AI-Powered Tech Radar Advisor for your company or group of companies. Target Audience This template is perfect for: - Tech Audit & Governance Leaders: Those seeking to build a tech landscape AI platform portal. - Tech Leaders & Architects: Those aiming to provide modern AI platforms that help others understand the rationale behind strategic technology adoption. - Product Managers: Professionals looking to align product innovation with the company's current tech trends. - IT & Engineering Teams: Teams that need to aggregate, analyze, and visualize technology data from multiple sources efficiently. - Digital Transformation Experts: Innovators aiming to leverage AI for actionable insights and strategic recommendations. - Data Analysts & Scientists: Individuals who want to combine structured SQL analysis with advanced semantic search using vector databases. - Developers: Those interested in integrating RAG chatbot functionality with conversation storage. --- 1. Description Tech Constellation is an AI-powered Tech Radar solution designed to help organizations visualize and steer their technology adoption strategy. It seamlessly ingests data from a Tech Radar Google Sheet—converting it into both a MySQL database and a vector index—to consolidate your tech landscape in one place. The platform integrates an interactive AI chat interface powered by four specialized agents: - AI Agent Router: Analyzes and routes user queries to the most suitable processing agent. - SQL Agent: Executes precise SQL queries on structured data. - RAG Agent: Leverages semantic, vector-based search for in-depth insights. - Output Guardrail Agent: Validates responses to ensure they remain on-topic and accurate. This powerful template is perfect for technology leaders, product managers, engineering teams, and digital transformation experts looking to make data-driven decisions aligned with strategic initiatives across groups of parent-child companies. --- 2. Features Data Ingestion - A Google Sheet containing tech radar data is used as the primary source. - The data is ingested and converted into a MySQL database. - Simultaneously, the data is indexed into a vector database for semantic (vector-based) search. Interactive AI Chat - Chat Integration: An AI-powered chat interface allows users to ask questions about the tech radar. - Customizable AI Agents: 1. AI Agent Router: Determines the query type and routes it to the appropriate agent. 2. SQL Agent: Processes queries using SQL on structured data. 3. RAG Agent: Performs vector-based searches on document-like data. 4. Output Guardrail Agent: Validates queries and ensures that the responses remain on-topic and accurate. --- Usage Examples 1. Tell me, is TechnologyABC adopted or on hold, and why? 2. List all the tools that are considered part of the strategic direction for company3 but are not adopted. --- Project Links & Additional Details - GitHub Repository (Frontend Interface Source Code): github.com/dragonjump/techconstellation - Try It:

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Onboard employees from Google Forms with Slack, Jira, and GitHub access

How it works 1. New Google Form response triggers the workflow 2. Checks if employee was already onboarded (prevents duplicates) 3. Adds user to department-specific Slack channel 4. If in Software department, grants GitHub repo access 5. Invites user to Jira and creates an onboarding task 6. Updates Google Sheet status to "Completed" Set up steps Estimated setup time: 10-15 minutes 1. Connect Google Sheets (2 min) - Update sheet ID in trigger and update nodes 2. Configure Slack (3 min) -

Free

Facebook Messenger Chatbot That Learns From Your Documents

Quickstart Guide: Facebook Messenger Chatbot with Pinecone RAG Step-by-step instructions to get this workflow running in n8n. --- Prerequisites - Self-hosted n8n instance (v1.113.0+ recommended) - Community nodes enabled in n8n - Facebook Page (you must be an admin) - OpenAI account - Pinecone account (free Starter plan works) --- Workflow Architecture This workflow uses two webhooks with the same URL path but different HTTP methods: | Webhook | Method | Purpose | |---------|--------|---------|

Free

Report and clean up stale GitHub branches with Slack notifications

Quick Overview This workflow runs weekly (or manually) to scan GitHub repositories for merged-but-not-deleted and stale branches, then posts a cleanup report to Slack and can optionally auto-delete a capped number of branches. How it works 1. Runs on a weekly schedule or when you manually execute the workflow. 2. Loads configuration for the GitHub repo owner, repository list, stale age threshold, protected branch patterns, Slack channel, and deletion limits. 3. For each configured repository, fe

Free

Post new GitHub releases to Mattermost

Every time a GitHub release is created, Make will automatically post a Mattermost message.

Free

Chat with GitHub issues using OpenAI and Redis vector search

Chat with Your GitHub Issues Using AI 🤖 Ever wanted to just ask your repository what's going on instead of scrolling through endless issue lists? This workflow lets you do exactly that. What Does It Do? Turn any GitHub repo into a conversational knowledge base. Ask questions in plain English, get smart answers powered by AI and vector search. "Show me recent authentication bugs" → AI finds and explains them "What issues are blocking the release?" → Instant context-aware an

Free

Scrape TikTok influencer profiles with Bright Data API to Google Sheets

TikTok Influencer Scraper (URL Input) via Bright Data + n8n & Sheets A comprehensive n8n automation that scrapes TikTok influencer profiles using Bright Data's TikTok dataset and automatically saves detailed profile information to Google Sheets. 📋 Overview This workflow provides an automated TikTok influencer data collection solution that scrapes comprehensive profile information and saves it to Google Sheets. Perfect for influencer marketing research, competitor analysis, social media

Free

Generate Google ad copy automatically with Claude 3.5, Channable & Relevance AI

Channable + Google Ads + Relevance AI: Scalable AI Workflow for Automated Ad Copy Generation & Publishing --- 🧩 Overview This workflow automates the entire ad creation process for Google Ads by integrating product data, AI-generated copy, compliance checks, and publication into your marketing pipeline. It connects n8n, Relevance AI, Google Sheets, and optionally Channable to: Fetch product data from your catalog Generate Google Text Ad headlines and d

Free

Create chapter-wise notes and MCQ quizzes from YouTube with WayinVideo, GPT-4o-mini, Google Sheets, and Gmail

Quick overview Submit any YouTube lecture URL through a form and this workflow transcribes the full video using WayinVideo, generates chapter-wise study notes and a 5-question MCQ quiz per chapter using GPT-4o-mini, and delivers a formatted HTML email with everything ready for revision. How it works 1. You fill in a form with the YouTube lecture URL, subject name, number of chapters you want, and your email address. 2. The YouTube URL is submitted to the WayinVideo Transcription API v2, which be

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free