Vanna: Your AI Business Intelligence Assistant
Open siteIntroduction
Vanna is an AI-powered Python package that generates SQL for databases, acting as a business intelligence assistant.
Vanna: Your AI Business Intelligence Assistant Product Information
Vanna.AI - Personalized AI SQL Agent is an open and enterprise-friendly AI-powered platform designed to turn natural language questions into actionable SQL queries. It enables fast retrieval, analysis, and storytelling from your database by asking questions rather than writing SQL, with multiple deployment options to fit various governance and security requirements.
Overview
Vanna.AI provides a spectrum of offerings: Cloud (managed), Self-Hosted, Embedded API access, and an Open-Source foundation. It emphasizes accurate, data-grounded responses trained on your specific data, strong governance, and flexible deployment to satisfy enterprise needs. The platform supports a wide range of databases (e.g., Snowflake, BigQuery, PostgreSQL) and can be integrated into diverse frontends (Jupyter, Slackbot, web apps, Streamlit, etc.).
How It Works
- Connect to your databases and grant access.
- Ask questions in natural language.
- Vanna translates questions into high-quality SQL, queries your data, and returns insights.
- Customize training data and governance to improve accuracy and compliance.
The system is designed to minimize manual SQL writing, accelerate insight generation, and keep data security at the forefront (metadata is used for model improvements, and raw contents aren’t sent to LLMs unless explicitly enabled).
Use Cases
- Rapidly generate insights from complex data estates without deep SQL expertise.
- Build decision-support tools inside apps, Slack, or Jupyter notebooks.
- Deploy across on-premises or cloud environments with configurable data sovereignty.
Features
- Open-source core with configurable deployments (Cloud, Self-Hosted, OSS)
- Text-to-SQL capabilities across multiple databases (Snowflake, BigQuery, Postgres, etc.)
- Enterprise-grade governance, team permissions, and security controls
- Flexible frontends and integrations (Jupyter, Slackbot, web apps, Streamlit, etc.)
- Zero-setup, instant connectivity in Cloud offerings; on-premises options for strict compliance
- Metadata-based learning and continuous improvement without leaking raw data
- Compatibility with various LLMs and vector databases; easy connectors for custom environments
How to Get Started
- Choose deployment: Vanna Cloud (starter for free), Self-Hosted, or Embedded API
- Connect your databases and define governance policies
- Start asking questions and iterate to improve SQL accuracy with targeted training data
Safety and Data Privacy
- Data remains on your environment where possible; raw data is not sent to LLMs unless you enable features requiring it
- Emphasis on enterprise governance and compliance
Core Offerings
- Vanna Cloud: Enterprise-ready data retrieval and analysis with zero setup
- Vanna Self-Hosted: In-house deployment inside your VPC with preferred cloud provider compatibility
- Vanna Embedded: API access to bring AI SQL capabilities into apps and agents
- Vanna OSS: Open-source foundation for maximum flexibility and customization