Avanty

Avanty is a specialized AI assistant for Metabase, delivered as a seamless Chrome extension. It's meticulously designed to supercharge the productivity of data analysts by integrating intelligent capabilities directly into their existing Metabase workflow. Avanty acts as a copilot, understanding the context of your database schema to help you write, edit, understand, and maintain SQL queries with unprecedented speed and ease. By translating natural language into complex SQL, explaining convoluted code, and automating tedious tasks like formatting and commenting, Avanty empowers analysts to focus on what truly matters: deriving insights from data.

How to use Avanty

Getting started with Avanty is straightforward and designed for immediate impact:

1. Install the Avanty Chrome extension from the Chrome Web Store.
2. Navigate to your Metabase instance, whether it's on Metabase Cloud or a self-hosted server. Avanty will automatically detect the SQL editor.
3. To generate a query, simply type a description of the data you need in plain English (e.g., "Show me the top 10 customers by total spending last quarter") and let Avanty write the SQL for you.
4. To edit an existing query, select the code you wish to change and provide a natural language command (e.g., "Change the date grouping from monthly to weekly and add a filter for users from Canada").
5. Use the "Explain Query" feature to get a clear, step-by-step breakdown of what a complex or unfamiliar query does.
6. Utilize keyboard shortcuts like ⌘ + i for instant SQL formatting or ⌘ + j to open the command panel, which provides quick access to all of Avanty's features.

Core Features of Avanty

• Natural Language to SQL Generation: Generate accurate, schema-aware SQL queries from simple English prompts, eliminating the need to write code from scratch.
• AI-Powered SQL Editing: Intelligently modify existing SQL queries using natural language instructions. An inline diff-viewer allows you to review suggested changes before accepting them.
• Complex Query Explanation: Deconstructs even the most complicated "spaghetti" queries into easy-to-understand, step-by-step explanations, making code reviews and onboarding easier.
• Automatic SQL Commenting: Instantly add clear, context-aware comments to your SQL code, improving readability and making it easier for your team to collaborate and maintain queries.
• Smart SQL Formatting: Automatically format messy SQL code into a clean, standardized, and readable layout with a single command.
• Auto-Generated Chart Titles: Overcome the challenge of naming things by getting intelligent, context-aware title suggestions for your Metabase charts and questions.
• Prompt History: Easily access, review, and reuse your past prompts, generated queries, and edits from your personal history dashboard.
• Slack Integration (Preview): Bridge the gap between communication and analysis. Find relevant Metabase questions or generate new ones directly from conversations in Slack.
• Smart Error Debugging (Coming Soon): Get AI-powered assistance to quickly identify and fix typos, syntax errors, and other common issues in your SQL queries.

Use Cases for Avanty

Avanty is versatile and valuable in various scenarios:

• Rapid Prototyping & Exploration: Quickly generate initial queries for new analyses, allowing for fast iteration and exploratory data analysis without the friction of manual coding.
• Onboarding & Training: New analysts can get up to speed faster by using the explanation feature to understand the company's database schema and complex legacy queries.
• Code Refactoring & Maintenance: Instantly format and add comments to old SQL queries, improving code quality and making them easier for the entire team to understand and maintain.
• Enhancing Cross-functional Collaboration: Analysts can quickly translate data requests from business stakeholders (phrased in plain English) into functional SQL queries, speeding up response times.
• Debugging and Optimization: Use the explanation feature to understand the logic of a slow or incorrect query, making it easier to identify areas for optimization.

Advantages of Avanty

Avanty offers a significant competitive edge for data teams:

• Massive Time Savings: Drastically reduces the time spent on the repetitive tasks of writing, editing, debugging, and documenting SQL.
• Increased Analyst Productivity: Frees up analysts from tedious coding to focus on higher-value activities like data interpretation, strategic analysis, and communicating insights.
• Improved Code Quality & Consistency: Automated formatting and commenting ensure that all SQL queries adhere to a high standard of readability and maintainability.
• Democratized Data Analysis: Lowers the technical barrier for performing complex data analysis, empowering junior analysts and other team members to work more independently.
• Seamless & Secure Integration: As a Chrome extension, it works directly within your existing Metabase environment without complex setup. It prioritizes data privacy by only accessing query metadata and schema, never your customer data.

Pricing and Plans

Avanty offers a straightforward pricing structure to suit individual analysts and teams:

• Free Trial: A 14-day free trial is available, allowing for up to 50 query edits and generations. A credit card is required to prevent spam, and you can cancel anytime.
• Early Access Plan: Priced at $19/month for individual users. This plan includes all core features like AI query generation and editing, smart explanations, auto-commenting, auto-formatting, and early access to new features.
• Team Plan: Priced at $15/user/month with a minimum of 3 users. It includes all features of the Early Access plan, plus team-wide synchronized settings and the upcoming Slack integration.