How to Install @Us All/Dbt MCP in VS Code
To install the @Us All/Dbt MCP server in VS Code, click the install button below (deep-link) — VS Code opens and adds the server. No JSON editing needed.
vscode:mcp/install?eyJuYW1lIjoidXMtYWxsLWRidC1tY3AiLCJjb21tYW5kIjoibnB4IiwiYXJncyI6WyIteSIsIkB1cy1hbGwvZGJ0LW1jcCJdLCJlbnYiOnsiREJUX1BST0pFQ1RfRElSIjoiIiwiRFFfQ09MX0NIRUNLX05BTUUiOiIiLCJEUV9DT0xfREFUQVNFVCI6IiIsIkRRX0NPTF9GQUlMVVJFX0NPVU5UIjoiIiwiRFFfQ09MX1JVTl9BVCI6IiIsIkRRX0NPTF9TQ09QRSI6IiIsIkRRX0NPTF9UQUJMRV9OQU1FIjoiIiwiRFFfQ09MX1RJRVIiOiIiLCJEUV9SRVNVTFRTX1RBQkxFIjoiIiwiRFFfU0NIRU1BIjoiIn19 1-click install via Unyly- 1Click the install buttonVS Code opens automatically.
- 2ConfirmApprove adding the MCP server.
- 3DoneThe server is connected; a restart is usually not required.
Where the config lives
VS Code stores MCP servers in your user settings.json (global) or .vscode/mcp.json in a workspace (that project only). The install link adds the user-level entry.
Project vs global scope
User settings apply everywhere; a workspace .vscode/mcp.json scopes the server to that project and can be shared via git.
API keys & environment variables
This server needs environment variables: DBT_PROJECT_DIR, DQ_COL_CHECK_NAME, DQ_COL_DATASET, DQ_COL_FAILURE_COUNT, DQ_COL_RUN_AT, DQ_COL_SCOPE, DQ_COL_TABLE_NAME, DQ_COL_TIER, DQ_RESULTS_TABLE, DQ_SCHEMA. Put your real values in the env block (Cursor / VS Code / Claude Desktop) or as -e KEY=value flags (Claude Code). Keep them in env, not args — otherwise the secrets leak into logs.
Verify it works
Open the MCP view in VS Code — the server appears once it connects. Hover it to see its tools.
If the tools don’t appear
- · Restart VS Code fully (not just the window).
- · Check the command/config for typos; validate the JSON if applicable.
- · Make sure Node.js or uv is installed (for npx/uvx servers).
- · Check VS Code’s logs — the server may have crashed on start (missing env var, bad token).
How many servers is too many
Every connected server adds its tools to the model’s context. Past ~40–60 tools, selection accuracy drops. Keep only the servers you use enabled, or reach the whole catalog through a gateway — one connection instead of dozens.
Removing @Us All/Dbt
Delete the server from settings.json (or .vscode/mcp.json), or disable it in the MCP view.
FAQ
Do I need to edit JSON by hand?
No. In VS Code it's a command or a deep-link; on Unyly the Install button writes the config for you.
Where is the VS Code config file?
VS Code keeps MCP servers in its own settings — installing via command/button means you never touch a file by hand.
The MCP isn’t showing up — what do I do?
Restart VS Code, check the command/config for typos, and make sure Node.js / a package runner is installed if the server runs via npx/uvx.
How do I update @Us All/Dbt?
Servers run via npx/uvx pull the latest version on launch. Otherwise, reinstall the same way.
Is it safe to install @Us All/Dbt?
An MCP server runs with your client’s permissions and access to its data. Install it with the same caution as any npm package: check the source and keep secrets in env. Verified servers on Unyly have passed a security scan.
Does @Us All/Dbt cost anything?
Browsing and installing on Unyly is free. The server itself may need a third-party API key — that’s billed by the service, not by Unyly.
Can I use @Us All/Dbt in ChatGPT or claude.ai?
Not directly: @Us All/Dbt is a local (stdio) server, and ChatGPT/claude.ai only accept remote MCPs. Use the Unyly gateway to expose local servers as one remote endpoint.