Skip to main content
Book a demo

Connect dbt to VS Code

Give VS Code governed access to dbt’s 42 tools through Runlayer, with identity, policy, scanning, and audit on every call.

Book a demo VS Code setup guide

Set up

Add dbt to VS Code in four steps

Admins approve the server once. Everyone in VS Code then gets it through the same governed connection.

  1. 1

    Approve dbt in Runlayer

    Add dbt from the catalog and choose who can use it and which of its tools are allowed.

  2. 2

    Connect VS Code to Runlayer

    Runlayer’s CLI installs the Runlayer Plugin natively in VS Code; users can also add it over MCP. With direct tool listing turned on for your deployment, dbt’s 42 tools show up in VS Code’s own tool list (VS Code 1.103 or newer).

    VS Code setup guide
  3. 3

    Sign in to dbt

    Sign in the way dbt requires. Runlayer holds the credentials so they stay out of the client’s configuration.

  4. 4

    Use dbt from VS Code

    dbt’s approved tools appear in VS Code. Every call is checked against policy and recorded.

Tools

42 dbt tools in VS Code

Runlayer policy decides which of these VS Code users can call.

  • Cancel job run

    Cancel a currently running or queued dbt run.

  • Get all macros

    Get the name, description, and package name of all dbt macros in the environment.

  • Get all models

    Get the name and description of all dbt models in the environment.

  • Get all sources

    Get the name, description, and metadata of all dbt sources in the environment.

  • Get dimension values

    Get the distinct values for a given dimension, optionally scoped to specific metrics.

  • Get dimensions

    Get the dimensions for specified metrics

  • Get entities

    Get the entities for specified metrics

  • Get exposure details

    DEPRECATED — use get_node_details instead.

See all 42 dbt tools

Control

What Runlayer can see and stop in VS Code

Some controls apply to every client at the gateway. Others depend on what VS Code exposes to Runlayer.

  • Gateway policy (available)

    Every dbt call from VS Code passes through Runlayer, where your policies can allow, alert, mask, or block it.

  • Audit trail (available)

    Each call is recorded with the user, VS Code as the client, the tool, and the policy and scanner decisions.

  • Client hooks (available)

    Capture supported prompts, reasoning, local and MCP tool calls, responses, and scanner decisions in real time.

  • Stop a call before it runs (available)

    Runlayer can deny a tool call before VS Code runs it.

  • Block output after it runs (available)

    Runlayer can block a tool’s output before VS Code’s model sees it.

  • Redact output in place (available)

    Runlayer can mask sensitive parts of a tool’s output in VS Code and pass the rest through.

Frequently asked questions

Connect more

Find another combination