Avanty

What is Avanty?

Avanty is a Chrome extension for Metabase that helps you write, edit, understand, and comment on SQL queries. It detects SQL queries in Metabase and offers features such as generating SQL from plain English, fixing errors, and automatically editing and formatting code. It works with self-hosted Metabase and Metabase Cloud. It handles metadata securely and does not access customer data. It can also help you learn SQL by generating queries and explaining them step by step.

A free 14-day trial is available, allowing you to edit and generate up to 50 queries. SQL generation is not always perfect, but accuracy is high, so you may only need small tweaks. Paying customers get support via email and Slack, with responses within 24 hours.

Who created Avanty?

Jan Senko created Avanty. The company offers the extension to make life easier for data analysts using Metabase. It includes natural-language SQL generation, smart error debugging, and automated editing and formatting. It handles metadata securely and provides email and Slack support with a 24-hour response commitment.

What is Avanty used for?

• Turning plain English into SQL queries
• Fixing common SQL mistakes with machine learning
• Automatically editing and formatting SQL code
• Explaining complex queries with AI
• Adding comments to SQL code
• Suggesting chart titles when saving a chart
• Learning SQL through generated queries and step-by-step explanations
• Keeping metadata secure without accessing sensitive customer data

Slack integration is coming soon.

Pricing

• Early Access plan: $19 per month, includes AI explanations for tricky queries, automatic SQL comments, formatting, and chart title suggestions.
• Team Plan: for at least 3 users at $15 per user.

Avanty works with any Metabase setup, whether self-hosted or Metabase Cloud.