Avanty
Avanty is an AI-powered data query and business intelligence tool that aims to simplify the process of extracting valuable insights from da...
Last verified:
What is Avanty?
Avanty is an AI-powered Chrome extension that serves as an intelligent Copilot for data analysts working in Metabase. It helps users save time on generating, editing, and understanding SQL queries by leveraging artificial intelligence. The tool integrates directly into Metabase's SQL editor, appearing as a button above the editor next to the selected database name.
Key features include generating SQL from natural language queries, automagically editing SQL queries using natural language, auto-generated chart titles for new Metabase charts, smart error debugging for SQL queries that result in errors, step-by-step explanations of complicated SQL queries, smart formatting to automatically format SQL code, and automatically adding generated comments to complicated parts of SQL queries. The tool is keyboard-first designed, using shortcuts like ⌘ + j to focus on the Avanty utility bar and ⌘ + enter to generate queries.
Avanty is specifically designed for data analysts and data scientists who work with Metabase daily. It works with both self-hosted Metabase instances and Metabase Cloud, detecting and running on any Metabase installation. The tool knows about your database schema and can generate accurate SQL queries from natural language prompts like
Avanty pricing
Pricing model: Paid
Avanty offers two pricing plans. Early Access is $19/month for individual users, including smart AI explanations for complex queries, automatic comments on SQL code, auto-formatting, auto-suggestions for chart titles when saving, and early access to new features. A 14-day free trial is available with 50 query edits and generations, but requires a credit card to sign up and you will be charged at the end of the trial period unless you cancel. The Team Plan is $15/user per month with a minimum of 3 users ($45/month total), including all Early Access features plus auto-formatting settings synced team-wide and Slack integration (coming soon). Both plans include email and Slack support with 24-hour guaranteed response.
Avanty pros
- Generates SQL queries from natural language prompts
- Edits SQL queries using natural language instead of manual coding
- Auto-generates chart titles when saving Metabase charts
- Provides step-by-step explanations of complex SQL queries
- Auto-formats SQL code with keyboard shortcut ⌘ + i
- Automatically adds comments to complicated SQL parts
- Smart error debugging for SQL queries with errors
- Keyboard-first design with efficient shortcuts like ⌘ + j
- Works with both self-hosted Metabase and Metabase Cloud
- Knows your database schema for accurate query generation
- Never accesses or executes customer data from your Metabase
- 24-hour guaranteed response support via email and Slack
- 14-day free trial with 50 query edits and generations
- Detects and runs on any Metabase instance automatically
- Supports all Chromium-based browsers including Chrome, Edge, Brave, Arc, Vivaldi, Opera
- Saves significant time on repetitive SQL query writing
- 95% accuracy rate means only minor tweaks needed usually
Avanty cons
- Only works with Chromium-based browsers, not Firefox or Safari
- Currently works best with English natural language commands only
- Required browser permission to read and change data on all websites
- 60 queries per day limit for generating and editing SQL
- Credit card required to sign up for the free trial
- Not always 100% correct - may miss columns or misinterpret intent
- Still under active development with some features coming soon
- Team Plan requires minimum 3 users at $15/user
- Early Access priced at $19/month which may be high for individuals
Frequently asked questions about Avanty
How does Avanty work?
Avanty is a Chrome extension that works with Metabase. Once installed, Avanty automatically detects SQL queries in Metabase and provides helpful features to make writing, editing, understanding, and commenting on SQL queries faster and easier. It appears as a button above the SQL editor next to the selected database name.
Can Avanty be used with self-hosted Metabase instances?
Yes, Avanty can be used with self-hosted Metabase instances as well as Metabase Cloud. It detects and runs on any Metabase instance regardless of whether it is self-hosted or cloud-based.
Does Avanty support multiple languages for SQL queries?
Avanty currently works best when the natural language commands are given in English. The team is working on improving performance for other languages, but English is the primary supported language for natural language queries.
Is my data safe with Avanty?
Yes, your data is safe. Avanty never touches any data stored in your Metabase instance. It only uses the SQL queries you write and the Metabase API to retrieve metadata about your Metabase instance, including your database schema. Avanty also never executes any SQL on its own.
Can I try Avanty before purchasing?
Yes, they offer a free 14-day trial that allows for 50 query edits and generations. To fight spam, a credit card is required to sign up for the trial, and you will be charged at the end of the trial period. You can cancel your subscription at any time and will receive an email reminder 3 days before your trial ends.
Is Avanty always 100% correct?
Mostly, but not always. The generated SQL might sometimes be missing columns or misinterpret your intent. However, even with approximately 95% accuracy rate, Avanty can save 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?
Yes, for resource-intensive features like editing and generating SQL queries, there is a limit of 60 queries per day. This should be more than enough for most users, but if you hit that limit, the team will work with you to find a solution.
What kind of support is available for Avanty?
To all paying subscribers, Avanty currently offers email and Slack support with a guaranteed response within 24 hours. There is also Slack community support available for getting the most out of Avanty.
Can Avanty help me learn SQL?
Yes! Some people benefit greatly from using AI query generation to learn SQL. With step-by-step query explanations, it is easier than ever to understand what a complex query is doing, making it a valuable learning tool.
What browsers does Avanty support?
Avanty currently supports all Chromium-based browsers, including Google Chrome, Microsoft Edge, Brave, Arc Browser, Vivaldi, and Opera. It does not support Firefox, Safari, or other non-Chromium browsers.