Your intelligent Copilot for Metabase

Avanty is an AI-powered Chrome extension that supports data analysts in their work in Metabase. Save time on generating, editing and understanding SQL.

Get started for free Check out the features

ployee_count FROM departments d LEFT JOIN employees e ON d.department_id = e.department_id GROUP BY d.department_name HAVING employee_count > 10 ORDER BY employee_count DESC SELECT d.department_name, COUNT(e.employee_id) as em

ESC, comment_count DESC SELECT u.name, COUNT(DISTINCT p.post_id) as post_count, COUNT(DISTINCT c.comment_id) as comment_count FROM users u LEFT JOIN posts p ON u.user_id = p.user_id LEFT JOIN comments c ON u.user_id = c.user_id GROUP BY u.name HAVING post_count >= 5 AND comment_count >= 10 ORDER BY post_count D

tag_name ORDER BY related_post_count DESC SELECT t1.tag_name, COUNT(t2.post_id) as related_post_count FROM tags t1 JOIN post_tags pt1 ON t1.tag_id = pt1.tag_id JOIN post_tags pt2 ON pt1.post_id = pt2.post_id AND pt1.tag_id != pt2.tag_id JOIN tags t2 ON pt2.tag_id = t2.tag_id GROUP BY t1.

_id = p.product_id GROUP BY order_year, order_month SELECT YEAR(o.order_date) as order_year, MONTH(o.order_date) as order_month, SUM(od.quantity * p.price) as total_sales FROM orders o JOIN order_details od ON o.order_id = od.order_id JOIN products p ON od.product

tudent_id, s1.name, s2.course_id HAVING average >= 80 ORDER BY average DESC SELECT s1.student_id, s1.name, s2.course_id, AVG(s2.grade) as average FROM students s1 INNER JOIN student_courses s2 ON s1.student_id = s2.student_id GROUP BY s1.s

as book_count, AVG(r.rating) as average_rating FROM authors a JOIN books b ON a.author_id = b.author_id JOIN book_ratings r ON b.book_id = r.book_id GROUP BY a.author_name HAVING book_count > 10 ORDER BY average_rating DESC SELECT a.author_name, COUNT(b.book_id)

r_id) as customer_count FROM products p1 JOIN order_details od1 ON p1.product_id = od1.product_id JOIN orders o ON od1.order_id = o.order_id JOIN order_details od2 ON o.order_id = od2.order_id AND od1.product_id != od2.product_id JOIN products p2 ON od2.product_id = p2.product_id GROUP BY p1.name, p2.name ORDER BY customer_count DESC SELECT p1.name as product, p2.name as related_product, COUNT(distinct o.custome

id = e.city_id GROUP BY c.name HAVING event_count >= 5 ORDER BY total_attendees DESC SELECT c.name, COUNT(e.event_id) as event_count, SUM(e.attendees) as total_attendees FROM cities c JOIN events e ON c.city_

= b.date WHERE a.date >= '2022-01-01' AND a.date <= '2022-12-31' GROUP BY a.room_id, a.date HAVING booking_count < a.capacity ORDER BY a.date SELECT a.room_id, a.date, COUNT(b.booking_id) as booking_count FROM availability a LEFT JOIN bookings b ON a.room_id = b.room_id AND a.date

⌘ + enter

Generate SQL from natural language

Avanty knows about your schema and can generate SQL queries from natural language.

metabase.com

SELECT 
      job_title,
      full_name,
      CASE
         WHEN salary >= 500000 THEN 'ultra high earner'
         WHEN salary >= 100000 AND salary < 500000 THEN 'high earner'
         WHEN salary >= 50000 AND salary < 100000 THEN 'middle earner'
         ELSE 'low earner'
      END AS earning_status
FROM staff
WHERE
  department = 'Outdoors'
  AND full_name LIKE 'John%'
 
CASE
    WHEN salary >= 500000 THEN 'ultra high earner'
    WHEN salary >= 100000 AND salary < 500000 THEN 'high earner'
    WHEN salary >= 50000 AND salary < 100000 THEN 'middle earner'
    ELSE 'low earner'
END AS earning_status

Automagically edit SQL queries

Your expertise as a data analyst is best used talking to your business users, not writing repetitive SQL queries. Avanty lets you edit SQL queries in Metabase using natural language, drastically speeding up your workflow.

Auto-generated chart titles

Famously, there are two hard things in computer science: cache invalidation, naming things, and off-by-one errors. With Avanty, you don't have to worry about naming things anymore.

Coming soon

Smart error debugging

Never worry about missing brackets, typos in table names or column names again. Avanty uses the power of machine learning to help you debug your SQL queries.

Summary

This query calculates the total number of orders placed by each customer, with an optional filter on the order date.

Understand spaghetti queries

Avanty breaks down complicated SQL queries into understandable chunks with smart explanations. Tab through them step-by-step.

Smart formatting

Metabase's great missing feature - Avanty automatically formats SQL queries to make them easier to read.
⌘ + i will be your best friends.

metabase.com

SELECT
   DATE_TRUNC ('month', a.date) month_timestamp,
   a.user_id,
   MAX(b.month_date) as most_recent_churn,
   MAX(DATE_TRUNC ('month', c.date)) as most_recent_active
FROM
   logins a
   JOIN user_churns b ON a.user_id = b.user_id
   AND DATE_TRUNC ('month', a.date) > b.month_date
   JOIN logins c ON a.user_id = c.user_id
   AND DATE_TRUNC ('month', a.date) > DATE_TRUNC ('month', c.date)
WHERE
   DATE_TRUNC ('month', a.date) = DATE_TRUNC ('month', current_timestamp)
GROUP BY
   DATE_TRUNC ('month', a.date),
   a.user_id
HAVING
   most_recent_churn > most_recent_active
Avanty

Never write comments again

You can now add generated comments to complicated parts of your SQL query. Do your coworkers a favor and explain what you're doing!

Focus on Avanty Widget

Tab through actions

Autoformat current query

Keyboard-first

Avanty is designed to be used with a keyboard. Simply select the part of the query you want to edit and focus on the Avanty util bar with ⌘ + j.

Under development

Avanty is under active development. We're working hard to bring you the best SQL editing available on the web. Got a feature request, a bug to report or just want to say hi? Just reach out!Give us feedback

Your data stays yours

Avanty only needs access to metadata about SQL queries, but never any customer data.

Get support

We're here to help you get the most out of Avanty. Slack community support available within 24h.

Works everywhere

Whether self-hosted or Metabase Cloud, Avanty detects and runs on any Metabase instance.

Pricing

Supercharge your Metabase workflow today

To build out next features, we are currently offering access to Avanty for a limited number of users at a reduced price.

Early Access

$19/month

Start a free trial

Join the first batch of users to get hands on with Avanty.

Get smart AI explanations for complex queries
Automatically add comments to your SQL code
Auto-formatting
Auto-suggestions for chart titles when saving
Early access to new features

Team Plan

$15/user, at least 3 users

Get in touch

Level-up your Metabase workflow with your whole team.

Get smart AI explanations for complex queries
Automatically add comments to your SQL code
Auto-formatting (settings synced team-wide)
Auto-suggestions for chart titles when saving
Slack integration (coming soon)

Frequently asked questions

Have a question that isn't listed here? Reach out to us by sending us an email and we'll get back to you as soon as possible.

- 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.
- Can Avanty be used with self-hosted Metabase instances?
  Yes, Avanty can be used with self-hosted Metabase instances as well as Metabase Cloud.
- Does Avanty support multiple languages for SQL queries?
  Avanty currently works best when the natural language commands are given in English. We are working on improving and the performance for other languages.
- 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.
- Can I try Avanty before purchasing?
  Yes, we offer a free 14-day trial that allows for 50 query edits & generations. To fight spam, we do require a credit card 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 you will receive an email reminder 3 days before your trial ends.
- 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.
- What kind of support is available for Avanty?
  To all paying subscribers, we currently offer email and Slack support with a guaranteed response within 24 hours.
- Can Avanty help me learn SQL?
  Yes! We've seen some people benefit greatly from using AI query generation to learn SQL. And with step-by-step query explanations, it is easier than ever to understand what a complex query is doing.

Your intelligent Copilot for Metabase

Generate SQL from natural language

Automagically edit SQL queries

Auto-generated chart titles

Smart error debugging

Summary

Understand spaghetti queries

Smart formatting

Never write comments again

Keyboard-first

Under development

Your data stays yours

Get support

Works everywhere

Pricing

Early Access

Team Plan

Frequently asked questions

How does Avanty work?

Can Avanty be used with self-hosted Metabase instances?

Does Avanty support multiple languages for SQL queries?

Is my data safe?

Can I try Avanty before purchasing?

Is it always 100% correct?

Is there a limit to the number of queries I can generate or edit?

What kind of support is available for Avanty?

Can Avanty help me learn SQL?