---
title: "REX-2: AI Driven Analytics"
slug: rex-2-ai-driven-analytics-python-connect-to-any-database
date_published: 2025-01-19T12:48:29.543Z
original_url: https://www.tigzig.com/post/rex-2-ai-driven-analytics-python-connect-to-any-database
source: migrated
processed_at: 2025-12-14T10:00:00.000Z
---

# Releasing REX-2: AI Decision Intelligence


## 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](https://tigzig.com/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](https://www.youtube.com/watch?v=LoE64UBgz3s)

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