Vanna

Vanna is presented as an AI-powered SQL generation framework and SQL agent. The page states it works with any LLM provider and database, and lets users choose an LLM provider (Anthropic, OpenAI, Gemini, Ollama) and a database (SQLite, PostgreSQL, MySQL, Snowflake, BigQuery, or others). It is positioned to let users across an organization, regardless of SQL expertise, interact with databases in natural language. Optional hosted admin features are offered, including access control, observability, agent memory via a hosted vector database, secure file system, audit logs, and data retention. The page mentions installation via pip install vanna and a dummy database option in Colab. Products listed include Vanna Core, Vanna Cloud, and Enterprise, with options to use Cloud, Self Host, or the open source version.

Key features

• Open source framework
• Multi-database support
• Multi-turn conversations
• Access controlled
• Natural language querying of databases
• Works with Anthropic, OpenAI, Gemini, and Ollama LLM providers
• Supports SQLite, PostgreSQL, MySQL, Snowflake, BigQuery, and other databases
• Optional hosted access control
• Optional hosted observability with real-time metrics and tracing
• Optional hosted agent memory using a vector database
• Optional hosted secure file system
• Optional hosted audit logs
• Optional hosted data retention
• Copy-paste ready configuration code
• Installable via pip

Best suited for

• Letting non-SQL users query company databases in natural language
• Teams wanting an open source text-to-SQL framework
• Organizations needing access-controlled database querying

Pricing

Not stated on the website