dbt Extension for VS Code
Product · Developer tool by dbt Labs
It is designed for data analysts and engineers who prefer local development, providing real-time features such as live error detection, SQL autocomplete, and hover information. The extension allows users to preview compiled SQL and inline CTEs, trace model definitions across projects, and view interactive lineage without leaving their editor. Powered by the dbt Fusion engine, it delivers lightning-fast parse times and is compatible with both dbt v1 and v2. By bringing software engineering best practices to the local IDE, it helps teams build and debug data pipelines more efficiently.
- Price
- From 0 USD
- Languages
- SQL
Category: Developer Tools
- Programming languages
- SQL, Jinja, YAML
- Editors and tools
- Visual Studio Code, Cursor
- License
- Proprietary (dbt Product Licensing Agreement)
- Deployment
- Local development environment
- Supported Editors
- Visual Studio Code, Cursor
- dbt Versions
- v1, v2
- Real-time SQL validation and IntelliSense
- Interactive lineage and definition tracing
- Supports dbt v1 and v2 projects
Overview
It is designed for data analysts and engineers who prefer local development, providing real-time features such as live error detection, SQL autocomplete, and hover information. The extension allows users to preview compiled SQL and inline CTEs, trace model definitions across projects, and view interactive lineage without leaving their editor. Powered by the dbt Fusion engine, it delivers lightning-fast parse times and is compatible with both dbt v1 and v2. By bringing software engineering best practices to the local IDE, it helps teams build and debug data pipelines more efficiently.
Development Experience
- IntelliSense and Autocomplete: The extension provides autocomplete, hover information, and inline error detection as developers type SQL code.
- SQL Preview and Debugging: Users can preview inline Common Table Expressions (CTEs) and compiled SQL directly within the editor for faster debugging.
- Definition Tracing: The tool enables developers to trace model and column definitions across the entire dbt project.
Platform and Performance
- dbt Version Support: The extension is built to enhance the power of dbt v2 while remaining available for v1 projects.
- Supported Editors: The tool is compatible with both Visual Studio Code and the Cursor editor.
- Fusion Engine Integration: The extension is powered by the dbt Fusion engine for lightning-fast parse times and performance.
Use cases
- Analytics engineers use the extension to catch SQL syntax errors immediately as they type, before running models in the warehouse.
- Developers trace complex model and column definitions across large dbt projects to understand data dependencies.
- Data teams preview compiled SQL and CTEs to debug transformation logic faster during local development.
Specifications
- Programming languages
- SQL, Jinja, YAML
- Editors and tools
- Visual Studio Code, Cursor
- License
- Proprietary (dbt Product Licensing Agreement)
- Deployment
- Local development environment
- Supported Editors
- Visual Studio Code, Cursor
- dbt Versions
- v1, v2
- Engine
- dbt Fusion Engine (Rust-based)
- License Type
- dbt Product Licensing Agreement
- Core Features
- Autocomplete, Lineage, CTE Preview, Error Detection
How it works
- Installation: Install the free dbt extension from the Visual Studio Code Marketplace or within the Cursor editor.
- Project Discovery: Open a dbt project folder locally to allow the extension to discover your models, tests, and configurations.
- Local Development: Develop SQL models with real-time feedback, including autocomplete and inline error detection powered by the dbt Fusion engine.
Pricing
- Standard Extension
- Free
FAQ
Does it work with dbt v1 and v2?
Yes, the extension supports both the original Python-based dbt v1 and the current Rust-based dbt v2.
Which editors are supported?
The extension is officially supported in Visual Studio Code and the Cursor editor.
Added by AntSpace from public sources (getdbt.com).