All projects
// Case study 02 · Data & Developer Tools
Vanna AI
Chat with your SQL database in plain English.
Open-source, multi-database SQL agent that lets anyone in an organisation query systems of record in natural language, with cloud or self-hosted options.
Core AI productRAG / Text-to-SQLActive
https://vanna.ai/
Open source
License
4+
LLM providers
Microsoft
Featured by
The problem
Insights sit behind SQL skills. Business users wait on analysts for every question about their own data.
The solution
A RAG framework trained on schema, documentation and past queries that turns natural-language questions into correct SQL, then returns results and charts.
How AI is used
Retrieval-Augmented Generation over schema and docs feeds an LLM (OpenAI, Anthropic, Gemini or Ollama) that writes SQL; multi-turn context and access control keep it safe.
// AI pipeline · live
How data flows through the model
01
Natural-language question
02
Retrieve schema & docs
03
LLM writes SQL
04
Run on database
05
Table + chart answer
// AI capability profile
// Key features
- Open source, pip install
- Works with any LLM and database
- Multi-turn conversations
- Hosted admin & access control
// Tech stack
PythonRAGVector storeOpenAI / Anthropic / Gemini / OllamaPostgreSQL · Snowflake · BigQuery · MySQL
Details verified against the live website in November 2026.