Skip to content
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

Workspaces with AI Teammates

The Power User extension is part of the Workspaces Platform. Workspaces automate and accelerate 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 SaaS-backed features — governance, column lineage, collaboration, and the AI teammates — all under a single key.

Features are grouped by what each tier requires:

  • Local-only — nothing leaves your machine; no key needed.
  • Free with Altimate key — needs an Altimate API key but no AI credits.
  • AI-powered — uses AI.
Local-only (no key) Free with Altimate key AI-powered
Autocomplete code Sign in with Altimate Documentation Generation AI
Compiled SQL preview User-level collaboration Tests Generation AI
Click to Run Models Defer to prod Query Explanation AI
Run tests Project Governance (VS Code) Optimize SQL with Altimate
Auto-gen dbt from source Project Governance (CI/CD) Query Translation AI
Preview query results Project Governance (SaaS UI) Auto-gen dbt from SQL
Run ad hoc query SQL Visualizer Chat about model / column
Download CSV / Copy as JSON Data Lineage: Column Level Coach & Personalize AI Teammates
SQL validation without execution Data Lineage Export Add Governance checks in natural language
Data Lineage: Model Level Data Lineage SaaS UI Altimate Code — anywhere it is used
CTE Profiler dbt Docs SaaS UI —
BigQuery cost estimator Code Collaboration —
Query History tree Documentation Collaboration —
Native dbt Docs viewer Query History & Bookmarks —
Setup wizard, Diagnostics, utility commands Query Sharing —

Other Altimate products

Support

The extension and Workspaces 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.