Avanty

Avanty is a Chrome extension designed to help data analysts work faster and smarter within Metabase. It uses AI to generate and edit SQL queries from natural language, making complex query writing more accessible. The tool understands your database schema and can create accurate SQL statements, saving you time and reducing errors. Beyond query generation, Avanty breaks down complicated SQL into understandable parts with step-by-step explanations. This helps analysts and teams grasp complex data logic without struggling through dense code. It also auto-formats SQL for better readability and can add comments automatically, improving collaboration and code clarity. Avanty supports both self-hosted and cloud Metabase instances, ensuring flexibility for different environments. It never accesses sensitive customer data, only metadata about your queries and schema, keeping your information safe. The extension is keyboard-friendly, allowing quick navigation and editing without leaving the keyboard. The tool is actively developed with a focus on improving SQL editing and understanding. It offers smart error debugging to catch typos and syntax issues before they cause problems. While it works best with English natural language commands, the team is working to improve support for other languages. Avanty is ideal for data analysts who want to spend less time writing repetitive SQL and more time analyzing data and communicating insights. It also benefits teams by standardizing query formatting and documentation. A free trial is available, and pricing plans include options for individuals and teams.

Key Features

• 📝 Generate SQL queries from natural language commands to save time

• 🔍 Break down complex SQL into easy-to-understand steps for clarity

• ⚙️ Automatically format SQL queries for better readability

• 🐞 Detect and fix common SQL errors like typos and missing brackets

• 💬 Add generated comments to explain complex query parts for teams

Pros

• Speeds up SQL query writing with natural language input

• Breaks down complex queries for easier understanding

• Supports both cloud and self-hosted Metabase environments

• Enhances collaboration with auto-generated comments

• Provides smart error detection to reduce debugging time

Cons

• Best natural language support currently limited to English

• Daily limits on query generation and editing for resource-heavy features

FAQ

Can Avanty be used with self-hosted Metabase instances?

Yes, Avanty works with both self-hosted Metabase instances and Metabase Cloud, detecting and running on any setup.

Does Avanty support languages other than English for natural language commands?

Currently, Avanty works best with English commands. The team is actively improving support for other languages.

How does Avanty ensure the safety of my data?

Avanty only accesses metadata about your SQL queries and database schema via the Metabase API. It never touches your actual data or executes SQL on its own.

Is there a limit to how many queries I can generate or edit daily?

Yes, there is a limit of 60 query generations or edits per day for resource-intensive features, which should cover most users' needs.

Can Avanty help me learn SQL?

Yes, Avanty’s step-by-step query explanations and AI-generated SQL can help users understand and learn SQL more effectively.

What kind of support is available for paying subscribers?

Paying users receive email and Slack support with guaranteed responses within 24 hours.