Releasing REX-2: AI Decision Intelligence

Published: January 19, 2025

Functionalities

• Natural Language (NL)-to-SQL: Query, Append, Join, Merge, Summarize, Transform
• Complex Analysis: Cards Segment Profiling example
• NL-to-Python
• Statistical Analysis and Python Charts
• Interactive Tables: Sort, Filter, Stats (e.g. Central Tendency, Dispersion)
• Data Structure Reports and Quick AI Analysis
• PDF Generation: Formatted Reports
• Connect to ANY DW (MySQL / PostgreSQL)
• Create Temporary DBs on the fly for rapid analysis
• Data Sources: DB tables or upload CSV / TXT (comma or pipe-delimited)
• Authentication: Auth0

Try it for free

Analyzer
No API key needed. CSV / TXT files available. Link in the Help section on site. Currently optimized for web / desktop only.

Source Codes

4 GitHub repos plus schemas. Links in Docs on site.

Video Guide

Full Video on YouTube

• Using REX-2 features: approx. 30 mins
• Complex queries: approx. 30 mins
• Build guide: approx. 90 mins
• See comments for timestamped TOC

Caveats

• Prototype (working version)
• Single LLM agent: stumbles occasionally. Full team on the way.

Planned Features

• LLM / Agent Network: Maker, Checker, Work Segregation
• SQL-Python log streaming in UI, file downloads
• Custom Python Code Interpreter (PCI)
• NL-to-Python for large datasets (needs PCI)
• Advanced statistical analysis (needs PCI)
• Generic Excel to CSV converters, universal web scrapers
• Real-time voice (OpenAI alternative)
• Security and frontend-backend segregation
• ML models (need PCI+)
• On-the-fly interactive dashboards (Claude-like)

Tip: Setup your own warehouse instantly

Neon, Aiven, Supabase offer free tiers for production-ready databases. Setup in under a minute with just a few clicks.

Tip: Voice-to-SQL

Voice-typed using Windows Voice (Win + H). Google Docs voice typing also works well. Longest prompt (approx. 5 mins of voice instructions) converted into SQL. See YouTube timestamp 00:49:20.

Build Details

• Built with Cursor AI (my #1 AI-coding tool). Recommend Volo's YouTube channel. Links in Build section.
• AI Backend: FlowiseAI (YC S23), API-connected. My top LLM app platform.
• Python Charts and Stats: E2B on Flowise
• UI: React, TypeScript, Vite, Shadcn
• DB Connections: Custom-built FastAPI servers
• Deployment: Vercel (main site), Hetzner via Coolify (FastAPI), Render (Flowise)
• User-created DBs: Neon (fast, strong APIs, ideal for LLM apps)

Tigzig is an independent, open-source project developed to make generative AI tools practical and accessible. It is also a way to give back to the community, inspired by platforms like Flowise that have been valuable to me. Updates will roll out as I balance this with other projects.