dbt
mcpkey · packagedbt MCP — manifest/run_results/sources/catalog parsing + DQ result tables (BigQuery/Postgres)
run it
on your own machines, one way per deploy method#!/usr/bin/env bash # dbt (io.github.us-all/dbt), recipe baremetal (generated). # Generated by Hub for toolset "my-agent"; started by mcp-my-agent-dbt.service. set -euo pipefail export HOST=127.0.0.1 PORT=8101 exec npx -y supergateway@4 --stdio 'npx -y @us-all/[email protected]' --outputTransport streamableHttp --stateful --host 127.0.0.1 --port 8101 --streamableHttpPath /mcp --healthEndpoint /healthz [Unit] Description=MCP server dbt (toolset my-agent), generated by Hub After=network-online.target Wants=network-online.target [Service] Type=simple User=mcp Group=mcp EnvironmentFile=/etc/mcp/my-agent.env Environment=HOME=/var/lib/mcp/dbt WorkingDirectory=/var/lib/mcp/dbt ExecStart=/opt/mcp/my-agent/bin/dbt.sh Restart=on-failure RestartSec=5 NoNewPrivileges=true ProtectSystem=strict ProtectHome=true PrivateTmp=true ReadWritePaths=/var/lib/mcp/dbt [Install] WantedBy=multi-user.target
docker run --rm -p 127.0.0.1:8101:8000 -e DBT_PROJECT_DIR -e DBT_TARGET_DIR -e DBT_RUN_HISTORY_DIR -e DQ_BACKEND -e DQ_RESULTS_TABLE -e DQ_SCORE_TABLE -e GOOGLE_APPLICATION_CREDENTIALS -e BQ_PROJECT_ID -e PG_CONNECTION_STRING -e DBT_ALLOW_WRITE -e DQ_SCHEMA -e DQ_COL_RUN_AT -e DQ_COL_CHECK_TYPE -e DQ_COL_STATUS -e DQ_COL_DATASET -e DQ_COL_TABLE_NAME -e DQ_COL_SEVERITY -e DQ_COL_FAILURE_COUNT -e DQ_COL_MESSAGE -e DQ_COL_CHECK_NAME -e DQ_COL_SCORE_DATE -e DQ_COL_SCOPE -e DQ_COL_TIER -e DQ_TIER1_TARGET_PCT -e DBT_SLA_CONFIG_PATH -e DBT_TOOLS -e DBT_DISABLE node:22-alpine sh -c 'npx -y supergateway@4 --stdio '"'"'npx -y @us-all/[email protected]'"'"' --outputTransport streamableHttp --stateful --host 0.0.0.0 --port 8000 --streamableHttpPath /mcp --healthEndpoint /healthz'
# Generated by Hub for toolset "my-agent" (2026-10-18T08:02:13+00:00).
# Each package server runs behind a stdio->HTTP bridge and listens on localhost only.
# cp .env.example .env # fill the ${VAR}s
# docker compose up -d && bash smoke.sh
# Remote servers are not here: clients reach them directly (see clients/).
name: mcp-my-agent
services:
dbt:
image: node:22-alpine
command:
- sh
- -c
- npx -y supergateway@4 --stdio 'npx -y @us-all/[email protected]' --outputTransport streamableHttp --stateful
--host 0.0.0.0 --port 8000 --streamableHttpPath /mcp --healthEndpoint /healthz
ports:
- 127.0.0.1:8101:8000
volumes:
- npm-cache:/root/.npm
healthcheck:
test:
- CMD-SHELL
- wget -qO- http://127.0.0.1:8000/healthz || exit 1
interval: 30s
timeout: 5s
retries: 5
start_period: 2m
restart: unless-stopped
environment:
DBT_PROJECT_DIR: ${DBT_PROJECT_DIR}
DBT_TARGET_DIR: ${DBT_TARGET_DIR}
DBT_RUN_HISTORY_DIR: ${DBT_RUN_HISTORY_DIR}
DQ_BACKEND: ${DQ_BACKEND}
DQ_RESULTS_TABLE: ${DQ_RESULTS_TABLE}
DQ_SCORE_TABLE: ${DQ_SCORE_TABLE}
GOOGLE_APPLICATION_CREDENTIALS: ${GOOGLE_APPLICATION_CREDENTIALS}
BQ_PROJECT_ID: ${BQ_PROJECT_ID}
PG_CONNECTION_STRING: ${PG_CONNECTION_STRING}
DBT_ALLOW_WRITE: ${DBT_ALLOW_WRITE}
DQ_SCHEMA: ${DQ_SCHEMA}
DQ_COL_RUN_AT: ${DQ_COL_RUN_AT}
DQ_COL_CHECK_TYPE: ${DQ_COL_CHECK_TYPE}
DQ_COL_STATUS: ${DQ_COL_STATUS}
DQ_COL_DATASET: ${DQ_COL_DATASET}
DQ_COL_TABLE_NAME: ${DQ_COL_TABLE_NAME}
DQ_COL_SEVERITY: ${DQ_COL_SEVERITY}
DQ_COL_FAILURE_COUNT: ${DQ_COL_FAILURE_COUNT}
DQ_COL_MESSAGE: ${DQ_COL_MESSAGE}
DQ_COL_CHECK_NAME: ${DQ_COL_CHECK_NAME}
DQ_COL_SCORE_DATE: ${DQ_COL_SCORE_DATE}
DQ_COL_SCOPE: ${DQ_COL_SCOPE}
DQ_COL_TIER: ${DQ_COL_TIER}
DQ_TIER1_TARGET_PCT: ${DQ_TIER1_TARGET_PCT}
DBT_SLA_CONFIG_PATH: ${DBT_SLA_CONFIG_PATH}
DBT_TOOLS: ${DBT_TOOLS}
DBT_DISABLE: ${DBT_DISABLE}
volumes:
npm-cache: {}
uv-cache: {}
# Generated by Hub for toolset "my-agent" (2026-10-18T08:02:13+00:00).
# kubectl create namespace mcp
# kubectl -n mcp create secret generic mcp-credentials --from-env-file=.env
# kubectl apply -f kubernetes.yaml
# Services are cluster-internal: <name>.mcp.svc.cluster.local:8000/mcp. Put an ingress
# with auth in front before exposing any of them.
apiVersion: v1
kind: Namespace
metadata:
name: mcp
---
apiVersion: apps/v1
kind: Deployment
metadata:
name: dbt
namespace: mcp
labels: &id001
app: dbt
spec:
replicas: 1
selector:
matchLabels: *id001
template:
metadata:
labels: *id001
spec:
containers:
- name: dbt
image: node:22-alpine
ports:
- containerPort: 8000
name: http
env:
- name: DBT_PROJECT_DIR
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DBT_PROJECT_DIR
- name: DBT_TARGET_DIR
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DBT_TARGET_DIR
- name: DBT_RUN_HISTORY_DIR
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DBT_RUN_HISTORY_DIR
- name: DQ_BACKEND
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DQ_BACKEND
- name: DQ_RESULTS_TABLE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DQ_RESULTS_TABLE
- name: DQ_SCORE_TABLE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DQ_SCORE_TABLE
- name: GOOGLE_APPLICATION_CREDENTIALS
valueFrom:
secretKeyRef:
name: mcp-credentials
key: GOOGLE_APPLICATION_CREDENTIALS
- name: BQ_PROJECT_ID
valueFrom:
secretKeyRef:
name: mcp-credentials
key: BQ_PROJECT_ID
- name: PG_CONNECTION_STRING
valueFrom:
secretKeyRef:
name: mcp-credentials
key: PG_CONNECTION_STRING
- name: DBT_ALLOW_WRITE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DBT_ALLOW_WRITE
- name: DQ_SCHEMA
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DQ_SCHEMA
- name: DQ_COL_RUN_AT
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DQ_COL_RUN_AT
- name: DQ_COL_CHECK_TYPE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DQ_COL_CHECK_TYPE
- name: DQ_COL_STATUS
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DQ_COL_STATUS
- name: DQ_COL_DATASET
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DQ_COL_DATASET
- name: DQ_COL_TABLE_NAME
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DQ_COL_TABLE_NAME
- name: DQ_COL_SEVERITY
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DQ_COL_SEVERITY
- name: DQ_COL_FAILURE_COUNT
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DQ_COL_FAILURE_COUNT
- name: DQ_COL_MESSAGE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DQ_COL_MESSAGE
- name: DQ_COL_CHECK_NAME
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DQ_COL_CHECK_NAME
- name: DQ_COL_SCORE_DATE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DQ_COL_SCORE_DATE
- name: DQ_COL_SCOPE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DQ_COL_SCOPE
- name: DQ_COL_TIER
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DQ_COL_TIER
- name: DQ_TIER1_TARGET_PCT
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DQ_TIER1_TARGET_PCT
- name: DBT_SLA_CONFIG_PATH
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DBT_SLA_CONFIG_PATH
- name: DBT_TOOLS
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DBT_TOOLS
- name: DBT_DISABLE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DBT_DISABLE
command:
- sh
- -c
- npx -y supergateway@4 --stdio 'npx -y @us-all/[email protected]' --outputTransport streamableHttp
--stateful --host 0.0.0.0 --port 8000 --streamableHttpPath /mcp --healthEndpoint /healthz
readinessProbe:
httpGet:
path: /healthz
port: http
initialDelaySeconds: 10
---
apiVersion: v1
kind: Service
metadata:
name: dbt
namespace: mcp
spec:
selector:
app: dbt
ports:
- port: 8000
targetPort: http
name: http
# Generated by Hub for toolset "my-agent" (2026-10-18T08:02:13+00:00).
# Credentials come from the Secret 'mcp-credentials' (kubectl create secret generic ... --from-env-file=.env).
# Each server under `servers` is one Deployment + Service; the keys after it configure
# upstream charts a worker verified.
servers:
dbt:
enabled: true
replicas: 1
port: 8000
path: /mcp
container:
name: dbt
image: node:22-alpine
ports:
- containerPort: 8000
name: http
env:
- name: DBT_PROJECT_DIR
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DBT_PROJECT_DIR
- name: DBT_TARGET_DIR
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DBT_TARGET_DIR
- name: DBT_RUN_HISTORY_DIR
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DBT_RUN_HISTORY_DIR
- name: DQ_BACKEND
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DQ_BACKEND
- name: DQ_RESULTS_TABLE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DQ_RESULTS_TABLE
- name: DQ_SCORE_TABLE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DQ_SCORE_TABLE
- name: GOOGLE_APPLICATION_CREDENTIALS
valueFrom:
secretKeyRef:
name: mcp-credentials
key: GOOGLE_APPLICATION_CREDENTIALS
- name: BQ_PROJECT_ID
valueFrom:
secretKeyRef:
name: mcp-credentials
key: BQ_PROJECT_ID
- name: PG_CONNECTION_STRING
valueFrom:
secretKeyRef:
name: mcp-credentials
key: PG_CONNECTION_STRING
- name: DBT_ALLOW_WRITE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DBT_ALLOW_WRITE
- name: DQ_SCHEMA
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DQ_SCHEMA
- name: DQ_COL_RUN_AT
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DQ_COL_RUN_AT
- name: DQ_COL_CHECK_TYPE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DQ_COL_CHECK_TYPE
- name: DQ_COL_STATUS
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DQ_COL_STATUS
- name: DQ_COL_DATASET
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DQ_COL_DATASET
- name: DQ_COL_TABLE_NAME
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DQ_COL_TABLE_NAME
- name: DQ_COL_SEVERITY
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DQ_COL_SEVERITY
- name: DQ_COL_FAILURE_COUNT
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DQ_COL_FAILURE_COUNT
- name: DQ_COL_MESSAGE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DQ_COL_MESSAGE
- name: DQ_COL_CHECK_NAME
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DQ_COL_CHECK_NAME
- name: DQ_COL_SCORE_DATE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DQ_COL_SCORE_DATE
- name: DQ_COL_SCOPE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DQ_COL_SCOPE
- name: DQ_COL_TIER
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DQ_COL_TIER
- name: DQ_TIER1_TARGET_PCT
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DQ_TIER1_TARGET_PCT
- name: DBT_SLA_CONFIG_PATH
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DBT_SLA_CONFIG_PATH
- name: DBT_TOOLS
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DBT_TOOLS
- name: DBT_DISABLE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DBT_DISABLE
command:
- sh
- -c
- npx -y supergateway@4 --stdio 'npx -y @us-all/[email protected]' --outputTransport streamableHttp
--stateful --host 0.0.0.0 --port 8000 --streamableHttpPath /mcp --healthEndpoint /healthz
readinessProbe:
httpGet:
path: /healthz
port: http
initialDelaySeconds: 10
# helm install my-agent helm/my-agent -n mcp
in the cloud
one click: the provider's deploy form opens filled in, in your own account- koyeb
-
The form opens with CHANGE_ME for each value you supply: 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. Fill them in before you deploy.
Clients connect to the service's https://…koyeb.app address plus /mcp.
- azure
-
A Container Apps environment with one app per server, each with HTTPS ingress and one replica. The portal asks for each value you supply as a secure parameter; the deployment's outputs list the endpoints.
connect to it
copy what your client needsnpx -y @us-all/[email protected] # env: 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
{
"mcpServers": {
"dbt": {
"command": "npx",
"args": [
"-y",
"@us-all/[email protected]"
],
"env": {
"DBT_PROJECT_DIR": "${DBT_PROJECT_DIR}",
"DBT_TARGET_DIR": "${DBT_TARGET_DIR}",
"DBT_RUN_HISTORY_DIR": "${DBT_RUN_HISTORY_DIR}",
"DQ_BACKEND": "${DQ_BACKEND}",
"DQ_RESULTS_TABLE": "${DQ_RESULTS_TABLE}",
"DQ_SCORE_TABLE": "${DQ_SCORE_TABLE}",
"GOOGLE_APPLICATION_CREDENTIALS": "${GOOGLE_APPLICATION_CREDENTIALS}",
"BQ_PROJECT_ID": "${BQ_PROJECT_ID}",
"PG_CONNECTION_STRING": "${PG_CONNECTION_STRING}",
"DBT_ALLOW_WRITE": "${DBT_ALLOW_WRITE}",
"DQ_SCHEMA": "${DQ_SCHEMA}",
"DQ_COL_RUN_AT": "${DQ_COL_RUN_AT}",
"DQ_COL_CHECK_TYPE": "${DQ_COL_CHECK_TYPE}",
"DQ_COL_STATUS": "${DQ_COL_STATUS}",
"DQ_COL_DATASET": "${DQ_COL_DATASET}",
"DQ_COL_TABLE_NAME": "${DQ_COL_TABLE_NAME}",
"DQ_COL_SEVERITY": "${DQ_COL_SEVERITY}",
"DQ_COL_FAILURE_COUNT": "${DQ_COL_FAILURE_COUNT}",
"DQ_COL_MESSAGE": "${DQ_COL_MESSAGE}",
"DQ_COL_CHECK_NAME": "${DQ_COL_CHECK_NAME}",
"DQ_COL_SCORE_DATE": "${DQ_COL_SCORE_DATE}",
"DQ_COL_SCOPE": "${DQ_COL_SCOPE}",
"DQ_COL_TIER": "${DQ_COL_TIER}",
"DQ_TIER1_TARGET_PCT": "${DQ_TIER1_TARGET_PCT}",
"DBT_SLA_CONFIG_PATH": "${DBT_SLA_CONFIG_PATH}",
"DBT_TOOLS": "${DBT_TOOLS}",
"DBT_DISABLE": "${DBT_DISABLE}"
}
}
}
}
#!/usr/bin/env bash
# Registers every server with Claude Code (run once; `claude mcp list` to check).
set -euo pipefail
set -a; [ -f .env ] && source .env; set +a
claude mcp add dbt -e "DBT_PROJECT_DIR=${DBT_PROJECT_DIR}" -e "DBT_TARGET_DIR=${DBT_TARGET_DIR}" -e "DBT_RUN_HISTORY_DIR=${DBT_RUN_HISTORY_DIR}" -e "DQ_BACKEND=${DQ_BACKEND}" -e "DQ_RESULTS_TABLE=${DQ_RESULTS_TABLE}" -e "DQ_SCORE_TABLE=${DQ_SCORE_TABLE}" -e "GOOGLE_APPLICATION_CREDENTIALS=${GOOGLE_APPLICATION_CREDENTIALS}" -e "BQ_PROJECT_ID=${BQ_PROJECT_ID}" -e "PG_CONNECTION_STRING=${PG_CONNECTION_STRING}" -e "DBT_ALLOW_WRITE=${DBT_ALLOW_WRITE}" -e "DQ_SCHEMA=${DQ_SCHEMA}" -e "DQ_COL_RUN_AT=${DQ_COL_RUN_AT}" -e "DQ_COL_CHECK_TYPE=${DQ_COL_CHECK_TYPE}" -e "DQ_COL_STATUS=${DQ_COL_STATUS}" -e "DQ_COL_DATASET=${DQ_COL_DATASET}" -e "DQ_COL_TABLE_NAME=${DQ_COL_TABLE_NAME}" -e "DQ_COL_SEVERITY=${DQ_COL_SEVERITY}" -e "DQ_COL_FAILURE_COUNT=${DQ_COL_FAILURE_COUNT}" -e "DQ_COL_MESSAGE=${DQ_COL_MESSAGE}" -e "DQ_COL_CHECK_NAME=${DQ_COL_CHECK_NAME}" -e "DQ_COL_SCORE_DATE=${DQ_COL_SCORE_DATE}" -e "DQ_COL_SCOPE=${DQ_COL_SCOPE}" -e "DQ_COL_TIER=${DQ_COL_TIER}" -e "DQ_TIER1_TARGET_PCT=${DQ_TIER1_TARGET_PCT}" -e "DBT_SLA_CONFIG_PATH=${DBT_SLA_CONFIG_PATH}" -e "DBT_TOOLS=${DBT_TOOLS}" -e "DBT_DISABLE=${DBT_DISABLE}" -- npx -y @us-all/[email protected]
{
"mcpServers": {
"dbt": {
"command": "npx",
"args": [
"-y",
"@us-all/[email protected]"
],
"env": {
"DBT_PROJECT_DIR": "${DBT_PROJECT_DIR}",
"DBT_TARGET_DIR": "${DBT_TARGET_DIR}",
"DBT_RUN_HISTORY_DIR": "${DBT_RUN_HISTORY_DIR}",
"DQ_BACKEND": "${DQ_BACKEND}",
"DQ_RESULTS_TABLE": "${DQ_RESULTS_TABLE}",
"DQ_SCORE_TABLE": "${DQ_SCORE_TABLE}",
"GOOGLE_APPLICATION_CREDENTIALS": "${GOOGLE_APPLICATION_CREDENTIALS}",
"BQ_PROJECT_ID": "${BQ_PROJECT_ID}",
"PG_CONNECTION_STRING": "${PG_CONNECTION_STRING}",
"DBT_ALLOW_WRITE": "${DBT_ALLOW_WRITE}",
"DQ_SCHEMA": "${DQ_SCHEMA}",
"DQ_COL_RUN_AT": "${DQ_COL_RUN_AT}",
"DQ_COL_CHECK_TYPE": "${DQ_COL_CHECK_TYPE}",
"DQ_COL_STATUS": "${DQ_COL_STATUS}",
"DQ_COL_DATASET": "${DQ_COL_DATASET}",
"DQ_COL_TABLE_NAME": "${DQ_COL_TABLE_NAME}",
"DQ_COL_SEVERITY": "${DQ_COL_SEVERITY}",
"DQ_COL_FAILURE_COUNT": "${DQ_COL_FAILURE_COUNT}",
"DQ_COL_MESSAGE": "${DQ_COL_MESSAGE}",
"DQ_COL_CHECK_NAME": "${DQ_COL_CHECK_NAME}",
"DQ_COL_SCORE_DATE": "${DQ_COL_SCORE_DATE}",
"DQ_COL_SCOPE": "${DQ_COL_SCOPE}",
"DQ_COL_TIER": "${DQ_COL_TIER}",
"DQ_TIER1_TARGET_PCT": "${DQ_TIER1_TARGET_PCT}",
"DBT_SLA_CONFIG_PATH": "${DBT_SLA_CONFIG_PATH}",
"DBT_TOOLS": "${DBT_TOOLS}",
"DBT_DISABLE": "${DBT_DISABLE}"
}
}
}
}
{
"servers": {
"dbt": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@us-all/[email protected]"
],
"env": {
"DBT_PROJECT_DIR": "${DBT_PROJECT_DIR}",
"DBT_TARGET_DIR": "${DBT_TARGET_DIR}",
"DBT_RUN_HISTORY_DIR": "${DBT_RUN_HISTORY_DIR}",
"DQ_BACKEND": "${DQ_BACKEND}",
"DQ_RESULTS_TABLE": "${DQ_RESULTS_TABLE}",
"DQ_SCORE_TABLE": "${DQ_SCORE_TABLE}",
"GOOGLE_APPLICATION_CREDENTIALS": "${GOOGLE_APPLICATION_CREDENTIALS}",
"BQ_PROJECT_ID": "${BQ_PROJECT_ID}",
"PG_CONNECTION_STRING": "${PG_CONNECTION_STRING}",
"DBT_ALLOW_WRITE": "${DBT_ALLOW_WRITE}",
"DQ_SCHEMA": "${DQ_SCHEMA}",
"DQ_COL_RUN_AT": "${DQ_COL_RUN_AT}",
"DQ_COL_CHECK_TYPE": "${DQ_COL_CHECK_TYPE}",
"DQ_COL_STATUS": "${DQ_COL_STATUS}",
"DQ_COL_DATASET": "${DQ_COL_DATASET}",
"DQ_COL_TABLE_NAME": "${DQ_COL_TABLE_NAME}",
"DQ_COL_SEVERITY": "${DQ_COL_SEVERITY}",
"DQ_COL_FAILURE_COUNT": "${DQ_COL_FAILURE_COUNT}",
"DQ_COL_MESSAGE": "${DQ_COL_MESSAGE}",
"DQ_COL_CHECK_NAME": "${DQ_COL_CHECK_NAME}",
"DQ_COL_SCORE_DATE": "${DQ_COL_SCORE_DATE}",
"DQ_COL_SCOPE": "${DQ_COL_SCOPE}",
"DQ_COL_TIER": "${DQ_COL_TIER}",
"DQ_TIER1_TARGET_PCT": "${DQ_TIER1_TARGET_PCT}",
"DBT_SLA_CONFIG_PATH": "${DBT_SLA_CONFIG_PATH}",
"DBT_TOOLS": "${DBT_TOOLS}",
"DBT_DISABLE": "${DBT_DISABLE}"
}
}
}
}
name: my-agent target: local servers: - hub: io.github.us-all/dbt
- not probed yet: tools unpinned, ingest lists them