Avanty

Avanty is a Chrome extension that helps data analysts working with Metabase get more out of their work by writing, editing and understanding SQL queries more easily. Through the use of AI technology, Avanty provides a range of features that speed up data analysis tasks and make it easier to work with Metabase.

Some of Avanty's features include:

• Generate SQL from natural language: Write SQL queries directly from natural language, taking into account schema knowledge.
• Automated SQL editing: Write SQL queries in natural language, so you don't have to write the same code over and over.
• Auto-generated chart titles: No more manual naming.
• Smart error debugging: Find and fix errors like missing brackets or typos.
• Query breakdown and explanation: Break down complex SQL queries into understandable parts with step-by-step explanations.
• Smart formatting: Format SQL queries for better readability.
• Generated comments: Add comments to SQL queries for better understanding and collaboration.

Avanty is designed to be keyboard-focused and works with self-hosted and Metabase Cloud installations. Customers can use the tool without worrying about data security, as Avanty only reads metadata and never touches customer data.

Pricing tiers include:

• Early Access: $19/month, which includes AI query explanations, auto-comments, auto-formatting and early access to new features.
• Team Plan: $15/user (min 3 users), which includes team-wide synced settings, Slack integration and advanced collaboration features.

Avanty offers a 14-day free trial that lets you make 50 edits and generations. The AI isn't perfect, but it's usually close enough that you can get away with just a little tweaking. The tool has a daily limit of 60 queries for the more resource-intensive features. Customers can use email and Slack support, with a response time of 24 hours.

Published on June 9, 2024