IAvanty is a Chrome extension that works with Metabase and provides smart features such as:
- Generating SQL from natural language: You can type in what you want to query in plain English and Avanty will convert it into SQL code that matches your schema. For example, you can type "Top 25 creators who made the most sales 30-60 days ago, but made no sales in the past 30 days" and Avanty will generate the SQL query for you.
- Editing SQL queries: You can modify your existing SQL queries by using natural language commands. For example, you can type "add a column for average order value" or "remove the filter for country" and Avanty will update your SQL code accordingly.
- Understanding SQL queries: You can get smart AI explanations for complex queries that help you understand what they do and how they work. For example, you can hover over a query and Avanty will show you a summary of its logic, purpose and output.
- Commenting SQL queries: You can automatically add comments to your SQL code that explain what each line does and why. This makes your code more readable and maintainable for yourself and others.
- Auto-formatting SQL queries: You can make your SQL code more consistent and neat by using Avanty's auto-formatting feature. You can choose from different formatting styles and apply them to your code with one click.
- Auto-suggesting chart titles: You can save time on naming your charts when saving them in Metabase. Avanty will suggest relevant and catchy titles based on your query and data.
Avanty is designed to supercharge your Metabase workflow and make your data analysis more efficient and enjoyable. You can get started with Avanty for free with a 14-day trial or choose from different pricing plans that suit your needs. Whether you are working solo or with a team, Avanty can help you level up your data skills and insights.