Built with Flowise. Leverage as a reusable component
With agent templates, tool schemas and source codes.
𝟔 𝐝𝐚𝐭𝐚𝐛𝐚𝐬𝐞 𝐚𝐠𝐞𝐧𝐭 𝐨𝐩𝐭𝐢𝐨𝐧𝐬
The Analyzer micro-app on REX-3 (rex.tigzig.com) offers 6 agent options, all capable of:
- connecting to any database (with credentials)
- natural-language-to-SQL
- natural-language to python (for charts & stats)
App also allows on-the-fly Postgres database for file uploads and temp use
𝐀𝐈 𝐛𝐚𝐜𝐤𝐞𝐧𝐝 𝐢𝐬 𝐨𝐧 𝐅𝐥𝐨𝐰𝐢𝐬𝐞 𝐀𝐈. 𝐋𝐞𝐯𝐞𝐫𝐚𝐠𝐞 𝐚𝐬 𝐚 𝐫𝐞𝐮𝐬𝐚𝐛𝐥𝐞 𝐜𝐨𝐦𝐩𝐨𝐧𝐞𝐧𝐭:
- directly via Flowise’s native UI (Click </> → Share Chatbot → Live)
- plugged into any UI via API (as in REX-3)
- integrated into automated workflows via API
Easy to setup, modify and maintain.
🕵️ 𝐒𝐭𝐚𝐧𝐝𝐚𝐥𝐨𝐧𝐞 𝐆𝐞𝐧𝐞𝐫𝐚𝐥 𝐀𝐧𝐚𝐥𝐲𝐬𝐭
Single-agent setup for regular queries & simple analysis. Uses o3-mini; for complex cases, I use gpt-4o
🕵️ 𝐌𝐮𝐥𝐭𝐢-𝐀𝐠𝐞𝐧𝐭𝐬 (technically sequential agents in Flowise, Backend: LangGraph)
Three-agent flow: Gemini-Flash-2 / o3-mini / Deepseek-R1. Agent flow:
▪ 𝐑𝐨𝐮𝐭𝐞𝐫 𝐀𝐠𝐞𝐧𝐭 → Determines if a query goes to General or Advanced Analyst
▪ 𝐆𝐞𝐧𝐞𝐫𝐚𝐥 𝐀𝐧𝐚𝐥𝐲𝐬𝐭 → Same as standalone version above
• 𝐀𝐝𝐯𝐚𝐧𝐜𝐞𝐝 𝐀𝐧𝐚𝐥𝐲𝐬𝐭 →
- Step 1: Reasoning LLM (o3-mini / Flash-2 / Deepseek-R1) generates analysis plan & SQL
- Step 2: gpt-4o agent verifies query accuracy, executes, and returns results
🕵️ Multi (Sequential) Agents with Additional Debugging. Still in testing. Similar to sequential agents but with:
- one has and additional error-checking step
- other is a debugger agent for routing based on user request
𝐓𝐚𝐤𝐞 𝐭𝐡𝐞𝐦 𝐟𝐨𝐫 𝐚 𝐬𝐩𝐢𝐧
REX-3 (rex.tigzig.com)
Feel free to test out with different data/query complexity/agent choices—no API key needed. Connect to your database or use the temporary Postgres DB (created on-the-fly for file uploads). Upload your own files or just hit the 'Sample' button for sample file upload.
𝐒𝐨𝐮𝐫𝐜𝐞 𝐂𝐨𝐝𝐞𝐬/ 𝐑𝐞𝐬𝐨𝐮𝐫𝐜𝐞𝐬
🔹Flowise agent templates & tool schemas
All schemas + source codes → REX website (Help & Build section)
🔹Detailed Video Guide – Demo & Build Walkthrough
https://lnkd.in/dzxuziAD (~1hr ; with time-stamped sections)
Covers: Agent architecture, SQL errors, API failures, error handling, cost, performance, quality, latency
🔹Top Flowise Resource
Leon van Zyl’s YouTube → @leonvanzy (best guide out there)
Explore 15+ open-source AI analytics apps at rex.tigzig.com with natural language to SQL, python charts, stats, database connectivity and more. Free access, source codes and build guides
🔹𝐀𝐈 𝐂𝐨-𝐀𝐧𝐚𝐥𝐲𝐬𝐭 𝐀𝐝𝐯𝐚𝐧𝐜𝐞𝐝 𝐀𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐬 𝐀𝐩𝐩: https://lnkd.in/g8xPQvb8
🔹𝐀𝐈 𝐀𝐮𝐭𝐨𝐦𝐚𝐭𝐢𝐨𝐧 𝐌𝐢𝐜𝐫𝐨 𝐀𝐩𝐩: https://lnkd.in/gxVbCdpv
🔹𝐑𝐞𝐚𝐥𝐭𝐢𝐦𝐞 𝐒𝐐𝐋 𝐕𝐨𝐢𝐜𝐞 𝐀𝐈: https://lnkd.in/g6cT8ZSM https://lnkd.in/gCT9J_K4
🔹𝐂𝐨𝐧𝐧𝐞𝐜𝐭 𝐂𝐡𝐚𝐭𝐆𝐏𝐓 𝐭𝐨 𝐒𝐮𝐩𝐚𝐛𝐚𝐬𝐞 𝐢𝐧 𝟏𝟎 𝐦𝐢𝐧𝐮𝐭𝐞𝐬: https://lnkd.in/g2A9h8f2