dbt

Name: dbt
Author: us-all

Community

MCP server by us-all · updated 3 months ago · ★ 0

Score 24

dbt MCP — manifest/run_results/sources/catalog parsing + DQ result tables (BigQuery/Postgres) dbt is a community project by us-all, not verified by a company domain.

Install Add to Cursor Add to VS Code GitHub

Yours? Claim it

Works withClaude Code Claude Desktop Cursor Codex Gemini CLI VS Code Windsurf Antigravity CLI

Install dbt

Built from the published package, never by AI

claude mcp add dbt -e DBT_PROJECT_DIR=YOUR_DBT_PROJECT_DIR -- npx -y @us-all/dbt-mcp

Run in your terminal. Add --scope user to use it in every project.

Step-by-step: install dbt in Claude Code

{
  "mcpServers": {
    "dbt": {
      "command": "npx",
      "args": [
        "-y",
        "@us-all/dbt-mcp"
      ],
      "env": {
        "DBT_PROJECT_DIR": "YOUR_DBT_PROJECT_DIR"
      }
    }
  }
}

Settings, Developer, Edit config. Paste into claude_desktop_config.json and restart.

Step-by-step: install dbt in Claude Desktop

{
  "mcpServers": {
    "dbt": {
      "command": "npx",
      "args": [
        "-y",
        "@us-all/dbt-mcp"
      ],
      "env": {
        "DBT_PROJECT_DIR": "YOUR_DBT_PROJECT_DIR"
      }
    }
  }
}

Add to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (this project).

Step-by-step: install dbt in Cursor

{
  "servers": {
    "dbt": {
      "command": "npx",
      "args": [
        "-y",
        "@us-all/dbt-mcp"
      ],
      "env": {
        "DBT_PROJECT_DIR": "YOUR_DBT_PROJECT_DIR"
      }
    }
  }
}

Add to .vscode/mcp.json. VS Code uses "servers", not "mcpServers".

Step-by-step: install dbt in VS Code

codex mcp add dbt --env DBT_PROJECT_DIR=YOUR_DBT_PROJECT_DIR -- npx -y @us-all/dbt-mcp

Step-by-step: install dbt in Codex

{
  "mcpServers": {
    "dbt": {
      "command": "npx",
      "args": [
        "-y",
        "@us-all/dbt-mcp"
      ],
      "env": {
        "DBT_PROJECT_DIR": "YOUR_DBT_PROJECT_DIR"
      }
    }
  }
}

Add to ~/.gemini/config/mcp_config.json (all projects) or .agents/mcp_config.json (this project).

Step-by-step: install dbt in Antigravity CLI

gemini mcp add dbt npx -y @us-all/dbt-mcp

Gemini CLI was replaced by Antigravity CLI in June 2026 and remains only for enterprise licences and paid API keys.

Step-by-step: install dbt in Gemini CLI

MCP servers run with your permissions and can read what you give them access to. Some need an API key: check the README and add it under env in the dbt block.

Maintenance

Last commit 106 days ago

Licence

MIT: permissive, fine for commercial use

Quality

Clear description, published package or server URL, original repository

Security

Not checked yet. What we check

What you need

Setting	Needed	What it is
`DBT_PROJECT_DIR`Environment variable	Required	Path to dbt project root (where dbt_project.yml lives).
`DBT_TARGET_DIR`Environment variable	Optional	dbt target dir for manifest.json/run_results.json (default: $DBT_PROJECT_DIR/target).
`DBT_RUN_HISTORY_DIR`Environment variable	Optional	Optional dir for archived run_results.json history (glob-scanned).
`DQ_BACKEND`Environment variable	Optional	DQ result table backend: 'bigquery' (default) or 'postgres'.
`DQ_RESULTS_TABLE`Environment variable	Optional	Fully qualified DQ checks table, e.g. 'project.data_ops.quality_checks'.
`DQ_SCORE_TABLE`Environment variable	Optional	Fully qualified DQ score-daily table, e.g. 'project.data_ops.quality_score_daily'.
`GOOGLE_APPLICATION_CREDENTIALS`Environment variable	Optional	Service account key path for BigQuery (ADC fallback supported).
`BQ_PROJECT_ID`Environment variable	Optional	Explicit BigQuery project ID for DQ queries.
`PG_CONNECTION_STRING`Environment variable, secret	Optional	Postgres connection string when DQ_BACKEND=postgres.
`DBT_ALLOW_WRITE`Environment variable	Optional	Reserved for future write tools. Default read-only. Default: `false`
`DQ_SCHEMA`Environment variable	Optional	DQ result-table schema preset: 'generic' (default) or 'us-all'. Use DQ_COL_* env vars to override individual columns on top of the preset. Default: `generic`
`DQ_COL_RUN_AT`Environment variable	Optional	Override for the timestamp/date column on the DQ checks table. Default depends on DQ_SCHEMA preset.
`DQ_COL_CHECK_TYPE`Environment variable	Optional	Override for the check-type column on the DQ checks table. Default 'check_type'.
`DQ_COL_STATUS`Environment variable	Optional	Override for the status column on the DQ checks table. Default 'status'.
`DQ_COL_DATASET`Environment variable	Optional	Override for the dataset/source column on the DQ checks table. Default depends on preset.
`DQ_COL_TABLE_NAME`Environment variable	Optional	Override for the table/target-name column on the DQ checks table. Default depends on preset.
`DQ_COL_SEVERITY`Environment variable	Optional	Override for the severity/dimension column on the DQ checks table. Default depends on preset.
`DQ_COL_FAILURE_COUNT`Environment variable	Optional	Override for the numeric failure-count column on the DQ checks table. Default depends on preset.
`DQ_COL_MESSAGE`Environment variable	Optional	Override for the message column on the DQ checks table. Default depends on preset.
`DQ_COL_CHECK_NAME`Environment variable	Optional	Override for the check_name column on the DQ checks table. Set to 'none'/'null'/'-' to synthesize check_name from check_type and table_name.

From the publisher's entry in the official MCP Registry. Required settings are already in the install config below as placeholders.

Weekly newsletter

Like dbt? Get the best new MCP servers every week

The best new tools, security warnings before you install something risky, and one practical tip. Free, three minute read.

Alternatives to dbt

All alternatives →

Supabase supabase

MCP server for interacting with the Supabase platform

AAB Local and remote 68k/wk

ArcadeDB MCP Server ArcadeData

Built-in MCP server for ArcadeDB multi-model database (graph, document, vector, time-series)

AAA Local 1.2k

MCP Toolbox for Databasesgoogleapis

MCP Toolbox for Databases enables your agent to connect to your database.

AAA Local 17k

MCP Toolbox for Databasesgoogleapis

MCP Toolbox for Databases enables your agent to connect to your database.

AAA Local 17k

mcpkubeshark

Real-time Kubernetes network traffic visibility and API analysis for HTTP, gRPC, Redis, Kafka, DNS.

AAA Local 12k

Ruvector ruvnet

Self-learning vector database for Node.js — hybrid search, Graph RAG, FlashAttention-3, HNSW, 50+ attention mechanisms

AAA Local 59k/wk

dbt vs Supabase dbt vs ArcadeDB MCP Server dbt vs MCP Toolbox for Databases

dbt: common questions

How do I install dbt?

In Claude Code run claude mcp add dbt -e DBT_PROJECT_DIR=YOUR_DBT_PROJECT_DIR -- npx -y @us-all/dbt-mcp. For Claude Desktop, Cursor and VS Code, paste the config shown above and restart. See the install guides.

Is dbt the official server?

dbt is a community project by us-all, not verified by a company domain.

Is dbt free?

The code is published under the MIT licence. The service it connects to may have its own pricing.

Is dbt safe to use?

It scores 24 of 100. Grades: maintenance C, licence A, quality C. The security check has not run for it yet. Review the code before you install. How grades work.

What are alternatives to dbt?

Does dbt work with ChatGPT?

Not directly. It runs locally, and ChatGPT only connects to remote servers with a URL. Use it in Claude Code, Claude Desktop, Cursor, VS Code or Codex.