What is Vanna?

Vanna 2.0 is an open‑source AI framework that lets users query any relational or cloud data warehouse—such as SQLite, PostgreSQL, MySQL, Snowflake, or BigQuery—using natural language. The system translates spoken or typed questions into SQL and returns results, eliminating the need to manually write queries.

It supports multi‑turn conversations, allowing users to refine requests or ask follow‑up questions within the same session. Optional admin features include access control, real‑time observability, a hosted vector database for contextual memory, secure file storage, audit logs, and long‑term data retention.

Vanna can be deployed locally or in the cloud, and it works with popular LLM providers including Anthropic, OpenAI, Gemini, and Ollama. This setup is suitable for data analysts, business users, and developers who require quick, accurate insights from complex databases without deep SQL expertise.

Vanna on the web:

Vanna details

Jurisdiction: New York, United States
Built for: Businesses and teams
Data residency: United States

Vanna tech specs

Works with: OpenAI / GPT Anthropic / Claude Google / Gemini
Cloud: Azure

Vanna pricing

Subscription

Explorer $50/mo

Team $500/mo

Enterprise Contact us

$50/mo is pricier than most for SQL median $12/mo

Most SQL tools start between $8 and $39 a month.

Verify on the official pricing page.

View plans

Vanna's key features

Multi-database compatibility
Multi-turn natural queries
Access control for users
Real-time observability metrics
Hosted vector database memory
Secure file storage
Audit logs & retention

Vanna use cases

Generate real‑time sales dashboards by simply asking, 'Show me last quarter's revenue by product line,' and let Vanna 2.0 translate it into an efficient SQL query without any coding or complex visual tools.
Empower product managers to explore user behavior through conversational data queries—e.g., 'What was the churn rate for new users in August?'—with Vanna 2.0 handling multi‑turn refinement and translating the natural language into precise Snowflake or BigQuery SQL.
Provide frontline support teams with instant, secure access to operational metrics via voice or text—such as asking, 'Which tickets were opened for priority 1 in the last 48 hours?'—while Vanna 2.0 manages permissions and generates the appropriate PostgreSQL or Snowflake queries.