Free trial
A 14-day free trial allows 50 query edits and generations. A credit card is required to start, the subscription charges at the end of the trial, and a reminder email arrives three days before it ends.
Learn moreAvanty
AI copilot that writes, edits and explains SQL inside Metabase
Intermediate
What is Avanty?
Avanty is a Chrome extension that brings an AI copilot into Metabase. It generates SQL from natural language using your schema, rewrites selected query sections on request, formats code, adds comments and explains complex queries step by step. It works with cloud and self-hosted Metabase and is aimed at data analysts.
Avanty is a Chrome extension that adds an AI copilot to Metabase, the open source business intelligence tool. Once installed, it detects SQL queries in the Metabase editor and offers help with writing, rewriting, formatting, commenting and explaining them. The product is built for data analysts who spend a large share of their week inside Metabase writing queries for business users, and it targets the repetitive parts of that work rather than the analysis itself. Generation works from plain language. Avanty reads metadata about your Metabase instance, including the database schema, so a prompt such as a request for the top creators by sales in a given window can be turned into a runnable query with the right joins and filters. The same natural language approach applies to edits: select a section of SQL, describe the change you want, and the extension proposes a replacement you accept or discard. Query explanation breaks long, messy statements into numbered steps so a colleague (or the author months later) can follow the logic. Comment generation and automatic formatting round out the set, and the flow is keyboard driven, with shortcuts for focusing the assistant and accepting suggestions. It suits analytics teams already standardized on Metabase, including self-hosted deployments, more than teams on other BI stacks, since the extension is tied to that environment. Privacy is handled narrowly: Avanty reads your queries and schema metadata through the Metabase API but never your customer data, and it does not execute SQL on its own. Expect roughly 95 percent accuracy by the vendor's own estimate, which means a review pass before anything goes to a stakeholder. The tool is in early access, with a per-day cap on generations and edits.
How do you use Avanty?
1Create your account
Sign up through the Avanty dashboard. The free trial requires a credit card, and you get an email reminder three days before the trial converts to a paid plan.
2Install the Chrome extension
Add Avanty to Chrome and open Metabase as usual. The extension activates automatically on any Metabase instance, cloud or self-hosted.3Write your first query from a prompt
Open the Metabase SQL editor and describe what you need in plain English. Avanty uses your schema metadata to compose the query, then you review it.4Refine with selection-based edits
Select the part of the query you want to change, focus the assistant bar with the keyboard shortcut, describe the edit and accept the proposed replacement.5Format, comment and explain
Run autoformat on the current query, generate comments for complicated sections, and tab through the step-by-step explanation to confirm the logic is what you intended.
Pros and cons
Pros
- Generates SQL from natural language with awareness of your actual Metabase schema, so joins and column names usually come out right.AI
- Selection-based editing lets you describe a change to one part of a query and accept or reject the replacement, which is faster than retyping.AI
- Step-by-step query explanations make inherited or spaghetti SQL readable and double as a way to learn SQL.AI
- Works with both Metabase Cloud and self-hosted instances, so teams are not locked to the hosted product.AI
- Keyboard-first design with shortcuts fits analysts who rarely touch the mouse while editing queries.AI
Cons
- Chrome extension only: there is no support for Firefox, Safari or a standalone editor, and nothing for BI tools other than Metabase.AI
- Natural language commands work best in English, which is a real limitation for international teams.AI
- The vendor admits output is not always correct, so queries still need human review before they reach business users.AI
- Hard cap of 60 generations or edits per day, plus a 50 use limit during the trial, which can bite on heavy days.AI
- Early access product with features such as auto-generated chart titles and Slack integration still listed as coming soon.AI
How much does Avanty cost?
Pricing
Two plans. Early Access costs $19 per month for individual analysts. The Team Plan costs $15 per user per month with a minimum of three users, adds team-wide synced formatting settings and lists a Slack integration as coming soon. Avanty states the reduced early access price is temporary while the product is being built out.
Learn moreSupport
Email and Slack support for paying subscribers with a guaranteed response within 24 hours. Avanty also runs a Slack community and collects feedback through a Typeform form.
Integrations
Built for Metabase, including self-hosted instances and Metabase Cloud. It reads schema metadata through the Metabase API and never accesses customer data. A Slack integration is listed as coming soon.
Features
Generates SQL from natural language using your Metabase schema, edits selected query sections on request, autoformats code, generates comments for complex parts of a query, and explains long queries in numbered steps. A keyboard-driven utility bar keeps the workflow fast. Auto-generated chart titles are listed as coming soon.
Frequently asked questions about Avanty
How much does Avanty cost?
Two plans. Early Access costs $19 per month for individual analysts. The Team Plan costs $15 per user per month with a minimum of three users, adds team-wide synced formatting settings and lists a Slack integration as coming soon. Avanty states the reduced early access price is temporary while the product is being built out.Does Avanty offer a free trial?
A 14-day free trial allows 50 query edits and generations. A credit card is required to start, the subscription charges at the end of the trial, and a reminder email arrives three days before it ends.How do you use Avanty?
The walkthrough on this page covers 5 steps: 1. Create your account 2. Install the Chrome extension 3. Write your first query from a prompt 4. Refine with selection-based edits 5. Format, comment and explain.What platforms does Avanty support?
Avanty is available on Browser extension and Web App.What does Avanty integrate with?
Built for Metabase, including self-hosted instances and Metabase Cloud. It reads schema metadata through the Metabase API and never accesses customer data. A Slack integration is listed as coming soon.What are the limitations of Avanty?
Chrome extension only: there is no support for Firefox, Safari or a standalone editor, and nothing for BI tools other than Metabase. Natural language commands work best in English, which is a real limitation for international teams. The vendor admits output is not always correct, so queries still need human review before they reach business users.
Status
StatusActive
Views0
Outbound clicks0
Added10/21/2026
Platforms
Browser extensionWeb App
Pricing
Free TrialPaidSubscription
