Skip to main content

About dbt Wizard

Your personal dbt agent — wherever you work.

dbt Wizard is an AI agent purpose-built for governed data development in dbt. Unlike general-purpose coding agents, it understands your dbt project through a native metadata engine — a structured index of lineage, model health, tests, contracts, run results, and semantic definitions.

Think of it like a map of your city: dbt Wizard knows how everything connects before it starts, rather than walking every street to figure out the layout. dbt Wizard comes with:

  • Project understanding: A native dbt metadata engine for lineage, contracts, tests, and runtime context
  • Impact awareness: Checks upstream and downstream dependencies before you change code
  • Safe validation: Compiles and builds changes before review
  • Complete workflow: Investigate, change, validate, and review in one place
  • Setup and governance: Works out of the box with dbt governance built in
  • Conversational analytics: Answers questions about production data in plain language through Explore mode, grounded in governed metric definitions
Wizard usage and billing

From September 1st, 2026, dbt Wizard usage is metered per token against your account's usage credits. All credit amounts are per account, not per user. Enterprise and Enterprise+ accounts get monthly credits. Developer and Starter plans start with a 30-day trial and $100 in credits, as do CLI users via a free dbt account.

Refer to Trial and billing for what each plan gets, spend limits, and paid access.

Use dbt Wizard​

dbt Wizard is for anyone doing dbt development. You can use it in the platform with managed or bring-your-own-key (BYOK) credentials, or in the terminal with your own key, with or without a dbt platform account. dbt Wizard is data warehouse agnostic and works on any dbt version.

It's also for people who don't build data at all. In the dbt platform, Explore mode lets read-only users ask questions of production data in plain language, with no developer license and nothing to set up.

The following table shows where dbt Wizard is available, the AI keys each surface uses, and how usage is billed:

WhereStatusAI access options
dbt platform: Studio IDE Public previewdbt managed or BYOK
dbt platform: dbt Wizard home tabPublic previewdbt managed or BYOK
Locally: Terminal (CLI)Public betadbt managed, BYOK, or OpenAI subscription

Supported providers​

dbt Wizard supports managed models (billed by dbt Labs, no key to manage) and bring-your-own-key (BYOK) models (billed directly by your provider).

Here are the following AI providers supported depending on where you work. Refer to Model Provider Rate table for the full list of available models.

ProviderAccess
OpenAI (default)dbt managed or BYOK
Anthropic†dbt managed or BYOK
Open weight models (like DeepSeek, Kimi, and so on).dbt managed
Azure AI Foundry / Azure OpenAIBYOK

†Anthropic enterprise and subscription licenses (such as Claude Enterprise) aren't supported per Anthropic's terms of service.

For pricing and how billing works, refer to Models and pricing.

Get started​

You can get started with Wizard wherever you work, whether it's the terminal or the dbt platform:

(Be warned, the wizard has been known to

.)

Wizard in the CLI Beta​

A terminal-based agent for governed data development in dbt, whether your team uses the dbt platform or self-hosts. Bring your own key to experience the full agentic analytics engineering loop.

1
Install the dbt Wizard CLI

Run the install script for your operating system:

macOS/Linux:

curl -fsSL https://public.cdn.getdbt.com/dbt-wizard/install/install-wizard.sh | sh

Windows (PowerShell):

irm https://public.cdn.getdbt.com/dbt-wizard/install/install-wizard.ps1 | iex

This installs dbt Wizard to /usr/local/bin/wizard, along with the dbt metadata engine that powers dbt Wizard's project-aware answers.

For first-run setup and billing, refer to Use dbt Wizard locally.

New to the terminal?

If you've never used the terminal before, check out the terminal guide for for some helpful tips to help you get started!

Wizard in dbt platform Preview​

Leverage agentic capabilities in the home app or Studio IDE for governed data development in dbt.

AI features are on by default, so most accounts can jump straight in. If your account has them turned off, an admin can turn them back on in Account settings.

To get started:

  1. Sign in to the dbt platform, or create a free account if you don't have one yet.
  2. Open dbt Wizard from the home tab in the left sidebar, or from Studio IDE to work alongside the file editor.
  3. Start with your usage credits or a 30-day trial. Enterprise and Enterprise+ accounts get monthly usage credits; all other plans can start a trial. Refer to Trial and billing.
  4. Try a prompt, such as:
    • summarize what this project does
    • list all models with no tests
    • add not_null and unique tests to the primary key of stg_customers

Refer to Use cases and examples for more prompts.

See it in action and share your feedback

Want to see dbt Wizard in action? Check out the demo video.

We'd love to hear how dbt Wizard is working for you. Share your feedback by either running the /feedback slash command in your interactive terminal session or by going to the #dbt-wizard channel in the dbt Community Slack.

Thanks so much for your help in improving dbt Wizard and dbt data development!

Was this page helpful?

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

0
Loading