Vanna AI

Vanna AISince 2023-08

Vanna AI is an open-source Python-based RAG (Retrieval-Augmented Generation) framework engineered to generate high-accuracy SQL queries from plain English questions. Unlike general-purpose chatbots that frequently hallucinate non-existent database columns and tables, Vanna trains specifically on your database schema, table DDL, documentation, and historical query logs. When a business user or developer asks a natural language question, Vanna retrieves relevant schema definitions and validated SQL examples to construct an accurate, executable SQL query for PostgreSQL, Snowflake, BigQuery, MySQL, SQLite, or SQL Server. With over 12,000 GitHub stars, Vanna allows organizations to deploy self-hosted text-to-SQL agents inside Slack, Streamlit dashboards, or internal REST APIs without exposing private database records to third parties.

Vanna operates on a simple two-phase architecture: training and inference. In the training phase, you feed Vanna your database DDL statements, business documentation, and validated SQL query pairs, which Vanna stores in a vector database (such as ChromaDB, Qdrant, or Pinecone). During inference, Vanna uses semantic vector search to find the closest matching schema definitions and verified SQL patterns, injecting them into the LLM context (supporting OpenAI, Anthropic, Mistral, and local Ollama models) to synthesize the target SQL query. Vanna can automatically execute the query against your database connection, generate interactive Plotly charts, and explain the SQL logic in plain English.

Microsoft ClaritySince 2023-01

Microsoft Clarity is a 100% free behavioral analytics tool built by Microsoft, widely used by US web developers, digital marketers, SaaS founders, and e-commerce store owners. It gives you a complete visual picture of how real visitors interact with your website — where they click, how far they scroll, and exactly where they lose interest and leave. Clarity's two core features are heatmaps and session recordings. Heatmaps show you aggregate click, scroll, and move patterns across your entire site in a color-coded visual. Session recordings let you replay individual user visits, including the ability to automatically flag frustration signals like rage clicks (rapid repeated clicking) and dead clicks (clicking on non-interactive elements). For US businesses managing CCPA compliance, Clarity is fully CCPA- and GDPR-compliant and automatically masks sensitive input fields — passwords, credit card numbers, and personal data — without any manual configuration.

What makes Microsoft Clarity exceptional for US users is that it has no usage limits whatsoever — unlimited sessions, unlimited recordings, unlimited heatmaps — all for free, forever. This makes it the most compelling free alternative to Hotjar (which charges $39–$99/month) and FullStory (which starts at $199/month) for US businesses watching their SaaS tool budget. In 2026, Clarity added an AI Copilot feature that generates natural language summaries of user behavior — instead of manually watching hours of session recordings, you can ask Clarity "Where are users getting confused on my checkout page?" and get an instant AI-generated answer. Clarity also integrates directly with Google Analytics 4, combining behavioral data (what users do) with traffic data (how they arrived) in a single dashboard.