🔄
dbt
Data Transformation Database & StorageInstall Command
npx clawhub@latest install dbt
Installation Guide
1
Check Environment
Make sure Node.js 22+ and OpenClaw are installed. Run openclaw --version in your terminal to verify.
2
Run Installation
Run the install command above in your terminal. ClawHub will automatically download and install dbt to the ~/.openclaw/skills/ directory.
3
Verify Installation
Run openclaw skills list to check your installed skills and confirm dbt appears in the list.
4
Configure (Optional)
Follow the configuration instructions in the description below to add skill settings to ~/.config/openclaw/openclaw.json5.
Manual Installation: Copy the Skill folder to
~/.openclaw/skills/ or the skills/ directory in your project root. Make sure the folder contains a SKILL.md file.
Query dbt project models and metadata
Execute data transformation tasks
Access dbt semantic layer metrics
Detailed Description
dbt MCP Server integrates the dbt (Data Build Tool) data transformation platform into AI, enabling you to query data models and execute data transformation tasks using natural language.
Core Features
- Model Querying: Browse model definitions, dependency graphs, and documentation within dbt projects
- Semantic Layer Access: Query pre-defined metrics and dimensions through the dbt Semantic Layer
- Task Execution: Trigger dbt run, test, and other commands, view run results and logs
Configuration
{
"mcpServers": {
"dbt": {
"command": "npx",
"args": ["-y", "mcp-dbt"],
"env": {
"DBT_HOST": "dbt Cloud host address",
"DBT_TOKEN": "API token",
"DBT_ACCOUNT_ID": "Account ID"
}
}
}
}
Use Cases
- Quickly understand model lineage and dependency graphs within dbt projects
- Query business metrics defined in the semantic layer using natural language
- Check data quality test results and locate data anomalies
- Understand data model definitions and business meanings