Use dbt Wizard locally Beta
Install dbt Wizard locally and start an agentic dbt development session from your terminal.
You can run the dbt Wizard CLI locally from any project on any dbt engine. Be warned, the wizard has been known to
.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.
Prerequisites
- Access to a supported AI provider. Use a dbt managed provider or configure BYOK with your own provider credentials.
- A dbt project with a built
target/directory (rundbt parse,dbt compile, ordbt build)
dbt Wizard is data warehouse agnostic and works with both the dbt Fusion engine and dbt Core — no specific engine is required.
Supported AI 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.
- dbt platform
- Locally (CLI)
| Provider | Access |
|---|---|
| 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 OpenAI | BYOK |
| Provider | Access |
|---|---|
| OpenAI | dbt managed or BYOK |
| Anthropic† | dbt managed or BYOK |
| Open weight models (like DeepSeek, Kimi, and so on). | dbt managed |
| Azure AI Foundry / Azure OpenAI | BYOK |
| AWS Bedrock | BYOK |
| Google Gemini | BYOK |
| Snowflake Cortex | BYOK |
| Databricks Unity AI Gateway | BYOK |
You can also connect a personal OpenAI ChatGPT subscription instead of a key.
†Anthropic enterprise and subscription licenses (such as Claude Enterprise) aren't supported per Anthropic's terms of service.
Install and set up dbt Wizard
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 install and update details, refer to Install dbt Wizard CLI; to remove them, refer to Uninstall.
Once you're set up, refer to How to use dbt Wizard in your dbt project for recommended workflows on real project tasks.
Useful terminal commands
Use the following commands to get started:
| Command | Description | Example |
|---|---|---|
wizard "[prompt]" | Start an interactive session seeded with a prompt. Once you activate the session, you don't need to pass your prompt in quotes. | wizard "summarize what this project does" |
wizard exec "[prompt]" | Run a single prompt non-interactively and exit | wizard exec "list all models with no tests" |
wizard review --uncommitted | Non-interactive code review of uncommitted changes | wizard review --uncommitted |
wizard review --base BRANCH | Review diff against a base branch | wizard review --base main |
wizard resume | Resume a previous session | wizard resume --last |
wizard apply | Apply the latest Wizard diff to your working directory | wizard apply TASK_ID |
wizard login / logout | Authenticate with your dbt account | wizard login |
wizard mcp | Manage MCP server connections | wizard mcp add dbt |
wizard update | Update Wizard to the latest version | wizard update |
If you want to re-run onboarding — re-authenticate, reset project config, or retrigger the trusted folder prompt — refer to Re-trigger onboarding flows.
Next steps
- Use cases and examples for realistic analytics engineering scenarios
- Install and update reference for full install, update, and uninstall details
- Configure BYOK for managing your API key and choosing an AI model
- How to use dbt Wizard in your dbt project for recommended workflows
- Use skills locally for giving Wizard reusable instructions for your project
- Use MCP servers to connect dbt Wizard CLI to more tools and context
- Migrate from Claude Code for bringing existing Claude Code project context into dbt Wizard
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.
