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
- 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.