Avanty

What is Avanty

Avanty is an AI-powered Chrome extension that supports data analysts in their work in Metabase. It uses AI to generate SQL from natural language, edit SQL queries using natural language, add comments, auto-formatting, and auto-suggestions for chart titles. Avanty's AI capabilities aim to improve the workflow of data analysts by providing intelligent assistance in writing, editing, understanding, and commenting on SQL queries, ultimately saving time and improving documentation. It is designed to work with both self-hosted Metabase instances and Metabase Cloud, and is compatible with SQL queries written in English (with plans to support other languages in the future).

How to use Avanty

Install Avanty as a Chrome extension and interact with it using keyboard shortcuts and the Avanty util bar. Avanty uses AI to generate SQL from natural language, edit queries using natural language, add comments, and provide auto-formatting, auto-suggestions, and more for efficient SQL query workflow.

Frequently Asked Questions

How does Avanty work?

Avanty is an AI-powered Chrome extension that works with Metabase, detecting SQL queries and providing features like generating SQL from natural language, editing queries using natural language, and more.

Can Avanty always prevent mistakes in SQL queries?

Avanty is mostly correct but not always. Generated SQL queries might sometimes be missing columns or misinterpret your intent, with a ~95% accuracy rate. However, even with this accuracy rate, Avanty can still save you a lot of time.

Can Avanty learn SQL?

Yes, by using the AI query generation and step-by-step query explanations, Avanty can assist in learning SQL.""" }