Member-only story
Hands-On WrenAI Review: Text-to-SQL Powered by RAG
Deep dive into customization, performance, and practical insights for seamless SQL generation
Not a member? You can still check out this article through here.
WrenAI is a text to sql solution that I’ve been following for a while. Recently, I have some time to try it out, so let me share my experience.
First of all, according to the installation guide provided by the official document, we can generally deploy WrenAI to the local machine. As for the integration with local Ollama, there are some sample configuration files that can be used.
However, there are still some details to be adjusted that are not mentioned in the document. For example, if we use the ollama/nomic-embed-text mentioned in the document as the embedder, then we need to change the embedding_model_dim of the configuration file from 3072 to 768, which is a detail that can be easily overlooked.
Just provide the appropriate settings and WrenAI will work fine.
By the way, I am using MySQL and the official MySQL test dataset.
WrenAI Advantage
In addition to schema-based chat Q&A, WrenAI has another awesome feature.
