Integration

dbt Cloud integration

dbt Cloud Administrative API for managing data transformation projects, jobs, runs, and environments. Trigger jobs, monitor run status, manage projects and accounts, and orchestrate analytics engineering workflows.

Ask it in chat

Say what should happen.
The workflow builds itself.

When this happens, do that in dbt Cloud.Built from the 25 dbt Cloud tools below, on the connection you add once.

Common dbt Cloud use cases

  • automate job management
  • automate project management
  • automate environment management
  • automate run management
  • automate account management
  • automate run artifact management
  • get job programmatically
  • get run programmatically
  • list job programmatically
  • list run programmatically

What you can do with dbt Cloud

Each of these is one operation on one endpoint, available both as a workflow step and as a tool an AI agent can call on its own. Nothing bundles several operations into one action, so what a run did stays readable afterwards.

Most endpoints run on the free plan. A few, mainly the ones that publish on your behalf, need a paid plan.

Environment, 5 operations

  • create_environmentCreate environmentPOSTCreate a new dbt environment in a project with type (development or deployment), dbt version, credentials, and branch settings
  • delete_environmentDelete environmentDELETEPermanently delete a dbt environment from an account. Jobs using this environment must be reassigned first.
  • get_environmentGet environmentGETRetrieve details for a specific dbt environment including its type, dbt version, credentials, and custom branch settings
  • list_environmentsList environmentsGETList dbt environments in an account with optional filtering by project, dbt version, name, type, and state
  • update_environmentUpdate environmentPOSTUpdate an existing dbt environment's name, type, dbt version, credentials, or branch configuration

Job, 5 operations

  • create_jobCreate jobPOSTCreate a new dbt job in an account with execution steps, schedule, triggers, and dbt version settings
  • delete_jobDelete jobDELETEPermanently delete a dbt job definition from an account. Running jobs are not affected.
  • get_jobGet jobGETRetrieve the definition and configuration of a specific dbt job by its ID
  • list_jobsList jobsGETList dbt jobs in an account with optional filtering by project, environment, pagination, and sort order
  • update_jobUpdate jobPOSTUpdate the definition of an existing dbt job including steps, schedule, triggers, and settings

Project, 5 operations

  • create_projectCreate projectPOSTCreate a new dbt project within a dbt Cloud account, specifying name, optional connection, repository, and subdirectory
  • delete_projectDelete projectDELETEPermanently delete a dbt project from a dbt Cloud account. This action is irreversible.
  • get_projectGet projectGETRetrieve details for a specific dbt project including its name, connection, repository, and dbt version settings
  • list_projectsList projectsGETList all dbt projects within a dbt Cloud account, with optional pagination via limit and offset
  • update_projectUpdate projectPOSTUpdate an existing dbt project's name, connection, or repository association

Run, 3 operations

  • cancel_runCancel runPOSTCancel a dbt run that is currently queued or in progress. Has no effect on completed or already-cancelled runs.
  • get_runGet runGETRetrieve details of a specific dbt run by its ID, including status, timing, and optionally related job and step data
  • list_runsList runsGETList dbt job runs in an account with optional filtering by job, project, environment, status, and pagination

Account, 2 operations

  • get_accountGet accountGETRetrieve details for a specific dbt Cloud account by its numeric ID, including plan, name, and configuration
  • list_accountsList accountsGETList all dbt Cloud accounts accessible by the authenticated user's API token

Run artifact, 2 operations

  • get_run_artifactGet run artifactGETDownload a specific artifact file produced by a dbt run, such as manifest.json or run_results.json
  • list_run_artifactsList run artifactsGETList all artifacts produced by a dbt run, such as manifest.json, run_results.json, and catalog.json

Job run, 1 operation

  • trigger_job_runTrigger job runPOSTManually trigger a dbt job to run immediately, with optional overrides for git ref, schema, dbt version, threads, and steps

Repository, 1 operation

  • list_repositoriesList repositoriesGETList all Git repositories connected to a dbt Cloud account, optionally filtered by project

User, 1 operation

  • list_usersList usersGETList all users who have access to a dbt Cloud account, including their roles and permissions

Use dbt Cloud from Claude Code, Cursor or Codex

Connect dbt Cloud in LiveContext, create an API key in Settings, then add the LiveContext MCP server to your client. Its dbt Cloud operations become tools the client can call, next to every other integration you connected.

Claude Code
claude mcp add --transport http livecontext https://livecontext.ai/mcp --header "X-API-Key: YOUR_API_KEY"
Codex (~/.codex/config.toml)
[mcp_servers.livecontext]
url = "https://livecontext.ai/mcp"

[mcp_servers.livecontext.http_headers]
"X-API-Key" = "YOUR_API_KEY"
Cursor, Claude Desktop and other JSON configs
{
  "mcpServers": {
    "livecontext": {
      "type": "http",
      "url": "https://livecontext.ai/mcp",
      "headers": {
        "X-API-Key": "YOUR_API_KEY"
      }
    }
  }
}

Set up the MCP server step by step

How to connect dbt Cloud

  1. Create your workspace

    Sign up free. Nothing to install.

  2. Connect dbt Cloud once

    Add your dbt Cloud connection in Settings. Every tool from this integration reuses it, and secrets are encrypted at rest and visible only to you.

  3. Describe the job in chat

    The workflow builds itself in front of you and picks the endpoints it needs. Drag the steps yourself on the canvas whenever you would rather be explicit.

dbt Cloud integration FAQ

What can you do with the dbt Cloud integration?

LiveContext exposes 25 operations on dbt Cloud, covering environment, job, project and run. Common uses include automate job management, automate project management and automate environment management.

Popular integrations

Browse the whole catalog