Skip to main content

Atlas AI Co-pilot

Atlas is a warehouse-grounded AI assistant built into the dbdeux editor. It understands your schema, models, and active context to provide relevant suggestions, explanations, and code generation without leaving the IDE.

stg_orders.sql
SELECT
order_id,
customer_id,
{{ ref('dim_customers') }}
FROM {{ source('raw', 'orders') }}
โœฆ Atlas AIGrounded
Ask about your code...

Overviewโ€‹

Atlas lives in a resizable side panel next to your code editor. Click the floating AI button on the right edge (drag it to reposition) to open it. Everything you ask is grounded in your actual workspace: the active file, cursor position, connected database, and schema context.

Atlas focuses exclusively on your code and data. It answers questions about SQL, dbt models, Jinja templates, YAML configuration, and data modeling. Off-topic questions receive a polite redirect.

How Atlas Reads Your Contextโ€‹

When you ask a question, Atlas automatically gathers context from your editor before responding:

๐Ÿ“„
Active File
Reads your open model
โ†’
๐Ÿ“
Cursor Position
Knows where you are
โ†’
๐Ÿ—„
Schema Context
Tables, columns, types
โ†’
โœฆ
Atlas Response
Grounded suggestion

This context grounding means Atlas gives answers specific to your code and your schema, not generic advice.

Capabilitiesโ€‹

Context-Aware Assistanceโ€‹

  • Active file awareness: Knows which file you have open and where your cursor is
  • Schema grounding: Understands your connected database, schemas, and table structures
  • Metric grounding: When Atlas Metrics is enabled, Atlas also reads your governed metric definitions (names, expressions, dimensions) so answers are consistent with your shared metric layer
  • dbt-aware: Understands refs, sources, macros, tests, and the dbt project structure
  • Focused diffs: When suggesting changes, shows only the relevant snippet, not the entire file

What Atlas Can Doโ€‹

TaskExample
Explain code"What does this model do?"
Generate SQL"Write a query to find duplicate orders"
Debug errors"Why is this test failing?"
Suggest improvements"How can I optimize this join?"
Write tests"Generate a uniqueness test for order_id"
Jinja help"Convert this to an incremental model"
Schema questions"What columns are in the orders table?"
Multi-file changes"Rename this column and update everything that references it"
Define a metric"Define a governed revenue metric on the orders model"

Code Blocksโ€‹

Atlas responses include syntax-highlighted, copyable code blocks. Code is tagged with the correct language (SQL, YAML, Python, Jinja) for proper formatting.

Agent Mode: Changes Across Multiple Filesโ€‹

Some requests, like renaming a column or refactoring a model, touch more than one file. In agent mode, Atlas plans the change across your project, reads every file it intends to edit, and then proposes a complete, reviewable changeset.

A
Rename customer_id to customer_key in dim_customers and update everything that references it.
Reading project files
โ—‹models/marts/dim_customers.sql
โ—‹models/staging/stg_orders.sql
โ—‹models/schema.yml
Proposed changes ยท review before applying
models/marts/dim_customers.sql+6-2Apply
models/schema.yml+9-0Apply
Atlas proposes edits and grounds them in your lineage. Nothing is written until you apply each file.

How it works:

  1. Plan and read: Atlas finds the relevant files (models, their schema.yml, macros, and downstream refs) using your dbt lineage, and reads each one before proposing anything
  2. Propose a changeset: Atlas returns the full new content for each file it wants to change, grouped into one reviewable set, along with a short summary of what changed and what to double-check
  3. Review and apply: You review each proposed file and apply the ones you want, right in the chat panel

Two guardrails make this safe to use on real projects:

  • Nothing is applied automatically. Atlas never writes to your files on its own. Every edit is a proposal until you apply it
  • Grounded in your lineage. If a column or model is referenced downstream, Atlas includes those files in the changeset or explicitly warns you that they need follow-up, so a rename does not silently break dependents

Quick Actionsโ€‹

Atlas offers context-aware quick actions so common tasks are one click instead of a hand-written prompt. Based on your active model and grounding context, you may see actions such as:

  • Explain the current model, or trace its lineage
  • Generate tests grounded in the model's real columns, types, and lineage
  • Document columns for models that are missing descriptions
  • Review changes on your current branch
  • Fix an error: paste an error message and Atlas explains the root cause and gives you a minimal fix
  • Define metric: describe a business metric in plain language and Atlas drafts its governed definition, consistent with your metric layer

Quick actions also appear as handoffs from other surfaces. For example, a documentation gap in the Atlas Catalog coverage scorecard can open the model file and start a grounded documentation request in one click.

AI Modelโ€‹

Atlas is ready to use out of the box with no configuration needed. It runs on a managed AI model selected for the best balance of speed and quality, so there is nothing to set up or configure. Just open the panel and start asking questions.

Clean Chat Interfaceโ€‹

The Atlas panel uses a streamlined chat interface focused on your conversation. The input area and message list fill the panel with no unnecessary controls. This keeps the focus on your questions and answers.

Performanceโ€‹

Atlas is optimized for fast, responsive interactions:

  • First turn: Atlas gathers context from your active file, project, and schema. This may take a moment on the first question
  • Follow-up turns: Subsequent questions in the same session stream immediately with minimal latency
  • File switching: Changing the active file refreshes context automatically so answers stay relevant

Session Managementโ€‹

Atlas maintains conversation sessions so you can return to previous discussions:

  • New session: Start a fresh conversation with the + button
  • Session history: Browse and reopen previous sessions via the history icon
  • Session titles: Auto-generated from the first message for easy identification
  • Persistent context: Each session remembers its full conversation history

AI Usage and Budgetsโ€‹

Atlas usage is tracked at the organization level. Admins can set monthly spending limits and view usage breakdowns by user and feature in Organization Settings.

When a budget limit is reached, Atlas lets you know and pauses AI responses until the next cycle or until an admin adjusts the limit.

Privacy and Securityโ€‹

  • No training: Your code and queries are not used to train any AI models
  • Secure inference: AI requests are processed securely and never stored beyond the active session
  • Organization-scoped: Each organization has independent usage tracking and budgets
  • Content safety: Atlas includes built-in content filtering for safe, professional responses

Keyboard Shortcutsโ€‹

ShortcutAction
Click the AI buttonToggle Atlas panel
EnterSend message
Shift + EnterNew line in message

How It Comparesโ€‹

CapabilityAtlas AIGitHub CopilotStandalone AI tools
Schema groundingReads your actual warehouse tables, columns, and typesNo warehouse awarenessNo warehouse awareness
dbt awarenessUnderstands refs, sources, macros, tests, and project structureGeneric code completionGeneric - no dbt context
Active file contextKnows your open file, cursor position, and surrounding codeFile-level contextCopy-paste only
Metric groundingUses your governed metric definitions for consistent answersNot availableNot available
SetupReady to use out of the box, no configurationAPI key + extension installAPI key + browser tab
Code generationGenerates dbt-specific SQL, YAML, Jinja, and testsGeneral code suggestionsGeneral code generation
Multi-file changesProposes a reviewable changeset grounded in lineage; nothing applied automaticallySingle-file suggestionsCopy-paste, no project awareness
PrivacyCode never used for training, scoped to your orgOpt-out requiredVaries by provider