# Vanna AI

> An open-source, user-aware AI SQL agent framework that connects LLMs to your database for natural language querying across multiple databases and LLM providers.

Vanna AI is an open-source, multi-database SQL agent framework that lets users query company data systems using natural language. It connects any LLM provider (OpenAI, Anthropic, Gemini, Ollama) to any database (PostgreSQL, MySQL, Snowflake, BigQuery, SQLite, and more), generating accurate SQL from plain English questions. Vanna learns from successful interactions via Tool Memory, improving over time without manual retraining. Optional hosted admin features add access control, observability, audit logs, and more for production deployments.

- **Multi-LLM Support:** *Works with Anthropic, OpenAI, Gemini, and Ollama — swap providers without rewriting code.*
- **Multi-Database Compatibility:** *Connects to PostgreSQL, MySQL, Snowflake, BigQuery, SQLite, and many more databases.*
- **Tool Memory:** *Saves successful SQL queries to a vector database so the agent learns your schema and business logic over time.*
- **Access Control:** *Per-user permissions flow through the entire system, ensuring users only see data they're authorized to access.*
- **Observability:** *Real-time metrics and distributed tracing for monitoring agent behavior in production.*
- **Audit Logs:** *Comprehensive activity tracking for compliance and governance requirements.*
- **Self-Host or Cloud:** *Run Vanna fully self-hosted via `pip install vanna`, or use the managed Vanna Cloud with hosted admin features.*
- **Open Source Core:** *The core framework is MIT-licensed on GitHub with 23k+ stars, with no vendor lock-in.*
- **Multi-Turn Conversations:** *Supports follow-up questions and context-aware dialogue for iterative data exploration.*
- **Quick Start:** *Get running in 1 minute with a sample Chinook SQLite database in Colab, or connect your own database in ~30 minutes.*

## Features
- Natural language to SQL generation
- Multi-LLM provider support (OpenAI, Anthropic, Gemini, Ollama)
- Multi-database support (PostgreSQL, MySQL, Snowflake, BigQuery, SQLite)
- Tool Memory with vector database for continuous learning
- Per-user access control
- Real-time observability and distributed tracing
- Audit logs and compliance tracking
- Multi-turn conversational queries
- Self-hosting support
- Managed cloud deployment
- On-premises enterprise deployment
- SAML SSO (Enterprise)
- Admin API for user provisioning
- Chart generation
- Copy-paste configuration code generator

## Integrations
OpenAI, Anthropic, Google Gemini, Ollama, PostgreSQL, MySQL, Snowflake, BigQuery, SQLite, Azure SQL Database, Microsoft Azure

## Platforms
LINUX, WEB, API, DEVELOPER_SDK, CLI

## Pricing
Open Source, Free tier available

## Links
- Website: https://vanna.ai
- Documentation: https://vanna.ai/docs
- Repository: https://github.com/vanna-ai/vanna
- EveryDev.ai: https://www.everydev.ai/tools/vanna-ai