Avanty

Your intelligent Copilot for Metabase

Free Trial

Description

Avanty is an intelligent AI assistant specifically designed as a Chrome extension to enhance the workflow of data analysts using Metabase. It streamlines tasks related to SQL by leveraging artificial intelligence, allowing users to save significant time and effort.

The tool focuses on making SQL more accessible and manageable within the Metabase environment. It assists users in generating SQL queries from natural language prompts, editing existing queries through simple commands, and understanding complex or unfamiliar 'spaghetti' code by breaking it down into understandable steps. Avanty also incorporates features for automatic code formatting and comment generation to improve query readability and maintainability.

Key Features

Generate SQL from natural language: Uses schema knowledge to create SQL queries based on plain English requests.
Automagically edit SQL queries: Allows editing existing SQL using natural language commands.
Understand spaghetti queries: Breaks down complex SQL into understandable, step-by-step explanations.
Smart formatting: Automatically formats SQL code for better readability (⌘ + i shortcut).
Never write comments again: Generates comments to explain complex parts of SQL queries.
Auto-generated chart titles: Suggests names for charts based on the query.
Keyboard-first design: Optimized for keyboard usage (e.g., ⌘ + j to focus).
Smart error debugging (Coming soon): Helps identify and fix typos and errors in SQL queries.

Use Cases

Speeding up SQL query writing in Metabase.
Simplifying the editing process for existing SQL queries.
Understanding complex or unfamiliar SQL code quickly.
Improving SQL code readability and maintainability through formatting and comments.
Learning SQL by generating queries and understanding explanations.

Frequently Asked Questions

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.

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.