What is 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.

Is Vanna — Chat with Your SQL Database Using AI free to use?

Yes. Vanna — Chat with Your SQL Database Using AI is freely available on TokRepo. Check the Source & Thanks section on the asset page for the specific open-source license.

How do I install Vanna — Chat with Your SQL Database Using AI?

Visit the asset page on TokRepo and click "Copy for agent" to get the installation instructions. Most assets can be installed with a single command.

Vanna — Chat with Your SQL Database Using AI

import vanna from vanna.openai import OpenAI_Chat from vanna.chromadb import ChromaDB_VectorStore class MyVanna(ChromaDB_VectorStore, OpenAI_Chat): def __init__(self, config=None): ChromaDB_VectorStore.__init__(self, config=config) OpenAI_Chat.__init__(self, config=config) vn = MyVanna(config={'api_key': 'sk-...', 'model': 'gpt-4o'}) vn.connect_to_postgres(host='localhost', dbname='mydb', user='postgres', password='pass') # Train on your schema vn.train(ddl="CREATE TABLE users (id INT, name TEXT, email TEXT, created_at TIMESTAMP)") # Ask questions sql = vn.generate_sql("How many users signed up this month?") print(sql) # SELECT COUNT(*) FROM users WHERE created_at >= '2026-03-01' df = vn.run_sql(sql) vn.generate_plotly(question="...", sql=sql, df=df) # Auto-visualization

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.

Vanna — Chat with Your SQL Database Using AI

先拿来用，再决定要不要深挖

Key Features

Agentic RAG for SQL

Schema Learning

Auto-Visualization

Web UI

Multi-Database

FAQ

来源与感谢

相关资产

RAGFlow — Deep Document Understanding RAG Engine

Gradio — Build ML Demos & AI Apps in Python

ScrapeGraphAI — AI-Powered Web Scraping