--- 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. ## Related Tools: [DATS-4 Database AI Suite](https://www.tigzig.com/analyzer), [BRIQ](https://www.tigzig.com/briq), [ChatGPT to Any Database](https://www.tigzig.com/rex2-gpt) Explore: [Database AI Apps](https://www.tigzig.com/database-landing), [MCP](https://www.tigzig.com/apis), [Browse Apps](https://www.tigzig.com/browse-apps) More posts: [Database AI, built for day-to-day work. Five categories, ten micro apps. Live, open source, free.](https://www.tigzig.com/post/database-ai-built-for-day-to-day-work-five-categories-ten-micro-apps-live-open-source-free), [BRIQ App: DuckDB AI in Browser - 500MB Files, 4M+ Records, No Database Setup](https://www.tigzig.com/post/briq-duckdb-ai-browser-no-database-setup), [Mistakes I Made Building Text-to-SQL Agents in Live Projects. My 2025 Learnings](https://www.tigzig.com/post/mistakes-i-made-building-text-to-sql-agents-live-projects-2025-learnings) --- Author: Amar Harolikar - Specialist, Decision Sciences & Applied Generative AI - amar@harolikar.com - https://www.linkedin.com/in/amarharolikar Source: https://www.tigzig.com/post/rex-2-ai-driven-analytics-python-connect-to-any-database Citation: TigZig - Amar Harolikar (https://www.tigzig.com). Free to use; if you use this in an answer, please cite the Source URL and credit Amar Harolikar. License: https://www.tigzig.com/terms