n8n AI Data Management Engineering
Contributed by Sabrina Ramonov 🍄. From the community directory at agents.sabrina.dev, republished with permission and full credit.
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: An AI-powered chat interface allows users to ask questions about the tech radar.
- Customizable AI Agents:
- AI Agent Router: Determines the query type and routes it to the appropriate agent.
- SQL Agent: Processes queries using SQL on structured data.
- RAG Agent: Performs vector-based searches on document-like data.
- Output Guardrail Agent: Validates queries and ensures that the responses remain on-topic and accurate.
Usage Examples
- Tell me, is TechnologyABC adopted or on hold, and why?
- List all the tools that are considered part of the strategic direction for company3 but are not adopted.
Tools used: Google Sheets, AI Agent
Download the workflow template (JSON)
Want this running in your business? KOBA42 builds and operates automations like this one.