Power User for dbt

Best dbt extension for VS Code / Cursor.

Develop, test, document and optimize dbt and SQL 3× faster with autocomplete, lineage, query preview, test and doc generation, and AI teammates.

Install the extension Read the FAQ

Datamates with AI Teammates

The Power User extension is part of the Datamates Platform. Datamates automates and accelerates data teams across platform engineering, data engineering, and analytics engineering through purpose-built AI teammates.

These teammates are available directly inside the extension, covering dbt model, doc, and test generation to SQL translation and explanation. They can be coached and personalized for your specific requirements. See coaching AI teammates to get started.

Setup

Install the extension and configure dbt Core, Cloud or Fusion.

Develop

Autocomplete, compiled SQL, model generation, optimize and translate.

Test

Query results, CTEs, the SQL visualizer, tests and column lineage.

Document

Write and generate documentation, with doc-block support.

Collaborate

Governance, notebooks, multi-project and query bookmarks.

Discover

Browser-based docs and column lineage from the SaaS UI.

Feature Comparison

The extension works great out of the box. Add a free Altimate API key to unlock the AI-powered features.

Power User for dbt Extension	With Altimate AI Key
SQL Visualizer	Datamates Platform
Data Lineage: Model Level	Data Lineage: Column Level
Auto-gen dbt from source	Query Explanation AI
Auto-complete code	Query Translation AI
Click to Run Models	Auto-gen dbt from SQL
Compiled SQL preview	Tests Generation AI
Preview query results	Documentation Generation AI
Defer to prod	Coach & Personalize AI Teammates
SQL validation without execution	Code Collaboration
—	Documentation Collaboration
—	Data Lineage Export
—	Data Lineage SaaS UI
—	Project Governance: VS Code
—	Project Governance: CI/CD
—	Project Governance: SaaS UI
—	dbt Docs SaaS UI
—	Query History & Bookmarks
—	Query Sharing

Support

The extension and Datamates Platform are developed and maintained by Altimate AI. Join the dbt Community Slack channel #tools-dbt-power-user to connect with other users.

If you run into issues, contact us via Slack or chat.