Vanna

The most accurateSQL Agent Open Source • Multi-database • Multi-turn • Access controlled Let your users query all your company's systems of record. Use Cloud Self Host Dummy Database in Colab 1 min • No sign in pip install vanna 30 min " Why use AI to chat with your database in the first place? To start, it allows you to spend less time writing SQL and more time generating insights on your data. With Vanna, you can empower users across your organization—regardless of their SQL expertise—to interact with your database using natural language, making data more accessible to everyone. Brian Spindolini Senior Product Manager, Azure SQL Database Read more on the Microsoft blog Choose Your Stack Vanna works with any LLM provider and database. Select your options to get started with the open source framework. 🧠 LLM Provider 🤖 Anthropic✨ OpenAI💎 Gemini🦙 Ollama 🗄️ Database 📄 SQLite🐘 PostgreSQL🐬 MySQL❄️ Snowflake📊 BigQuery 📚 Other Databases - See Docs → ☁️ Admin Features Vanna provides optional hosted admin features ✓ Access Control: Control who sees what ✓ Observability: Real-time metrics & tracing ✓ Agent Memory: Hosted vector DB ✓ File System: Secure file storage ✓ Audit Logs: Activity tracking ✓ Data Retention: Long-term storage View Pricing → 🧠 LLM Provider Choose your language model 🤖 Anthropic✨ OpenAI💎 Gemini🦙 Ollama 🗄️ Database Choose your data source 📄 SQLite🐘 PostgreSQL🐬 MySQL❄️ Snowflake📊 BigQuery 📚 Other → ☁️ Admin Features Vanna provides optional hosted admin features ✓ Access Control: Control who sees what ✓ Observability: Real-time metrics & distributed tracing ✓ Agent Memory: Hosted vector database for learning ✓ File System: Secure file storage and retrieval ✓ Audit Logs: Comprehensive activity tracking & compliance ✓ Data Retention: Long-term storage for conversations & logs View Pricing → Use Vanna OSS with These Options → Get copy-paste ready configuration code --- Simple, transparent pricing Choose the plan that fits your team. Most Popular Explorer For small teams of 2-3 people $50 per month Everything you need to get started: ✓ 20 questions/day✓ Admin features included in either Vanna OSS or Vanna Cloud✓ API available✓ Same day email support Team For small companies or large teams $500 per month Everything in Explorer, plus: ✓ 300 questions/day✓ Setup support✓ Same day live support Enterprise For large companies Custom contact sales Unlimited scale ✓ Unlimited questions✓ On-prem deployment support✓ SAML SSO✓ Admin API for user provisioning & management✓ Advanced integrations✓ Custom work Use Cloud Self Host Dummy Database in Colab 1 min • No sign in pip install vanna 30 min Frequently Asked Questions What happens if I exceed my daily limits? Daily throughput limits reset every 24 hours. If you exceed your limit, requests will be rate-limited until the next reset. You can upgrade to a higher tier at any time for immediate access to higher limits. Can I start with the open source version and upgrade later? Yes! All tiers use the same core framework. You can start self-hosting with the open source version, then seamlessly upgrade to our managed cloud platform or enterprise deployment without rewriting your code. How does Enterprise pricing work? Enterprise pricing is custom based on your deployment needs (on-prem, VPC, or private cloud), desired SLAs, and support requirements. Contact our sales team to discuss your specific requirements. Do you offer annual discounts? Yes! Annual subscriptions receive a 20% discount. Contact sales or select annual billing during checkout. Ready to get started? Get started with Vanna today. Upgrade anytime as your needs grow. Use Cloud Self Host Dummy Database in Colab 1 min • No sign in pip install vanna 30 min --- What is Vanna 2.0? Vanna 2.0 is a user-aware AI agent framework that connects LLMs to your database. The Core Concept At its heart, Vanna is simple: Connect tools to an LLM - Give your AI agent the ability to run SQL queries, generate charts, or any custom functionality Remember how to use them - Tool Memory learns from successful interactions, getting better over time Enforce permissions - Every user has specific access controls that flow through the entire system How It Gets Better Over Time Every successful interaction is saved to Tool Memory. When a user asks a similar question: The agent searches past SQL queries and tool usage patterns It adapts successful examples to the current context Your agent learns your database schema, business logic, and query patterns without manual training Novel Question (Left Path) - Deeper investigation, saves to memory Similar Question (Right Path) - Fast adaptation from memory Novel QuestionWriteSimilar QuestionRead User Question Search Tool Memory No Match Found Deep Investigation (Schema analysis, examples) Generate New SQL Execute & Verify Save to Tool Memory ✓ 🗄️ Vector Database (Tool Memory) Similar Pattern Found ✓ Adapt Existing Query Execute Variant Return Result Return Result Press enter or space to select a node. You can then use the arrow keys to move the node around. Press delete to remove it and escape to cancel. Press enter or space to select an edge. You can then press delete to remove it or escape to cancel. 🚀 Getting Started Quickstart with Sample Data Use the sample Chinook SQLite database Quickstart with Your Own Data Connect to your database in Python Migrate from 0.x Moving from Vanna 0.x to v2 💬 Community and Support GitHub Repository Issues – Report bugs or request features Discussions – Ask questions and share examples --- Quick Start Try Vanna in 30 seconds with sample data on Google Colab. Open Sample Notebook View on GitHub The notebook includes the Chinook sample database (a music store) where you can try natural language queries like: “What are the top 5 selling albums?” “Show me total sales by country” “Which artists have the most tracks?” Ready for Your Own Data? Configure Vanna for Your Database Choose your LLM provider and database to get copy-paste ready code.