Morning check
The data lead at Acme asks whether the nightly build passed. Memtro reads the production job: the 02:00 run ended in error after 14 minutes, on the dbt build step, and the end of its log names the failing model and the missing column.
dbt Cloud + Memtro
Ask whether last night's dbt build passed, and which step failed if it did not.
Connect dbt Cloud with a token, your access URL and account ID, and Memtro reads projects, environments and scheduled jobs with their next run and last result, job runs with message, duration and branch, and one run's steps with the end of each log when asked. The sync writes each finished job run into memory. When you ask, and once an administrator has granted the action by name, it can run a job now, retry or re-run a failed one, or cancel a run. Each run spends warehouse compute and rebuilds tables. Deleting a job is permanent.
In Memtro
What you can do with dbt Cloud in Memtro
Ask in plain English from chat, your editor, a scheduled job or your own agent. The model picks the right dbt Cloud tool, reads what it needs, and answers with the source cited.
What it does
- 01Projects with description, repository and subdirectory, and each project's environments with type and deployment type
- 02Jobs with schedule, environment, next scheduled run and the status of the latest and last finished run
- 03Runs newest first by job or status, with duration, branch and link, and one run's steps with the end of each log on request
- 04The sync writes each finished job run into memory, so past failures can be recalled later
- 05When asked and granted, runs a job now, retries a failed run from where it failed or re-runs a job, each spending warehouse compute and rebuilding tables, and cancels a queued or running run
- 06When asked and granted, permanently deletes a job and its schedule
Acts when asked
When you ask it to
These tools change something in dbt Cloud. The model is told to use them only when you ask for exactly that, and an administrator grants each one by name to the teams that may use it; a personal connection acts only after its owner allows it.
- 01Trigger a run of a dbt Cloud job now (runs dbt against the warehouse)
- 02Cancel a queued or running dbt Cloud run
- 03Retry a failed dbt Cloud run from its point of failure
- 04Re-run a job: from the failure point if its last run failed, otherwise afresh
- 05Delete a dbt Cloud job and its schedule (permanent)
Events
When it happens
Turn events on in the connection's Events tab on the Connections page, choose the kinds you want, and Memtro registers its address with dbt Cloud for you. Each event can start a job, with the event as its input. dbt Cloud signs every delivery, and one whose signature does not check out is refused before it is read.
Events and webhooks- 01A job run started
- 02A job run finished, succeeded or failed (after its artifacts are ingested)
- 03A job run errored (sent at once, before artifacts are ingested)
In practice
Ask it like you would a colleague
Once dbt Cloud is connected, these are the kinds of things people ask. Plain questions, no syntax. If the answer lives partly in another system you have connected, Memtro looks there too.
dbt Cloud + Memtro
Did last night's dbt build pass?
Which dbt runs failed today, and why?
Show me the steps and logs of the last failed nightly run
When is the production job next scheduled to run?
Retry last night's failed production run from where it stopped
Picking up after a fix
Dan Fletcher pushes a fix for the missing orders column and asks Memtro to finish the Northwind nightly build. Memtro retries the failed run from its point of failure, which rebuilds only the remaining models in the warehouse, and reports it passed 6 minutes later.
Teams
Where it fits
The teams that lean on dbt Cloud most, a question each of them asks, and what they connect beside it.
- Data and analyticsQuestions answered from the warehouse, with the SQL shownAnalyst, Data engineer, Anybody with a question, Head of data“Revenue by segment for Q3 from the warehouse, with the SQL you used”Used alongside Postgres, Stripe, Slack, Google Drive, Snowflake and 3 more.
- EngineeringKeep decisions from evaporatingEngineer, Tech lead, On call, New joiner“Who owns the billing migration, and what did we decide about retries?”Used alongside GitHub, Linear, Jira, Confluence, Slack and 5 more.
- FinanceAsk the ledger questions in plain EnglishFinance lead, Credit control, Management accountant, Founder or CFO“Which invoices over £5k are more than 30 days overdue?”Used alongside Xero, Stripe, Postgres, HubSpot, QuickBooks Online and 10 more.
Better together
Works with
A record in dbt Cloud is rarely the whole story. Connect the systems that hold the rest and Memtro checks them together, then remembers what it learned so the next question starts further along.
- Analyticsdbt Cloud with Google Analytics 4Ask your traffic questions in plain English and get the numbers back.
- Analyticsdbt Cloud with Plausible AnalyticsAsk about your website traffic in plain English.
- Analyticsdbt Cloud with UmamiAsk about your website traffic in plain English, without sending anybody to a dashboard.
- Finance and commercedbt Cloud with XeroInvoices, bills, contacts and reports, answered in plain English with figures cited to Xero.
- Finance and commercedbt Cloud with StripeCustomers, charges, invoices and subscriptions through a restricted key.
- Finance and commercedbt Cloud with FellohBookings, payments, refunds, chargebacks, supplier payments and payouts from the travel payments platform.
- Work managementdbt Cloud with JiraJQL search, issue details and projects from Jira Cloud.
- Work managementdbt Cloud with Clio ManageAsk the matter: its client, its fee earner, the time on it and what is still unbilled.
- Work managementdbt Cloud with LinearIssues, projects and teams, synced hourly into memory.
Also in Databases and warehouses
Using something else for the same job, or both? Each connector has its own tools; connect as many as you like.
- Postgres
- MySQL and MariaDB
- SQL Server
- BigQuery
- Snowflake
- AWS Athena
- MongoDB
- ClickHouse
- Amazon Redshift
- Databricks
- Elasticsearch
- Fivetran
- Neon
- Appwrite
Grist- Hasura
- Meilisearch
NocoDB- Qdrant
Typesense
Weaviate
Tinybird
Hightouch
Census- Airbyte
- Budibase
- CockroachDB Cloud
- Cube Cloud
- DataHub
kintone
Monte Carlo
OpenMetadata- Pinecone
- PlanetScale
- Quickbase
Secoda
Softr
Teable- Turso
- Upstash
Vectara- Xata
- Zilliz Cloud
Setup
How to connect
Connect withService token or personal access token, Access URL and Account ID
- 1
dbt Cloud's API is available on the Starter, Enterprise and Enterprise+ plans, not on the free Developer plan
- 2
In dbt open Account settings → Service tokens and create a token with the Read-only permission set, or Job Admin if Memtro should run, cancel or delete jobs when asked. On Starter use a personal access token from Account settings → API tokens instead
- 3
In Memtro open Connections → dbt Cloud and paste the Service token or personal access token, the Access URL host from Account settings → Account information, and the Account ID after /accounts/ in the address bar
- 4
Ask whether last night's production build passed
Also works from
Chat in the dashboard, the OpenAI-compatible API, scheduled jobs, and any MCP client: Claude Code, OpenCode, Cursor, Claude Desktop. The dbt Cloud tools are the same everywhere.
FAQ
Questions
Can Memtro change anything in dbt Cloud?+
Only when you ask, and only what it has been granted: trigger a run of a dbt Cloud job now (runs dbt against the warehouse); cancel a queued or running dbt Cloud run; retry a failed dbt Cloud run from its point of failure; re-run a job: from the failure point if its last run failed, otherwise afresh; delete a dbt Cloud job and its schedule (permanent). Every other tool reads, searches or lists. The Connections page labels the tools that act, an administrator grants each one by name to the teams that may use it, and a personal connection acts only after its owner allows it.
Who can use a dbt Cloud connection?+
A personal connection serves only your own requests. A shared connection serves the organisation: everyone, or only the teams an admin chooses. Admins can always add shared connections; other members need the permission.
Does Memtro store my dbt Cloud data?+
Credentials are encrypted at rest. Tool results are cached briefly so agent loops do not repeat identical calls, and the facts the model extracts are saved to your organisation's memory with provenance (system, record and link) so they can be checked and superseded. An hourly sync anchors recently changed dbt Cloud records into memory as entities.
How do I connect dbt Cloud?+
Service token or personal access token, Access URL and Account ID. dbt Cloud's API is available on the Starter, Enterprise and Enterprise+ plans, not on the free Developer plan.
Can dbt Cloud start a job?+
Yes. Turn events on in the connection's Events tab on the Connections page, choose the kinds you want, and Memtro registers its address with dbt Cloud for you. A job set to start "When an event arrives" then runs once for each matching event, with the event as its input. The run treats the event as outside data, never as instructions, and anything the run remembers is kept as unverified.
Connect dbt Cloud in a few minutes
Seven-day free trial, then one monthly price per organisation. Connectors, jobs and memory are never metered.