Avanty

Avanty is an AI powered Chrome plugin designed specifically for Metabase data analysts. It helps you write, edit, understand, and comment on SQL queries, and it can generate SQL intelligently from a plain description of the result you want. Syntax checking and correction, query optimization suggestions, and a data dictionary with templates round out the feature set. The pitch is time: less effort spent producing a query, less spent editing one that almost works, and less spent trying to understand a query someone else wrote months ago. A free trial is offered, with a paid version that adds advanced features.

- Generate SQL from a description of the data you need.

- Check and correct syntax as you type.

- Get optimization suggestions for slow queries.

- Add comments and plain language explanations to existing SQL.

- Metabase data analysts who write queries every day.

- BI and analytics team members maintaining shared questions.

- SQL learners working inside Metabase rather than a course.

- Anyone who has inherited queries they did not write.

It only works with Metabase, so if your team uses another BI tool this is not the plugin for you. A free trial is followed by a paid version, so check what survives after the trial before you build a workflow around it. Generated SQL still needs review: a query that runs is not the same as a query that answers the right question, and anything touching production data should be checked by a person first. As a browser extension, it also has permissions on the pages you open, so install it from the official listing and read what it asks for.