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.
Say what should happen.
The workflow builds itself.
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 settingsdelete_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 settingslist_environmentsList environmentsGETList dbt environments in an account with optional filtering by project, dbt version, name, type, and stateupdate_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 settingsdelete_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 IDlist_jobsList jobsGETList dbt jobs in an account with optional filtering by project, environment, pagination, and sort orderupdate_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 subdirectorydelete_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 settingslist_projectsList projectsGETList all dbt projects within a dbt Cloud account, with optional pagination via limit and offsetupdate_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 datalist_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 configurationlist_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.jsonlist_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 mcp add --transport http livecontext https://livecontext.ai/mcp --header "X-API-Key: YOUR_API_KEY"[mcp_servers.livecontext]
url = "https://livecontext.ai/mcp"
[mcp_servers.livecontext.http_headers]
"X-API-Key" = "YOUR_API_KEY"{
"mcpServers": {
"livecontext": {
"type": "http",
"url": "https://livecontext.ai/mcp",
"headers": {
"X-API-Key": "YOUR_API_KEY"
}
}
}
}How to connect dbt Cloud
- Create your workspace
Sign up free. Nothing to install.
- 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.
- 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.
