Know What's Happening in AI

Unlocking the Power of Data: How We Built Text-to-SQL with Agentic RAG at Rocket Mortgage

Rocket Mortgage unveiled Rocket Analytics, an agentic Retrieval‑Augmented Generation (RAG) platform that translates natural‑language questions into SQL, runs the queries, and returns instant, visualizable results. The system builds a metadata‑only knowledge base using Amazon Titan embeddings stored in a FAISS vector store, then applies hybrid semantic‑keyword retrieval and Cohere’s re‑ranker to select relevant tables before prompting a large language model. Caching of semantics and prompts reduces latency and cost, while an orchestrator agent framework paves the way for cross‑domain insights. The tool cuts analysis time from days to seconds, democratizing data access across the enterprise.