Releases: vanna-ai/vanna
v2.0.1
v2.0.0
🎉 Vanna 2.0.0 - Complete Rewrite for Agentic Models
Turn Questions into Data Insights — Natural language → SQL → Visualization → Answers, now with enterprise security and user-aware permissions. This version has much better support for agentic models (Claude 4.5, GPT-5).
1118.mp4
🚀 What's New
User-Aware Agent Framework
- Identity flows through every layer — User context automatically available in tools, SQL queries, and audit logs
- Row-level security — Queries filtered based on user permissions
- Group-based access control — Fine-grained tool access by user groups
- Audit logging — Track every query per user for compliance
Modern Web Interface
- Pre-built component — Drop into any webpage (React, Vue, or HTML)
- Streaming responses — Real-time tables, charts, and progress updates via SSE
- Framework-agnostic — Works with your existing auth (cookies, JWTs, OAuth)
- Customizable themes — Light/dark modes, responsive design
Production-Ready Architecture
- FastAPI/Flask servers included — Production backends out of the box
- Modular tool system — Extend with custom Tool classes
- Lifecycle hooks — Quota checking, logging, content filtering
- Observability built-in — Tracing and metrics integration
- LLM agnostic — OpenAI, Anthropic, Ollama, Azure, Gemini, Bedrock, Mistral, and more
Rich Streaming Components
Instead of plain text responses, get:
- Interactive data tables
- Plotly visualizations
- SQL code blocks (admin-only by default)
- Natural language summaries
- Progress indicators
📦 Database & LLM Support
Databases: PostgreSQL, MySQL, Snowflake, BigQuery, Redshift, SQLite, Oracle, SQL Server, DuckDB, ClickHouse, Hive, Presto, and more
LLMs: OpenAI, Anthropic Claude, Google Gemini, Azure OpenAI, Ollama, and others
🔄 Migration from 0.x
Vanna 2.0 is a complete architectural rewrite. We provide two migration paths:
- Quick Migration (Legacy Adapter) — Wrap your existing Vanna 0.x instance and get the new UI immediately
- Full Migration — Rewrite to the new Agent-based architecture for full feature access
See the https://vanna.ai/docs/migration for additional instructions.
📚 Resources
- https://vanna.ai/docs — Complete guides and API reference
- https://vanna.ai/docs/quick-start — Get started in minutes
- https://github.com/vanna-ai/vanna/discussions — Ask questions, share ideas
- Demo Video — See Vanna 2.0 in action (above)
v2.0.0rc1
Vanna 2.0.0 is a complete architectural reimagining: from a simple SQL generation library to a production-ready, user-aware agent framework for data analytics.
🎯 What's New
User-Aware by Design
- Identity and permissions flow through every layer
- Group-based access control on tools
- Row-level security support
- Per-user audit logs and rate limiting
Drop-in Web Component
<vanna-chat api-endpoint="/api/vanna/v2/chat_sse"></vanna-chat>- Works with your existing auth (cookies/JWTs)
- Streaming tables, charts, and code blocks
- Framework-agnostic
Modular Tool System
- Tools are first-class citizens with schemas and permissions
- Built-in tools: SQL execution, data visualization, RAG memory
- Easy to create custom tools
Rich Streaming UI
DataFrameComponent,ChartComponent,StatusCardComponent- Progressive rendering via Server-Sent Events
- Not just text responses
Production-Ready Servers
- FastAPI and Flask servers included
- SSE streaming, health checks, CORS support
- Add to existing apps with a few lines of code
Enterprise Features
- Audit logging
- Lifecycle hooks (rate limiting, content filtering)
- LLM middlewares (caching, retry logic)
- Context enrichers
- Built-in evaluation framework
Agent Memory (RAG)
- Store and retrieve context from vector stores
- Supports Pinecone, Qdrant, Milvus, Weaviate, and more
v0.7.9
v0.7.8
v0.7.7
v0.7.6
What's Changed
- Prompt Content not print unicode char by @wwulfric in #689
- add documentation on list of supported LLMs, VectorStores, Databases by @gongwork in #691
- Introducing Vanna Guru on Gurubase.io by @kursataktas in #707
- fixed a typo in connect_to_oracle doc by @prady00 in #706
- chore: update questions.json by @eltociear in #693
- 【feat】add database engine and table name to support table ddl update by @zyclove in #463
- Revert "【feat】add database engine and table name to support table ddl update" by @zainhoda in #770
- Support oracle database as VectorStore - Fix:#764 by @engchina in #765
- Support the input of a large DataFrame when generating follow-up questions by @Flyfoxs in #761
- add deepseek to support by @hfyydd in #758
- feat: support pgvecto.rs by @wwulfric in #748
- Revert "feat: support pgvecto.rs" by @zainhoda in #771
- Add new OpenSearch Vector Store with embeddings support by @asaintsever in #762
- Authentication via VertexAI by @BassCoder2808 in #728
- Update base.py by @brochure in #692
New Contributors
- @wwulfric made their first contribution in #689
- @gongwork made their first contribution in #691
- @kursataktas made their first contribution in #707
- @prady00 made their first contribution in #706
- @engchina made their first contribution in #765
- @Flyfoxs made their first contribution in #761
- @hfyydd made their first contribution in #758
- @asaintsever made their first contribution in #762
- @BassCoder2808 made their first contribution in #728
- @brochure made their first contribution in #692
Full Changelog: v0.7.5...v0.7.6
v0.7.5
v0.7.4
What's Changed
- Add temperature support to vLLM by @AmitSinghShorthillsAI in #645
- Added missing import tests; added missing modules to pyproject by @andreped in #653
- Added pgvector support by @andreped in #647
- fix: some tests due to missing modules by @euxx in #678
- Update Gemini version and SDK by @gquental in #672
- Add support to embeddings from VertexAI models by @gquental in #673
- Fixed typo in ai-sql-accuracy-2023-08-17.md by @jannesDoege in #663
- Pgvector fixes by @edlouth in #660
New Contributors
- @AmitSinghShorthillsAI made their first contribution in #645
- @euxx made their first contribution in #678
- @gquental made their first contribution in #672
- @jannesDoege made their first contribution in #663
- @edlouth made their first contribution in #660
Full Changelog: v0.7.3...v0.7.4