Avanty

What is Avanty?

Avanty is a Chrome extension designed to work with Metabase, providing advanced features to facilitate writing, editing, understanding, and commenting on SQL queries. It automatically detects SQL queries in Metabase, enhancing the query process with features like natural language SQL generation, error debugging, and automated editing and formatting. Avanty is compatible with both self-hosted and cloud-based Metabase instances, ensuring secure handling of metadata without accessing customer data. It also offers support for learning SQL through AI query generation and step-by-step query explanations.

If you're interested in trying Avanty, there is a free 14-day trial available, offering 50 query edits and generations. The tool is not always 100% correct in generating SQL queries but has a high accuracy rate, which can save users significant time with only minor adjustments required most of the time. Avanty provides support to paying subscribers with email and Slack support, ensuring a response within 24 hours.

For those aiming to level up their Metabase workflow, Avanty also offers an Early Access plan with smart AI explanations for complex queries, automatic comments addition to SQL code, auto-formatting, and auto-suggestions for chart titles. The pricing for the Early Access plan is $19/month, while the Team Plan for at least 3 users is available at $15/user. Support is available, and Avanty can be used with any Metabase instance, self-hosted or Metabase Cloud.

Who created Avanty?

Avanty was created by Jan Senko. The company offers an AI-powered Chrome extension designed to enhance the workflow of data analysts using Metabase. Avanty provides features such as natural language SQL generation, smart error debugging, automated editing, and formatting, catering to individuals and teams. It ensures secure handling of metadata and offers support services including email and Slack support with a guaranteed response within 24 hours.

What is Avanty used for?

• Natural Language SQL Generation
• Smart Error Debugging
• Automated Editing and Formatting
• Intuitive Extensions
• Security and Compatibility
• Automated Editing and Formatting of SQL queries
• Smart Error Debugging with machine learning-powered tools
• Intuitive extensions tailored for Metabase
• Enhancing workflow for data analysts and teams
• Secure handling of metadata without accessing sensitive customer data
• AI-powered query generation for learning SQL
• Auto-suggestions for chart titles when saving
• Step-by-step query explanations for understanding complex queries
• Slack integration (coming soon)
• Automated SQL query generation from natural language commands
• Smart error debugging for SQL queries
• Intuitive extensions for working seamlessly in Chrome
• Security and compatibility with Metabase platforms
• Smart error debugging to eliminate common SQL errors
• Automated editing and formatting of SQL queries for better readability
• Intuitive extensions tailored for Metabase users
• Enhancing workflow efficiency for data analysts and teams
• Supporting self-hosted and cloud-based Metabase instances
• Generating auto-suggestions for chart titles
• Providing AI-powered explanations for complex queries
• Helping users learn SQL through AI query generation and step-by-step explanations

Who is Avanty for?

• Data Analysts
• Larger teams
• Data Analyst
• Part of a larger team
• Larger team members

How to use Avanty?

To use Avanty effectively with Metabase, follow these steps:

1. Installation: Add Avanty as a Chrome extension compatible with both self-hosted and cloud-based Metabase instances.

2. Features Overview:

   • Natural Language SQL Generation: Avanty converts your natural language commands into SQL queries.
   • Smart Error Debugging: Utilize machine learning-powered tools to eliminate common SQL errors.
   • Automated Editing and Formatting: Save time with auto-edited and formatted SQL queries for enhanced readability.
   • Intuitive Extensions: Seamlessly use Avanty in Chrome with an intuitive extension tailored for Metabase.
   • Security and Compatibility: Ensure secure metadata access and compatibility across different Metabase platforms.

3. Working Process:

   • Avanty automatically detects SQL queries in Metabase, making writing, editing, understanding, and commenting on SQL queries faster and easier.

4. Language Support: Avanty best functions with natural language commands in English, with ongoing improvements for other languages.

5. Data Safety: Your data in Metabase remains secure as Avanty only uses SQL queries and Metabase API for metadata access, never accessing customer data or executing SQL on its own.

6. Free Trial and Pricing: Avail a free 14-day trial for 50 query edits & generations. After the trial, choose between Early Access ($19/month) or Team Plan ($15/user, minimum 3 users).

7. Support: Email and Slack support is offered with a guaranteed response within 24 hours for paying subscribers.

8. Limitations: There is a daily limit of 60 queries for resource-intensive features like editing and generating SQL queries.

By following these steps, you can enhance your workflow with Avanty, making SQL query processes more efficient and error-free.