Vanna AI
Open-source SQL agent framework that lets users query company databases in natural language.
Vanna AI is an open-source framework for building SQL agents that let people ask questions of company databases in plain language. Vanna AI works with LLM providers such as Anthropic, OpenAI, Gemini and Ollama and with databases including PostgreSQL, MySQL, Snowflake, BigQuery and SQLite, and can be self-hosted or run on Vanna Cloud.
Best for Data and engineering teams that want to give non-SQL users governed, conversational access to databases using their own choice of model and infrastructure.
- Platforms
- API
- Pricing model
- Subscription
- API
- Yes
- Made by
- Vanna AI
- Added
Last verified: . Information taken from vanna.ai.
What is Vanna AI?
Vanna AI is a Python framework, installable with pip, for creating agents that turn natural language questions into SQL and return answers from a database. Version 2.0 is described as user-aware: each user has their own access controls that carry through the whole system, and the agent supports multi-turn conversations. A tool memory stores successful interactions so that results improve with use. The framework is not tied to one vendor; developers choose a language model provider (Anthropic, OpenAI, Gemini or Ollama) and a data source such as SQLite, PostgreSQL, MySQL, Snowflake or BigQuery, and the site generates configuration code for the chosen stack. Optional hosted admin features add access control, observability with metrics and tracing, a hosted vector database for agent memory, file storage, audit logs and data retention. Teams can self-host the open-source core or use the managed Vanna Cloud, with an Enterprise option for on-premises deployment.
Key Features
Natural Language to SQL
Lets an agent write and run SQL queries, and generate charts, in response to a plain-language question.
User-Scoped Permissions
Applies each user's access rules throughout the system so people only see data they are allowed to.
Tool Memory
Records successful query interactions and reuses them to improve later answers.
Choice of LLM and Database
Supports several model providers and databases, with copy-and-paste configuration for the selected pair.
Hosted Admin Features
Adds observability, audit logs, agent memory storage and data retention as optional managed services.
Flexible Deployment
Runs self-hosted from the open-source package, on Vanna Cloud, or on-premises under an Enterprise agreement.
Screenshots
Use Cases
- Self-Service Analytics
- Let colleagues without SQL skills ask data questions directly.
- Embedded Data Chat
- Add a question-answering agent to an internal tool or customer-facing product.
- Analyst Productivity
- Draft SQL from a description and spend the saved time on interpretation.
- Governed Data Access
- Give different teams the same agent while enforcing per-user visibility rules.
- Evaluation With Sample Data
- Try the framework against a dummy database in a Colab notebook before connecting real systems.
Things to know
- Daily question limits
- Paid tiers cap questions per day (20 on Explorer, 300 on Team); requests beyond the cap are rate-limited until the 24-hour reset.
- Annual discount
- The pricing FAQ states that annual subscriptions receive a 20% discount.
- Bring your own stack
- You supply the LLM provider and the database the agent connects to.
FAQs
What is Vanna AI?
Vanna AI is an open-source framework for building AI agents that query databases with SQL generated from natural language.
Is Vanna AI open source?
Yes. Vanna AI's core framework is open source and can be installed with pip and self-hosted.
Which databases does Vanna AI support?
Vanna AI lists SQLite, PostgreSQL, MySQL, Snowflake and BigQuery, with further databases covered in its documentation.
Which language models work with Vanna AI?
Vanna AI works with Anthropic, OpenAI, Gemini and Ollama as LLM providers.
Does Vanna AI have an API?
Yes. The Vanna AI pricing page lists API availability from the Explorer plan, and Enterprise adds an admin API for user provisioning.
Can I move from self-hosting to Vanna Cloud?
Yes. Vanna AI says all tiers share the same core framework, so you can start self-hosted and upgrade without rewriting code.
How much does Vanna AI cost?
Vanna AI offers Explorer, Team and Enterprise plans with daily question limits. See the official pricing page for current prices.
Who it's for
- Data engineers
- Developers
- Analysts
- Data teams
- Enterprises
Comments
No comments yet. If you have used Vanna AI, tell other readers how it went.
Alternatives to Vanna AI
| Tool | Free plan | Starting price | API |
|---|---|---|---|
 AirbyteOpen-source data movement platform that replicates data from 700+ sources and exposes it to analytics and AI agents. |
— | — | Yes |
 OpenCodeOpen source AI coding agent for the terminal, desktop and IDE that works with models from many providers. |
Yes | — | — |
 OrcaOpen-source agent development environment that runs many CLI coding agents in parallel git worktrees. |
Yes | — | — |
 PostHogProduct data platform combining analytics, session replay, feature flags, error tracking and a warehouse, with AI on top. |
Yes | — | Yes |
 skills.shDirectory and leaderboard of installable skills for AI coding agents, added with one CLI command. |
— | — | Yes |
Listed in the same categories as Vanna AI. A starting price appears only where we checked it on the maker’s pricing page; a dash means not checked or not published. All Data Analysis & Analytics tools