Avanty
Open siteCoding & Development
Introduction
Avanty is an AI-enabled Chrome extension that enhances data analysts' efficiency in Metabase by streamlining SQL query tasks.
Avanty Product Information
Avanty — AI Copilot for Metabase
Avanty is an AI-powered Chrome extension that acts as a data analyst companion within Metabase. It is designed to save time by generating, editing, explaining, and documenting SQL queries, with a focus on ease of use and rapid workflow improvements. It can be used with both Metabase Cloud and self-hosted Metabase instances. Avanty emphasizes data safety by only interacting with query metadata and the Metabase API, and it does not execute queries on its own.
Key Capabilities
- Generate SQL from natural language and convert it into well-formatted, readable queries.
- Edit existing SQL queries via natural language instructions.
- Explain complex SQL queries in plain language and break down spaghetti queries step-by-step.
- Auto-format queries and propose descriptive chart titles when saving visuals.
- Automatically add generated comments to SQL to improve code clarity for teammates.
- Provide smart error debugging and help with missing brackets or typos.
- Understand and operate within Metabase contexts: supports joins, aggregations, groupings, filters, and typical BI-related SQL tasks.
- Safe operation: does not run queries, does not access or modify your data; relies on metadata and Metabase API.
- Supports a private UX that enhances SQL learning by offering explanations and guided edits.
- 14-day free trial with limited daily query edits and generations; transparent pricing after trial.
- Cross-platform compatibility: works with self-hosted Metabase instances as well as Metabase Cloud.
How It Works
- Install the Avanty Chrome extension.
- Avanty detects SQL queries in Metabase and offers AI-driven editing, generation, explanation, and commenting features.
- Users can edit queries via natural language, auto-format results, and add internal comments for teammates.
- Access is governed by privacy safeguards: no data leaves your Metabase instance; only metadata and the SQL/queries you write are processed.
Safety and Privacy Considerations
- Avanty never executes SQL on its own and does not touch customer data stored in Metabase.
- It only uses SQL queries and metadata to provide suggestions and explanations.
- Self-hosted use is supported; data remains within your environment.
Pricing & Support
- Early Access / Free trial: 14 days with up to 50 query edits and generations.
- Team Plan available (pricing depends on users).
- Support: email and Slack support for paying subscribers with a guaranteed ~24-hour response.
What’s New / Under Development
- Auto-commenting and smart formatting enhancements.
- Keyboard-focused editing and navigation improvements.
- More robust explanations and error-detection features.
Core Features
- AI-powered SQL generation from natural language
- AI-assisted SQL editing and replacements within Metabase
- Natural-language explanations of complex queries
- Step-by-step breakdowns of spaghetti queries
- Automatic SQL formatting and descriptive chart title suggestions
- Auto-generated inline comments for code clarity
- Smart error debugging and syntax checks
- Privacy-first: no data exfiltration; operates via metadata and Metabase API
- Self-hosted and cloud Metabase compatibility
- 14-day free trial with limited daily query edits/generations