Vanna is an Open-Source Python-based AI SQL agent trained on your schema that writes complex SQL in seconds
TLDR: It all has to do with the training data you give it, which is whathelps with.
Get the latest on Vanna & AI generated SQL
Vanna’s capabilities are tied to the training data you give it. More training data means better accuracy for large and complex datasets.
Your database contents are never sent to Vanna’s servers. We only see the bare minimum - schemas & queries.
You train a custom model specific to your database and your schema. Nobody else can use your model or view your model’s training data unless you choose to add members to your model or make it public. We use a combination of third-party foundational models (OpenAI, Google) and our own LLM.
As you use Vanna more, your model continuously improves as we augment your training data.
We have out-of-the-box support Snowflake, BigQuery, Postgres. You can easily make a connector for any database.
If you’re a data provider you can publish your models for anyone to use. As part of our roadmap, we are in the process of pre-training models for common datasets (Google Ads, Facebook ads, etc).
Start in a Jupyter Notebook. Expose to business users via Slackbot, web app, Streamlit app, or Excel plugin. Even integrate in your web app for customers.
There's lot of functionality to exploreRead the Documentation
Bring your own LLM
Easiest to use
Best for companies