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.
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
- POSTcreate_environment
Create a new dbt environment in a project with type (development or deployment), dbt version, credentials, and branch settings
- DELETEdelete_environment
Permanently delete a dbt environment from an account. Jobs using this environment must be reassigned first.
- GETget_environment
Retrieve details for a specific dbt environment including its type, dbt version, credentials, and custom branch settings
- GETlist_environments
List dbt environments in an account with optional filtering by project, dbt version, name, type, and state
- POSTupdate_environment
Update an existing dbt environment's name, type, dbt version, credentials, or branch configuration
Job, 5 operations
- POSTcreate_job
Create a new dbt job in an account with execution steps, schedule, triggers, and dbt version settings
- DELETEdelete_job
Permanently delete a dbt job definition from an account. Running jobs are not affected.
- GETget_job
Retrieve the definition and configuration of a specific dbt job by its ID
- GETlist_jobs
List dbt jobs in an account with optional filtering by project, environment, pagination, and sort order
- POSTupdate_job
Update the definition of an existing dbt job including steps, schedule, triggers, and settings
Project, 5 operations
- POSTcreate_project
Create a new dbt project within a dbt Cloud account, specifying name, optional connection, repository, and subdirectory
- DELETEdelete_project
Permanently delete a dbt project from a dbt Cloud account. This action is irreversible.
- GETget_project
Retrieve details for a specific dbt project including its name, connection, repository, and dbt version settings
- GETlist_projects
List all dbt projects within a dbt Cloud account, with optional pagination via limit and offset
- POSTupdate_project
Update an existing dbt project's name, connection, or repository association
Run, 3 operations
- POSTcancel_run
Cancel a dbt run that is currently queued or in progress. Has no effect on completed or already-cancelled runs.
- GETget_run
Retrieve details of a specific dbt run by its ID, including status, timing, and optionally related job and step data
- GETlist_runs
List dbt job runs in an account with optional filtering by job, project, environment, status, and pagination
Account, 2 operations
- GETget_account
Retrieve details for a specific dbt Cloud account by its numeric ID, including plan, name, and configuration
- GETlist_accounts
List all dbt Cloud accounts accessible by the authenticated user's API token
Run artifact, 2 operations
- GETget_run_artifact
Download a specific artifact file produced by a dbt run, such as manifest.json or run_results.json
- GETlist_run_artifacts
List all artifacts produced by a dbt run, such as manifest.json, run_results.json, and catalog.json
Job run, 1 operation
- POSTtrigger_job_run
Manually trigger a dbt job to run immediately, with optional overrides for git ref, schema, dbt version, threads, and steps
Repository, 1 operation
- GETlist_repositories
List all Git repositories connected to a dbt Cloud account, optionally filtered by project
User, 1 operation
- GETlist_users
List 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.
Popular integrations
Instagram API with Instagram Login (graph.instagram.com). Manage a Business/Creator Instagram account…
Messaging platform API for building bots and integrations. Send messages, manage chats and channels, handle…
Google email service API for sending, receiving, and managing emails. Access messages, threads, labels,…
Google's video platform API for accessing video, channel, playlist, and comment data
Social media platform API for posting, reading, and managing Twitter/X content. Post tweets, read timelines,…
Social media platform API for content creators and businesses. Access user info, manage videos, get…
Professional networking platform API for managing profiles, connections, and content. Share posts, manage…
AI API from xAI (Elon Musk's AI company) powering Grok models. Access state-of-the-art language models with…