Cette page est affichée en anglais. Une traduction française est en cours.
ScriptsMar 31, 2026·2 min de lecture

Vanna — Chat with Your SQL Database Using AI

AI-powered text-to-SQL. Ask questions in plain English, get accurate SQL queries and visualizations. Learns your schema. Works with any database. 23K+ stars.

Introduction

Vanna is an AI-powered text-to-SQL tool. Ask questions about your database in plain English and get accurate SQL queries, results, and auto-generated visualizations. It learns your specific schema, naming conventions, and business logic through training — getting more accurate over time. Works with PostgreSQL, MySQL, SQLite, BigQuery, Snowflake, and more. 23,000+ GitHub stars, MIT licensed.

Best for: Data analysts and developers who want natural language access to databases Works with: PostgreSQL, MySQL, SQLite, BigQuery, Snowflake, DuckDB, any SQL database


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.


🙏

Source et remerciements

Created by Vanna AI. Licensed under MIT. vanna-ai/vanna — 23,000+ GitHub stars

Discussion

Connectez-vous pour rejoindre la discussion.
Aucun commentaire pour l'instant. Soyez le premier à partager votre avis.

Actifs similaires