Releasing REX-2: AI Decision Intelligence

Published: November 24, 2024

Try it Free: rex.tigzig.com (Mobile/Web). Open Source.

Functionalities

• Natural Language (NL)-to-SQL: Query, Append, Join, Merge, Summarize, Transform
• Complex Analysis: Cards Segment Profiling example
• NL-to-Python: Statistical Analysis & Python Charts
• Interactive Tables: Sort, Filter, Stats (Central Tendency, Dispersion)
• Data Structure Reports & 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/pipe-delimited)
• Authentication: Auth0

Try it for Free

rex.tigzig.com - No API key needed. CSV/TXT files available. Link in 'Help' section on site. Currently optimized for web/desktop only.

Source Codes

4 GitHub repos plus schemas. Links in the 'Build' section on the website + detailed video guide.

Video Guide

• Using REX-2 Features: ~30 mins
• Complex Queries: ~30 min
• Build Guide: ~90 min
• 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 - large datasets (needs PCI)
• Advanced Statistical Analysis (needs PCI)
• Generic Excel to CSV Converters, Universal Web Scrapers
• Real-Time Voice (OpenAI Alt)
• Security / 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. Set up in under a minute with just a few clicks.

Tip: Voice-to-SQL

Voice-typed using Windows Voice (Win+H). Google Docs Voice Typing is also great. Longest prompt (~5 mins of voice instructions) converted into SQL (check out at YouTube timestamp 00:49:20).

Build Details

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

REX is an independent, open-source project I've developed as part of my desire to make Generative AI tools practical and accessible. It's also my way of sharing with the broader community, inspired by open-source platforms like Flowise that have benefited me immensely. Updates will roll out as I balance this with other projects.