# 安装 io.github.us-all/dbt

- 类型: MCP 工具
- 说明: 解析 dbt 元数据与质量结果，帮助快速检查模型运行、来源与数据质量状态。
- 仓库: https://github.com/us-all/dbt-mcp-server
- ⚠ 安全: 该 MCP 工具来自官方 Registry 且开源、近期有维护，整体供应链可信度较好。其主要风险面来自本地执行 dbt 相关操作、访问项目与结果目录，以及可使用云/数据库凭证读写 BigQuery 或 Postgres，依据材料更适合评为需留意而非高风险。

## 方式一 · 一键代装（复制提示词让 AI 代劳）

### Claude Code
```
请帮我安装 askskill 上的 "io.github.us-all/dbt" MCP 服务：
执行：claude mcp add io-github-us-all-dbt -- npx -y @us-all/dbt-mcp
```

### Codex
```
请帮我安装 askskill 上的 "io.github.us-all/dbt" MCP 服务：
在 ~/.codex/config.toml 中添加：
[mcp_servers.io-github-us-all-dbt]
command = "npx"
args = ["-y","@us-all/dbt-mcp"]
然后重启 Codex 生效
```

### Cursor
```
请帮我安装 askskill 上的 "io.github.us-all/dbt" MCP 服务：
在 .cursor/mcp.json 的 "mcpServers" 中添加：
"io-github-us-all-dbt": { "command": "npx", "args": ["-y","@us-all/dbt-mcp"] }
然后在 Cursor 设置 > MCP 中启用
```

## 方式二 · 命令行安装（原生命令与配置）

### Claude Code
```bash
claude mcp add --env DBT_PROJECT_DIR=YOUR_VALUE --env DBT_TARGET_DIR=YOUR_VALUE --env DBT_RUN_HISTORY_DIR=YOUR_VALUE --env DQ_BACKEND=YOUR_VALUE --env DQ_RESULTS_TABLE=YOUR_VALUE --env DQ_SCORE_TABLE=YOUR_VALUE --env GOOGLE_APPLICATION_CREDENTIALS=YOUR_VALUE --env BQ_PROJECT_ID=YOUR_VALUE --env PG_CONNECTION_STRING=YOUR_VALUE --env DBT_ALLOW_WRITE=YOUR_VALUE --env DQ_SCHEMA=YOUR_VALUE --env DQ_COL_RUN_AT=YOUR_VALUE --env DQ_COL_CHECK_TYPE=YOUR_VALUE --env DQ_COL_STATUS=YOUR_VALUE --env DQ_COL_DATASET=YOUR_VALUE --env DQ_COL_TABLE_NAME=YOUR_VALUE --env DQ_COL_SEVERITY=YOUR_VALUE --env DQ_COL_FAILURE_COUNT=YOUR_VALUE --env DQ_COL_MESSAGE=YOUR_VALUE --env DQ_COL_CHECK_NAME=YOUR_VALUE --env DQ_COL_SCORE_DATE=YOUR_VALUE --env DQ_COL_SCOPE=YOUR_VALUE --env DQ_COL_TIER=YOUR_VALUE --env DQ_TIER1_TARGET_PCT=YOUR_VALUE --env DBT_SLA_CONFIG_PATH=YOUR_VALUE --env DBT_TOOLS=YOUR_VALUE --env DBT_DISABLE=YOUR_VALUE --transport stdio io-github-us-all-dbt -- npx -y @us-all/dbt-mcp
```
需要环境变量：DBT_PROJECT_DIR, DBT_TARGET_DIR, DBT_RUN_HISTORY_DIR, DQ_BACKEND, DQ_RESULTS_TABLE, DQ_SCORE_TABLE, GOOGLE_APPLICATION_CREDENTIALS, BQ_PROJECT_ID, PG_CONNECTION_STRING, DBT_ALLOW_WRITE, DQ_SCHEMA, DQ_COL_RUN_AT, DQ_COL_CHECK_TYPE, DQ_COL_STATUS, DQ_COL_DATASET, DQ_COL_TABLE_NAME, DQ_COL_SEVERITY, DQ_COL_FAILURE_COUNT, DQ_COL_MESSAGE, DQ_COL_CHECK_NAME, DQ_COL_SCORE_DATE, DQ_COL_SCOPE, DQ_COL_TIER, DQ_TIER1_TARGET_PCT, DBT_SLA_CONFIG_PATH, DBT_TOOLS, DBT_DISABLE

### Codex
```bash
codex mcp add --env DBT_PROJECT_DIR=YOUR_VALUE --env DBT_TARGET_DIR=YOUR_VALUE --env DBT_RUN_HISTORY_DIR=YOUR_VALUE --env DQ_BACKEND=YOUR_VALUE --env DQ_RESULTS_TABLE=YOUR_VALUE --env DQ_SCORE_TABLE=YOUR_VALUE --env GOOGLE_APPLICATION_CREDENTIALS=YOUR_VALUE --env BQ_PROJECT_ID=YOUR_VALUE --env PG_CONNECTION_STRING=YOUR_VALUE --env DBT_ALLOW_WRITE=YOUR_VALUE --env DQ_SCHEMA=YOUR_VALUE --env DQ_COL_RUN_AT=YOUR_VALUE --env DQ_COL_CHECK_TYPE=YOUR_VALUE --env DQ_COL_STATUS=YOUR_VALUE --env DQ_COL_DATASET=YOUR_VALUE --env DQ_COL_TABLE_NAME=YOUR_VALUE --env DQ_COL_SEVERITY=YOUR_VALUE --env DQ_COL_FAILURE_COUNT=YOUR_VALUE --env DQ_COL_MESSAGE=YOUR_VALUE --env DQ_COL_CHECK_NAME=YOUR_VALUE --env DQ_COL_SCORE_DATE=YOUR_VALUE --env DQ_COL_SCOPE=YOUR_VALUE --env DQ_COL_TIER=YOUR_VALUE --env DQ_TIER1_TARGET_PCT=YOUR_VALUE --env DBT_SLA_CONFIG_PATH=YOUR_VALUE --env DBT_TOOLS=YOUR_VALUE --env DBT_DISABLE=YOUR_VALUE io-github-us-all-dbt -- npx -y @us-all/dbt-mcp
```
配置文件 ~/.codex/config.toml：
```toml
[mcp_servers.io-github-us-all-dbt]
command = "npx"
args = ["-y","@us-all/dbt-mcp"]

[mcp_servers.io-github-us-all-dbt.env]
DBT_PROJECT_DIR = "YOUR_VALUE"
DBT_TARGET_DIR = "YOUR_VALUE"
DBT_RUN_HISTORY_DIR = "YOUR_VALUE"
DQ_BACKEND = "YOUR_VALUE"
DQ_RESULTS_TABLE = "YOUR_VALUE"
DQ_SCORE_TABLE = "YOUR_VALUE"
GOOGLE_APPLICATION_CREDENTIALS = "YOUR_VALUE"
BQ_PROJECT_ID = "YOUR_VALUE"
PG_CONNECTION_STRING = "YOUR_VALUE"
DBT_ALLOW_WRITE = "YOUR_VALUE"
DQ_SCHEMA = "YOUR_VALUE"
DQ_COL_RUN_AT = "YOUR_VALUE"
DQ_COL_CHECK_TYPE = "YOUR_VALUE"
DQ_COL_STATUS = "YOUR_VALUE"
DQ_COL_DATASET = "YOUR_VALUE"
DQ_COL_TABLE_NAME = "YOUR_VALUE"
DQ_COL_SEVERITY = "YOUR_VALUE"
DQ_COL_FAILURE_COUNT = "YOUR_VALUE"
DQ_COL_MESSAGE = "YOUR_VALUE"
DQ_COL_CHECK_NAME = "YOUR_VALUE"
DQ_COL_SCORE_DATE = "YOUR_VALUE"
DQ_COL_SCOPE = "YOUR_VALUE"
DQ_COL_TIER = "YOUR_VALUE"
DQ_TIER1_TARGET_PCT = "YOUR_VALUE"
DBT_SLA_CONFIG_PATH = "YOUR_VALUE"
DBT_TOOLS = "YOUR_VALUE"
DBT_DISABLE = "YOUR_VALUE"
```
需要环境变量：DBT_PROJECT_DIR, DBT_TARGET_DIR, DBT_RUN_HISTORY_DIR, DQ_BACKEND, DQ_RESULTS_TABLE, DQ_SCORE_TABLE, GOOGLE_APPLICATION_CREDENTIALS, BQ_PROJECT_ID, PG_CONNECTION_STRING, DBT_ALLOW_WRITE, DQ_SCHEMA, DQ_COL_RUN_AT, DQ_COL_CHECK_TYPE, DQ_COL_STATUS, DQ_COL_DATASET, DQ_COL_TABLE_NAME, DQ_COL_SEVERITY, DQ_COL_FAILURE_COUNT, DQ_COL_MESSAGE, DQ_COL_CHECK_NAME, DQ_COL_SCORE_DATE, DQ_COL_SCOPE, DQ_COL_TIER, DQ_TIER1_TARGET_PCT, DBT_SLA_CONFIG_PATH, DBT_TOOLS, DBT_DISABLE

### Cursor
配置文件 .cursor/mcp.json：
```json
{
  "mcpServers": {
    "io-github-us-all-dbt": {
      "command": "npx",
      "args": [
        "-y",
        "@us-all/dbt-mcp"
      ],
      "env": {
        "DBT_PROJECT_DIR": "YOUR_VALUE",
        "DBT_TARGET_DIR": "YOUR_VALUE",
        "DBT_RUN_HISTORY_DIR": "YOUR_VALUE",
        "DQ_BACKEND": "YOUR_VALUE",
        "DQ_RESULTS_TABLE": "YOUR_VALUE",
        "DQ_SCORE_TABLE": "YOUR_VALUE",
        "GOOGLE_APPLICATION_CREDENTIALS": "YOUR_VALUE",
        "BQ_PROJECT_ID": "YOUR_VALUE",
        "PG_CONNECTION_STRING": "YOUR_VALUE",
        "DBT_ALLOW_WRITE": "YOUR_VALUE",
        "DQ_SCHEMA": "YOUR_VALUE",
        "DQ_COL_RUN_AT": "YOUR_VALUE",
        "DQ_COL_CHECK_TYPE": "YOUR_VALUE",
        "DQ_COL_STATUS": "YOUR_VALUE",
        "DQ_COL_DATASET": "YOUR_VALUE",
        "DQ_COL_TABLE_NAME": "YOUR_VALUE",
        "DQ_COL_SEVERITY": "YOUR_VALUE",
        "DQ_COL_FAILURE_COUNT": "YOUR_VALUE",
        "DQ_COL_MESSAGE": "YOUR_VALUE",
        "DQ_COL_CHECK_NAME": "YOUR_VALUE",
        "DQ_COL_SCORE_DATE": "YOUR_VALUE",
        "DQ_COL_SCOPE": "YOUR_VALUE",
        "DQ_COL_TIER": "YOUR_VALUE",
        "DQ_TIER1_TARGET_PCT": "YOUR_VALUE",
        "DBT_SLA_CONFIG_PATH": "YOUR_VALUE",
        "DBT_TOOLS": "YOUR_VALUE",
        "DBT_DISABLE": "YOUR_VALUE"
      }
    }
  }
}
```
一键安装：cursor://anysphere.cursor-deeplink/mcp/install?name=io-github-us-all-dbt&config=eyJjb21tYW5kIjoibnB4IiwiYXJncyI6WyIteSIsIkB1cy1hbGwvZGJ0LW1jcCJdLCJlbnYiOnsiREJUX1BST0pFQ1RfRElSIjoiWU9VUl9WQUxVRSIsIkRCVF9UQVJHRVRfRElSIjoiWU9VUl9WQUxVRSIsIkRCVF9SVU5fSElTVE9SWV9ESVIiOiJZT1VSX1ZBTFVFIiwiRFFfQkFDS0VORCI6IllPVVJfVkFMVUUiLCJEUV9SRVNVTFRTX1RBQkxFIjoiWU9VUl9WQUxVRSIsIkRRX1NDT1JFX1RBQkxFIjoiWU9VUl9WQUxVRSIsIkdPT0dMRV9BUFBMSUNBVElPTl9DUkVERU5USUFMUyI6IllPVVJfVkFMVUUiLCJCUV9QUk9KRUNUX0lEIjoiWU9VUl9WQUxVRSIsIlBHX0NPTk5FQ1RJT05fU1RSSU5HIjoiWU9VUl9WQUxVRSIsIkRCVF9BTExPV19XUklURSI6IllPVVJfVkFMVUUiLCJEUV9TQ0hFTUEiOiJZT1VSX1ZBTFVFIiwiRFFfQ09MX1JVTl9BVCI6IllPVVJfVkFMVUUiLCJEUV9DT0xfQ0hFQ0tfVFlQRSI6IllPVVJfVkFMVUUiLCJEUV9DT0xfU1RBVFVTIjoiWU9VUl9WQUxVRSIsIkRRX0NPTF9EQVRBU0VUIjoiWU9VUl9WQUxVRSIsIkRRX0NPTF9UQUJMRV9OQU1FIjoiWU9VUl9WQUxVRSIsIkRRX0NPTF9TRVZFUklUWSI6IllPVVJfVkFMVUUiLCJEUV9DT0xfRkFJTFVSRV9DT1VOVCI6IllPVVJfVkFMVUUiLCJEUV9DT0xfTUVTU0FHRSI6IllPVVJfVkFMVUUiLCJEUV9DT0xfQ0hFQ0tfTkFNRSI6IllPVVJfVkFMVUUiLCJEUV9DT0xfU0NPUkVfREFURSI6IllPVVJfVkFMVUUiLCJEUV9DT0xfU0NPUEUiOiJZT1VSX1ZBTFVFIiwiRFFfQ09MX1RJRVIiOiJZT1VSX1ZBTFVFIiwiRFFfVElFUjFfVEFSR0VUX1BDVCI6IllPVVJfVkFMVUUiLCJEQlRfU0xBX0NPTkZJR19QQVRIIjoiWU9VUl9WQUxVRSIsIkRCVF9UT09MUyI6IllPVVJfVkFMVUUiLCJEQlRfRElTQUJMRSI6IllPVVJfVkFMVUUifX0
需要环境变量：DBT_PROJECT_DIR, DBT_TARGET_DIR, DBT_RUN_HISTORY_DIR, DQ_BACKEND, DQ_RESULTS_TABLE, DQ_SCORE_TABLE, GOOGLE_APPLICATION_CREDENTIALS, BQ_PROJECT_ID, PG_CONNECTION_STRING, DBT_ALLOW_WRITE, DQ_SCHEMA, DQ_COL_RUN_AT, DQ_COL_CHECK_TYPE, DQ_COL_STATUS, DQ_COL_DATASET, DQ_COL_TABLE_NAME, DQ_COL_SEVERITY, DQ_COL_FAILURE_COUNT, DQ_COL_MESSAGE, DQ_COL_CHECK_NAME, DQ_COL_SCORE_DATE, DQ_COL_SCOPE, DQ_COL_TIER, DQ_TIER1_TARGET_PCT, DBT_SLA_CONFIG_PATH, DBT_TOOLS, DBT_DISABLE