Vanna

Vanna is a Python framework for adding database chat to analytics applications and internal tools. The project is archived and no longer maintained.

• Questions to SQL: Users ask database questions in plain language and receive interactive tables, Plotly charts and written summaries, with support for follow-up questions.
• User-specific access: Query execution carries user identity and filters results according to row-level permissions, with support for existing cookies, JWTs and OAuth tokens.
• Embedded chat: A ready-made web interface streams progress and results into applications built with React, Vue or plain HTML.
• Query oversight: Track queries per user, apply per-user rate limiting and store conversation history.

The open-source framework uses the MIT license and can be self-hosted. It supports Ollama as well as external model providers including OpenAI, Anthropic and Gemini. Database choices include SQLite, PostgreSQL, MySQL, Snowflake, BigQuery, DuckDB and SQL Server. Connecting a cloud model or database sends the affected work to that external service.

Vanna also offers a cloud option and optional hosted administration services. Those services include access control, metrics and tracing, vector storage for agent memory, file storage, audit logs, and retention of conversations and logs.