Power user VSCode extension is open source (code repo), and it's listed on the VSCode Marketplace.

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

Accelerate dbt and SQL Development by 2X

Develop

Test

Collaborate

• Generate dbt model from source or SQL
• Smart-complete code and Click to Run Models
• Query explanation
• Query translation
• Compiled SQL preview and SQL Visualizer

• 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

DataPilot with AI Teammates

Power user extension is part of the DataPilot platform. DataPilot platform offers the functionlity to automate and accelerate the work of data teams in various areas of platform engineering, data engineering, and analytics engineering. DataPilot 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

Support

Power user extension and DataPilot platform is developed and mainted 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