AI Assist

Product · Developer tool by Mode

Flexible query writing with generative AI for data analysts.

AI Assist is a generative AI tool integrated into the Mode platform to help analysts write SQL queries more efficiently. It allows users to blend natural language with SQL by using special comment tags, which the tool then translates into functional code. The feature is designed to reduce repetitive tasks, such as writing complex joins, window functions, and date range syntax, while keeping the analyst in control of the final output. It leverages OpenAI's GPT models to provide in-context suggestions based on the selected warehouse's schema. AI Assist is available within both the Report and Dat

Languages
English
Underlying Models
GPT-3.5T and GPT-4T
Model Provider
OpenAI
Input Method
Natural language comments (--!)
Context Awareness
Warehouse name, column names, and data types

Overview

AI Assist is a generative AI tool integrated into the Mode platform to help analysts write SQL queries more efficiently. It allows users to blend natural language with SQL by using special comment tags, which the tool then translates into functional code. The feature is designed to reduce repetitive tasks, such as writing complex joins, window functions, and date range syntax, while keeping the analyst in control of the final output. It leverages OpenAI's GPT models to provide in-context suggestions based on the selected warehouse's schema. AI Assist is available within both the Report and Dataset contexts of the Mode platform.

Query Generation

  • Natural Language to SQL: Incorporate natural language directly into SQL by adding a special AI comment type via the --! symbol.
  • On-the-fly Generation: Generate new SQL code on the fly for any warehouse the user has query access to.
  • Join Completion: Describe desired data joins in plain English and let the AI fill in the specific join keys and syntax.
  • Relative Date Ranges: Describe a date range in natural language to have the AI complete the proper SQL syntax.

Analyst Ergonomics

  • Side-by-side Comparison: Compare AI-generated code with original edits before inserting it into the editor.
  • One-click Insertion: Insert suggested SQL directly into the report or dataset context with a keyboard shortcut.
  • Syntax Error Correction: Prompt the AI to identify and fix syntax errors in existing SQL code.
  • Calculation Writing: Describe a new metric or update an existing one to have the AI write the necessary calculation.

Specifications

Underlying Models
GPT-3.5T and GPT-4T
Model Provider
OpenAI
Input Method
Natural language comments (--!)
Context Awareness
Warehouse name, column names, and data types

Added by AntSpace from public sources (mode.com).

Related

More products by Mode