Strengths
- AI data flow is documented 2 of 3 models
- Outside agents read chart logic
- Metrics imported from your warehouse
Not found in the docs

Version 1 · Last updated Oct 30, 2026 · Documentation as of Oct 26, 2026
Shown for Gemini 3.8 Flash, the median scorer. The score is that model’s total. The results below combine all three models, so they can add up to a slightly different number.
Analysis
Building and maintaining assets
Context and connections
Reliability and controls
Yes full credit Partly half No none Not found none
Quoted from Mode’s docsUsing AI Assist does not require you to write full SQL queries from scratch.
Quoted from Mode’s docsOne of the primary benefits of the workflow is the ability to integrate natural language seamlessly into SQL code you've already written to quickly iterate.
Quoted from Mode’s docsOnce the generated code returns, you can compare it with your original code, insert the SQL in place of your original edits (Shift + Opt/Alt + I), or copy and paste manually as needed.
Quoted from Mode’s docsRefine data scopeDescribe how you want to limit your data, have AI define the WHERE clause--! exclude returns
Quoted from Mode’s docsMode sends the query syntax along with the additional metadata of the currently selected warehouse name, table column names and their data types as part of the GPT prompt in order to provide helpful, in-context responses.
Quoted from Mode’s docsWrite calculationsDescribe a new metric or an update to an existing one, have AI Assist write the calculationSELECT --! total sales by rep
Quoted from Mode’s docsYou can use the queries resource to manage, update, or retrieve information about a SQL query in a given report.
Quoted from Mode’s docsYou can use the API to update a query’s text without accessing the report in the editor.
Quoted from Mode’s docsOne of the primary benefits of the workflow is the ability to integrate natural language seamlessly into SQL code you've already written to quickly iterate.
Quoted from Mode’s docsWe can insert this code to run the SQL and use the results.
Quoted from Mode’s docsYou can use this resource to either get a single Chart or list of all Charts for a given Report’s Query in your Mode Workspace.
Quoted from Mode’s docsThese include writing queries, building, sharing, or distributing reports, and managing members, workspaces, and data.
Quoted from Mode’s docsTo easily navigate to Reports, Datasets, and Collections in Mode, click the magnifying glass icon in the top right to use the search bar, or use the keyboard shortcut (Cmd/Ctrl + K).
Quoted from Mode’s docsFix broken SQLPrompt AI Assist to fix syntax error and include the error message for context--! update code above to valid Postgres SQL
Quoted from Mode’s docsAs the models progress, we will update the versions if they improve the performance of our features.
Quoted from Mode’s docsView History: The running history of each query execution, including the raw code (as written), rendered code (SQL sent to the database after processing all Liquid code), and any data that was returned.
Quoted from Mode’s docsThough you can include Definitions in your edits, the code contained within a given Definition won’t be included in the context that’s sent to OpenAI or used to generate updated syntax.
Quoted from Mode’s docsBelow is a categorized list of events currently audited:
Quoted from Mode’s docsTo ensure that we provide the best possible experience for our users, we are turning AI Assist on an account-by-account basis, by request only.
Quoted from Mode’s docsYou can create branches and open pull requests in GitHub as normal without affecting your reports in Mode until those branches are merged into the default branch.
Quoted from Mode’s docsOnce opened, you can use it to generate new SQL code on the fly for any warehouse you have Query access to.
Quoted from Mode’s docsNOTE: When you generate, Mode pulls the currently selected warehouse name, column names & data types for all tables explicitly referenced in your SQL, and sends them and your SQL edits to OpenAI for context.
Quoted from Mode’s docsMode does not share any historical data with OpenAI, or use it to train AI Assist.
Quoted from Mode’s docsThese tokens mimic the individual user's access to the resources in the Workspace.
Quoted from Mode’s docsYou can use the queries resource to manage, update, or retrieve information about a SQL query in a given report.
Quoted from Mode’s docsYou can create branches and open pull requests in GitHub as normal without affecting your reports in Mode until those branches are merged into the default branch.
Quoted from Mode’s docsAnother option we would suggest is using Github Sync to track all changes made to a report, so you can go on the Github repo to track exactly what changes are made at what time, and who made the changes.
Quoted from Mode’s docsIf your branch causes any issues, you can revert back to the previous version in GitHub.
Quoted from Mode’s docsTo return a list of all reports in a given Collection, send a GET request to the reports resource.
Quoted from Mode’s docsAn API token is used instead of your email address and account password whenever you programmatically authenticate to Mode with basic authentication.
Quoted from Mode’s docsTo enable the Member API tokens feature, Admins can navigate to your Workspace Settings > Features > API Keys > Member keys.
Quoted from Mode’s docsAs of today, our API rate limiting is approximately 40 requests every 10 seconds, or 4 requests per second per username.
Quoted from Mode’s docsField descriptions can be added to Datasets to build shared understanding around business and logic definition.
Quoted from Mode’s docsIf your branch causes any issues, you can revert back to the previous version in GitHub.
Quoted from Mode’s docsTo retrieve a list of Dataset field descriptions for a given Dataset, send a GET request including the Dataset token to the Dataset field descriptions resource.
Quoted from Mode’s docs- Click Run to test and save your Definition. If the run succeeds, you or anyone else in your Workspace with access to the underlying connection can reference the Definition in their reports.
Quoted from Mode’s docsCheck out Mode’s API endpoints for creating and updating field descriptions to programmatically add and update descriptions from your semantic layer documentation.
Quoted from Mode’s docsYou can create branches and open pull requests in GitHub as normal without affecting your reports in Mode until those branches are merged into the default branch.
Quoted from Mode’s docsWhen you click the generate button, Mode pulls the currently selected warehouse name, column names & data types for all tables explicitly referenced in your SQL, and sends them and your SQL edits to OpenAI for context.
Quoted from Mode’s docsCreating, dropping, and altering tables and views
Quoted from Mode’s docsThis connection will surface all available metrics to query.