Skip to index

Vanna

Vanna AI

Open source★ #108 in AI Platforms

Product status: Status not recorded

No lifecycle review is recorded for this listing. Its inclusion in the directory does not confirm current availability; check the vendor before relying on it.

No status check date recorded

Text-to-SQL that learns your schema: ask questions in English, get queries trained on your DDL. No lifecycle review is recorded for this listing. Its inclusion in the directory does not confirm current availability; check the vendor before relying on it.

Product preview

vanna.ai
Preview of Vanna

Overview

Vanna is a framework for letting people query a database in ordinary language: it generates the SQL, runs it, and returns an answer, and the current site presents version 2.0 as an SQL agent that is open source, works across several databases, holds a conversation over several turns and enforces access control. Providers offered for the language model include Anthropic, OpenAI, Gemini and a local option, and the database list covers the common relational engines as well as analytics warehouses; installing it is a single package command. The vendor separately sells a hosted tier and an enterprise tier, and describes optional hosted features such as access control, observability, agent memory, secure file storage, audit logs and data retention.

There is a discrepancy worth knowing before you choose it. The project's original repository carries the highest profile in this category — the vendor's own documentation still cites more than twenty thousand stars — and that repository is archived, with its last push in February 2026. A separate migration guide for moving off the older version is published alongside the new one, and the vendor's own explanation of the rewrite says the original was built for a single user and one model generation, and that multi-user isolation and production plumbing had to be built from scratch by every customer. So version 2.0 suits a team that needs a query agent with user identity and permissions designed in from the start. It suits less well anyone who wants a small library that bolts onto an existing analytics stack, and it suits less well anyone reading a tutorial written against the archived version.

Not verified: no database was connected and no query was generated, so the accuracy of the SQL and the permission behaviour were not tested. The star count, the vendor's account of what enterprise customers asked for, and the feature lists above come from the vendor's own site and documentation; the pricing page read on 2026-10-12 lists Explorer at $50 a month and Team at $500 a month, with Enterprise priced custom, so those tiers are known; the linked enterprise page returns a 404 rather than a readable page. The archived repository was read only through the hosting service's interface, which reported the MIT licence and about 23,821 stars; the newer repository the site points to returned nothing when queried, so where version 2.0's source lives was not established.

Sources

The factual claims in this review were read from the pages below. Each date is when an editor last opened the source, not when the product changed.

Pros / Cons

Pros

  • Accuracy compounds with your examples
  • Open source, bring any LLM
  • Works on your private schema safely
  • Sqlite/Postgres/BigQuery friendly

Cons

  • Needs training data to shine
  • Complex analytics SQL still trips it
  • Visualization is bring-your-own

Who it's for

01

Self-serve analytics for non-analysts

02

Text-to-SQL copilots in products

03

Reducing ad-hoc query tickets

04

Learning a schema through questions

Bottom line

A language-to-SQL agent rebuilt around user identity and permissions — but the famous repository is archived, so make sure you are following the new version's documentation, not the old one's.

Key Features

Schema-aware SQL generation
Trains on your DDL and docs
Pluggable LLM and vector stores
Open-source Python library
Freemium

Tags

Text-to-SQLOpen sourceAnalytics

Frequently asked questions

Is Vanna currently available?

No lifecycle review is recorded for this listing. Its inclusion in the directory does not confirm current availability; check the vendor before relying on it.

What is Vanna?

Vanna is a AI Platforms tool developed by Vanna AI. It was introduced in 2023, and its developer is headquartered in Remote. Text-to-SQL that learns your schema: ask questions in English, get queries trained on your DDL.

Is Vanna free?

Vanna uses a freemium model: a free tier is available, and paid plans unlock more usage and advanced features.

Is Vanna open source?

Yes — Vanna is open source. The source code is publicly available at https://github.com/vanna-ai/vanna.

What are the best alternatives to Vanna?

Notable AI Platforms alternatives include Hugging Face, Replicate, Ollama. Browse all 138 tools in our AI Platforms category for a full overview.

Was this listing useful?

Visit official website →View source

Basic Info

Pricing
Freemium
Editorial score
★ 4.4 / 5 How we score
Platforms
LibraryPython
Launched
2023
Headquarters
Remote
Last verified
Not recorded