Avanty

How Does It Work?

• Avanty works alongside Metabase as a Chrome extension.
• It detects when you are writing SQL queries in Metabase and provides helpful features:
• Generate SQL queries from natural language instructions
• Edit SQL using natural language
• Add explanatory comments to SQL queries
• Auto-format SQL for readability
• Provide auto-generated chart titles
• Help debug errors in SQL

Features and Benefits

• Generate SQL from natural language - Avanty understands your database schema and can generate entire SQL queries from natural language instructions. This saves huge amounts of time compared to writing queries by hand.
• Edit SQL with natural language - Making changes to SQL queries can be done by editing the natural language instructions. No need to worry about syntax and specifics.
• Auto-generated comments - Avanty can add explanatory comments to parts of a complex SQL query, helping others understand what is happening.
• Auto-formatting - SQL queries are reformatted for consistency and readability.
• Auto chart titles - Avanty suggests titles for charts generated from SQL queries.
• Error debugging - Errors in SQL queries can be quickly identified and fixed.

Use Cases and Applications

• Faster SQL query creation - Natural language generation of SQL queries speeds up the process tremendously.
• Improved documentation - Comments make SQL codebases easier to navigate and understand for newcomers.
• Cleaning up legacy SQL - Auto-formatting and commenting help modernize and organize legacy SQL code.
• Onboarding new analysts - The explanations help new team members come up to speed on your SQL queries faster.
• Ad hoc analysis - Quickly generate new SQL queries for ad hoc analyses without coding everything by hand.

Who is Avanty For?

• Data analysts
• BI analysts
• Data engineers
• Data scientists
• Database administrators
• Anyone who writes SQL queries