Avanty logo

Avanty

Your intelligent Copilot for Metabase

4.7
Try Avanty

Open Source Voice Agent SDK

Integrate voice into your apps with VideoSDK's AI Agents. Connect your chosen LLMs & TTS. Build once, deploy across all platforms.

Upvote Now

Overview

Hero
Get Started
Avanty is an AI-powered Chrome extension designed to support data analysts working within Metabase. It significantly reduces the time spent on generating, editing, and understanding SQL queries, streamlining the data analysis workflow.

How It Works

  • Avanty operates as a Chrome extension, integrating seamlessly with any Metabase instance (self-hosted or cloud).
  • Detects SQL queries automatically within Metabase after installation.
  • Offers intelligent features for writing, editing, understanding, and commenting on SQL queries directly inside Metabase.
  • Generate new SQL using natural language thanks to Avanty's understanding of your database schema.
  • Edit existing SQL with natural language commands for faster modifications.
  • Breaks down complex SQL into step-by-step explanations for easy understanding.
  • Auto-formats queries for improved readability.
  • Produces AI-generated comments to document complex queries.
  • Streamlined keyboard-first workflow with intuitive shortcuts (e.g., ⌘ + j, ⌘ + i).

Use Cases

Accelerated SQL Development
Quickly generate new SQL queries from natural language descriptions—ideal for analysts who need rapid data extraction within Metabase.
Efficient SQL Modification
Edit and adapt existing SQL queries using natural language for faster dashboard and report updates, minimizing repetitive coding.
Enhanced Query Comprehension
Break down complex SQL questions with step-by-step explanations, making legacy code review and team onboarding easier.

Features & Benefits

  • Generate SQL from natural language based on your database schema
  • Automagically edit SQL queries in Metabase using plain English
  • Step-by-step explanations to understand complex (“spaghetti”) queries
  • Smart SQL formatting for readability and consistency
  • Auto-generated comments on intricate SQL code
  • Keyboard-first workflow with productivity shortcuts (⌘ + j, ⌘ + i)
  • Data privacy & security: only accesses metadata, never executes or accesses data
  • Universal Metabase compatibility (self-hosted & cloud)
  • Auto-generated chart titles (coming soon)
  • Smart error debugging for SQL (coming soon)

Target Audience

  • Data analysts
  • Teams utilizing Metabase for business intelligence and data exploration
  • Organizations seeking to optimize SQL workflows and enhance productivity in Metabase environments

Pricing

  • Early Access Plan:
    • Price: £19/month
    • Features: Smart AI explanations, automatic SQL comments, auto-formatting, chart title suggestions, early access to new features
    • Free trial: 14 days, 50 query edits & generations (credit card required, email reminder before trial ends)
  • Team Plan:
    • Price: £15/user/month (min. 3 users)
    • Features: Smart explanations, auto-formatting (team-synced), automatic comments, chart title suggestions, upcoming Slack integration
  • Limits:
    • 60 SQL query edits/generations per day for resource-intensive features
  • Support:
    • Email and Slack support, response within 24 hours for paying customers

FAQs

How does Avanty work?

Avanty is a Chrome extension that integrates with Metabase. Once installed, it automatically detects SQL queries and provides helpful features to make writing, editing, understanding, and commenting on SQL queries faster and easier.

Can Avanty be used with self-hosted Metabase instances?

Yes, Avanty is compatible with both self-hosted Metabase instances and Metabase Cloud.

Does Avanty support multiple languages for SQL queries?

Avanty currently performs best when natural language commands are given in English. Work is ongoing to improve performance for other languages.

Is my data safe?

Avanty never accesses any data stored in your Metabase instance. It only uses the SQL queries you write and the Metabase API to retrieve metadata about your Metabase instance, including your database schema. Avanty also never executes any SQL on its own.

Can I try Avanty before purchasing?

Yes, Avanty offers a free 14-day trial that allows for 50 query edits & generations. A credit card is required to sign up for the trial to combat spam, and you will be charged at the end of the trial period unless you cancel. You will receive an email reminder 3 days before your trial ends.

Is there a limit to the number of queries I can generate or edit?

For some especially resource-intensive features, such as editing and generating SQL queries, there is a limit of 60 queries per day. This should be sufficient for most users, but if you reach this limit, Avanty will work with you to find a solution.

Can Avanty help me learn SQL?

Yes! Some individuals have greatly benefited from using AI query generation to learn SQL. Additionally, step-by-step query explanations make it easier than ever to understand the functionality of complex queries.

Featured Products