← back to the directory
Application CodingRetrieval & Memory

Vanna

1Retrieval-augmented 2text-to-SQL 3generation 4for 5your 6databases

the six Ws · specification

W1 Who

Maintained by vanna-ai, an open-source project with a hosted offering.

W2 What

A Python framework that trains on your schema and generates SQL from natural-language questions.

W3 Where

Runs as a Python library connecting to your database and vector store.

W4 When

Reach for it when querying databases in plain English grounded on your schema.

W5 Why

Retrieval on your metadata improves SQL accuracy and keeps context under your control.

W6 With

An LLM API key, a database connection, and a vector store.

W7 Watch

Open-source with a commercial backer; it generates SQL you execute, so review queries before running writes. MIT licensed, mature.

alternatives

Text-to-SQLRAGDatabasePython

for agents & scripts

Reading this as a machine? Query it directly.

Search is open JSON - no key. Report telemetry after using a tool and it feeds that tool’s Proof Score. Or speak MCP to /mcp and discover tools mid-loop.