Avanty - Your intelligent Copilot for Metabase

Avanty Your intelligent Copilot for Metabase

What is Avanty?

Avanty serves as an intelligent Chrome extension designed specifically for Metabase users, offering advanced AI-powered capabilities to streamline SQL query workflows. The tool enables data analysts to generate SQL from natural language, automatically format queries, and receive smart explanations for complex database operations.

The extension integrates seamlessly with both self-hosted and cloud-based Metabase instances, providing features like auto-generated chart titles, smart error debugging, and query commenting capabilities. With a focus on keyboard-first operations and privacy-conscious design, Avanty ensures that user data remains secure while offering powerful productivity enhancements.

Features

SQL Generation: Convert natural language to SQL queries based on schema
Query Editing: Edit existing SQL queries using natural language commands
Smart Explanations: Break down complex queries into understandable chunks
Auto-formatting: Automatic SQL query formatting for improved readability
Chart Title Generation: AI-powered automatic chart naming
Error Debugging: ML-powered SQL query debugging assistance
Query Comments: Automated generation of SQL query comments

Use Cases

Generating complex SQL queries from natural language
Understanding and debugging existing database queries
Maintaining consistent SQL formatting across teams
Documenting SQL queries with automated comments
Learning SQL through AI-assisted query generation
Streamlining database analysis workflows

FAQs

How does Avanty work?

Avanty is a Chrome extension that works with Metabase. Once installed, Avanty will automatically detect SQL queries in Metabase and provide helpful features to make writing, editing, understanding and commenting on SQL queries faster and easier.
Is my data safe?

We never touch any data stored in your Metabase instance. Avanty only ever uses the SQL queries you write and the Metabase API to retrieve metadata about your Metabase instance. This includes the schema of your database. Avanty also never executes any SQL on its own.
Is it always 100% correct?

Mostly, but not always. The generated SQL might sometimes be missing columns, or misinterpret your intent. However, even with a ~95% accuracy rate, Avanty can save you a lot of time, since it will usually only require minor tweaks at worst.
Is there a limit to the number of queries I can generate or edit?

For some especially resource-intensive features, such as editing and generating SQL queries, we do have a limit of 60 queries per day. This should be more than enough for most users, but if you ever do hit that limit, we will work with you to find a solution.