Accelerate dbt and SQL Development by 3x

The Power User extension is also available on Cursor! Click here to learn how to install the extension for Cursor.

Welcome to the docs for dbt Power User VSCode Extension, an open sourced extension created by Altimate AI.

It offers various features across three important phases of dbt and SQL work - develop, test, and collaborate.

Develop

Test

Collaborate

• SQL Visualizer
• Query Explanation
• Auto-gen dbt from source
• Auto-gen dbt from SQL
• Auto-complete code
• Click to Run Models
• Query Translation
• Compiled SQL preview

• Preview query results and analysis
• Tests Generation
• Column lineage with code visibility
• Defer to prod
• SQL validation without execution

• Collaboration workflows
• Documentation generation
• Project governance in IDE, Git, CI/CD
• SaaS UI for dbt docs and lineage
• Query history and Query bookmarks

DataMates with AI Teammates

The Power User extension is part of the DataMates Platform. DataMates Platform offers the functionality to automate and accelerate the work of data teams in various areas of platform engineering, data engineering, and analytics engineering. DataMates Platform consists of many AI teammates to help data teams with their work. For example, there is a documentation generator teammate that's specifically developed to handle data documentation work.

These AI teammates are available as part of the power user extension to offer the functionality ranging from dbt models, docs, tests generation to SQL translation & explanation. AI teammates can be coached by you and personalized for your specific requirements. To learn more - please check this section on coaching AI teammates.

Feature Comparison

The dbt Power User Extension has great features out of the box. Add a free Altimate api key to unlock all the features in "With Altimate AI Key" below.

dbt Power Users Extension

With Altimate AI Key

• SQL Visualizer
• Data Lineage: Model Level
• Auto-gen dbt from source
• Auto-complete code
• Click to Run Models
• Compiled SQL preview
• Preview query results and analysis
• Defer to prod
• SQL validation without execution

• MCP Server Tools
• Data Lineage: Column Level
• Query Explanation AI
• Query Translation AI
• Auto-gen dbt from SQL
• Tests Generation AI
• Documentation Generation AI
• Coach & Personalize AI Teammates
• 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 (dbt core or cloud)
• Query History
• Query Bookmarks
• Query Sharing

Support

Power user extension and DataMates Platform is developed and maintained by Altimate AI team. Please join the dbt Community Slack Channel #tools-dbt-power-user to meet with the community of users of the extension.

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