Skip to content

Vanna

Vanna

Open-source AI SQL assistant that learns your schema and writes queries.

Official Site
01

Overview

Vanna is an AI data-analysis tool that lets you query, transform, and visualize data using natural language. It translates questions into SQL or dataframe operations, explains results, generates charts, and handles the back-and-forth of clarifying ambiguous requestsโ€”making data accessible to analysts and non-technical users alike.

02

Getting Started

Get started with Vanna by connecting a data source (database, warehouse, or CSV/Parquet files). Ask a question in natural language, review the generated query and result, then refine. Use the tool's visualization features to chart results and its explanation feature to understand each step of the generated analysis.

bash
# Install
pip install vanna

# Connect and ask (Python example)
from vanna import Vanna
ai = Vanna(db_url="postgresql://...")
result = ai.ask("What's the monthly revenue trend for 2025, grouped by region?")
print(result.sql)    # the generated query
print(result.data)   # the result rows
result.chart()       # a visualization
03

Use Cases

Use cases for Vanna: (1) ad-hoc analytics without writing SQL by hand; (2) generating and explaining complex joins and window functions; (3) building dashboards from natural-language specs; (4) data cleaning and schema inference for messy CSVs; (5) empowering non-technical stakeholders to self-serve answers.

04

Tips

Tips for Vanna: always inspect the generated SQL before trusting the numberโ€”AI can misread schema intent. Grant the tool read-only access with row limits to prevent expensive queries. Provide schema descriptions and sample rows as context for better queries. Validate surprising results with a second, independent query.

Ready to try Vanna?

Visit the official site for the latest version and full documentation.

Visit Vanna