Avanty

Avanty is a powerful tool that uses artificial intelligence to speed up and simplify the work of data analysts in Metabase. It offers features such as automatic generation of SQL queries from natural language, automatic formatting and editing of SQL queries, and smart error debugging. This means analysts can focus on more important tasks, such as communicating with business users, rather than wasting time on repetitive SQL queries.

Main functions

• Generate SQL queries from natural language : Avanty knows about your schema and can generate SQL queries from natural language, which speeds up the query writing process and reduces errors.

• Automatic formatting and editing of SQL queries : Avanty allows analysts to edit SQL queries in Metabase using natural language, speeding up the process and reducing errors.

• Smart error debugging : Avanty uses the power of machine learning to help debug SQL queries, reducing the time spent searching for errors.

• Automatic formatting : Avanty automatically formats SQL queries, making them clearer and easier to read.

• Smart formatting : Avanty automatically formats SQL queries, making them clearer and easier to read.

• Smart explanations : Avanty breaks complex SQL queries into understandable parts with smart explanations, which helps analysts better understand what's going on in a query.

• Keyboard-first : Avanty is designed to be used with a keyboard. You can select the part of the query you want to edit and focus on the Avanty panel using the keyboard shortcut ? + j .

• Early Access : Avanty offers access to new features to a limited number of users at a reduced price. This includes smart AI explanations for complex queries, automatic SQL commenting, automatic formatting, automatic suggestions for chart titles on save, and access to new features.

• Team Plan : Avanty offers a team plan that includes all Early Access features, plus team settings sync, Slack integration (coming) and other features.

Prices

• Early Access : $19 per month. Start your free trial.

• Team Plan : $15 per month per user, with a minimum of 3 users. Contact us for more details.

Questions and answers

• How does Avanty work? : Avanty is a Google Chrome extension that works with Metabase. Once installed, Avanty automatically detects SQL queries in Metabase and offers useful features to make working with queries faster and easier.

• Can Avanty be used with self-hosted Metabase instances? : Yes, Avanty can be used with self-hosted Metabase instances as well as Metabase Cloud.

• Does Avanty support multiple languages ​​for SQL queries? : Avanty works better when natural language commands are given in English. We are working to improve and improve the feature for other languages.

• Is my data safe? : We never touch the data stored in your Metabase instance. Avanty uses only the SQL queries you write and the Metabase API to retrieve metadata about your instance. Avanty also never executes SQL queries on its own.