Execute dbt models to transform data and build analytical tables in a data warehouse. Use this to refresh data or implement new data transformations in a dbt project, returning command output as text.
Install or update external package dependencies for a dbt project. Ensures required modules, macros, and models are available before project execution.
Generate SQL from dbt models to validate syntax, preview transformations, or explore model interpretations without executing queries against the database.
Validate data quality and integrity by running tests in a dbt project. Ensures data transformations meet business rules and constraints for accurate analysis and reporting.
Validate dbt project setup by troubleshooting configurations, checking database connectivity, and ensuring dependencies are installed correctly. Essential for diagnosing issues before running models or tests.
Discover and list dbt project resources like models, tests, and sources using JSON or text outputs to understand project structure, identify dependencies, and select resources for operations such as running or testing.
Provides intelligent dbt assistance through Claude Code integration, enabling users to perform dbt CLI operations, explore project metadata, and execute SQL queries against DuckDB warehouse with context-aware support.