v2.0.0

Wilfred/difftasticv2.0.0Nov 19, 2025by zainhoda

AI Summary

This is a major version representing a complete architectural rewrite of Vanna, focusing on agentic models, enterprise security, and a modern web interface.

Key Highlights

  • User-Aware Agent Framework with identity flows and row-level security
  • Modern Web Interface featuring the vanna-chat component and streaming responses
  • Production-Ready Architecture with FastAPI/Flask servers and observability
  • Rich Streaming Components including interactive data tables and Plotly visualizations

Breaking Changes

  • Complete architectural rewrite requiring migration from 0.x (legacy adapter provided for quick migration)

New Features

  • User context flows through every layer (tools, SQL, audit logs)
  • Row-level and group-based access control
  • Audit logging for compliance
  • Pre-built vanna-chat component for React, Vue, or HTML
  • Streaming responses via SSE
  • Framework-agnostic auth support (cookies, JWTs, OAuth)
  • Modular tool system with lifecycle hooks
  • Support for multiple databases (PostgreSQL, MySQL, Snowflake, etc.)
  • Support for multiple LLMs (OpenAI, Anthropic, Ollama, etc.)

Full Release Notes

# 🎉 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). 

https://github.com/user-attachments/assets/eaed3767-041a-4c81-9023-f3429a58c607

## 🚀 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 <vanna-chat> 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:

1. Quick Migration (Legacy Adapter) — Wrap your existing Vanna 0.x instance and get the new UI immediately
2. 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)