Library / RAG & Knowledge Bases
RAG & Knowledge Bases
Chat with a Tech Radar via Claude and Pinecone
On a schedule or chat request, it syncs a tech radar from Google Sheets and Docs into MySQL and Pinecone so an AI agent can answer questions.
What it does
## Chatting Stage : CHAT ENDPOINT ### Purpose This endpoint api allows you to chat with the ai agent. The ai agent input router will determine if the nature of question best answered with RAG or SQL agent. Then it invokes the workflow rag or workflow db agent accordingly. When the answer comes back , there is an AI agent output guardrail that uses the answer and validates before responding. ### How to integrate 1. Connect your frontend interface to this api below. You may change the base endpoint to webhook or webhook-test depending on your environment. You can also change the based the endpoint 'https://n8n.io' to your own hosted domain like 'https://mycustomdomain.io/' curl -X POST 'https://n8n.jom.lol/webhook-test/radar-rag' -H 'Content-Type: application/json' -d '{ "chatInput": "i wanna write agentic ai code, which strategic direction " }' curl -X POST 'https://n8n.jom.lol/webhook-test/radar-rag' -H 'Content-Type: application/json' -d '{ "chatInput": "is backstage used by company2 " }' 2. You will see a sample output response: [ { "output": "Based on the researched answer provided, the tools that are considered strategic directions but are not used by company3 are:\n\n* Automatically generate Backstage entity descriptors (technique)\n* Arm in the cloud (platform)\n* Azure OpenAI Service (platform)\n* Infrastructure orchestration platforms (platform)\n* Rancher Desktop (platform)\n* Conan (tool)\n* Karpenter (tool)\n* GitHub Copilot (tool)\n* Renovate (tool)\n* Velero (tool)\n* Continue (tool)\n* LLaVA (tool)\n* Ollama (tool)\n* DataComPy (language and framework)\n* Ray (language and framework)\n* Concrete ML (language and framework)\n* Crux (language and framework)\n* Electric (language and framework)\n* Mojo (language and framework)\n\nThese tools and technologies are considered strategically important for the organization, but for various reasons, they haven't been adopted by company3 yet." } ] [ { "output": "Based on the researched answer provided, the answer to your question is:\n\nAccording to our records, the \"Automatically generate Backstage entity descriptors\" feature, which is related to Backstage, is not currently being used by Company 2. However, it does not necessarily mean that Backstage as a whole platform is not used by Company 2 in some other capacity. If you need more detailed information about Backstage's overall usage in Company 2, p
The steps
- Download Doc File From Google Drive
- Doc File Data Loader
- Cron
- MySQL -delete all data
- MySQL - insert all from sheets
- Google Sheets - Tech Radar
- Code - Transform table into rows
- Google Docs - Update GDoc
- Google Drive - Doc File Updated
- Content - Recursive Character Text Splitter
- Google Sheets - Read TechRadar
- Code - Simplify Mapping to Original Query
- Codes - Simplify Mapping to Original Query
- Execute Workflow - Sql Agent
37 steps in total.
Similar automations