Vanna — Chat with Your SQL Database Using AI

Key Features

Agentic RAG for SQL

Uses retrieval-augmented generation specifically tuned for SQL. Retrieves relevant schema, past queries, and documentation before generating SQL.

Schema Learning

Train Vanna on your DDL, sample queries, and documentation. It learns your tables, relationships, and naming patterns.

Auto-Visualization

Generates Plotly charts automatically from query results — bar charts, line graphs, pie charts, and more.

Web UI

Built-in Flask web interface for non-technical users to query databases:

from vanna.flask import VannaFlaskApp
app = VannaFlaskApp(vn)
app.run()

Multi-Database

Connect to PostgreSQL, MySQL, SQLite, BigQuery, Snowflake, DuckDB, MSSQL, and any ODBC database.

FAQ

Q: What is Vanna? A: An AI text-to-SQL tool that converts natural language questions into accurate SQL queries with auto-visualization. Learns your schema over time. 23K+ stars.

Q: How accurate is the SQL generation? A: Accuracy improves as you train Vanna on your schema and example queries. With good training data, 85-95% accuracy on typical business queries.