Skip to content

BI

dbt Labs MCP connector

The dbt Labs connector brings your dbt Labs users, groups, invites, warehouse connections and account audit history to Claude, ChatGPT, Cursor, Microsoft Copilot or any MCP client, with every request running as the signed-in person and logged.

  • Connects with an API key
  • Free 14-day trial
  • No credit card
ChatGPT Elaichi connected

Which dbt Labs users aren't in any group yet?

Working in dbt Labs with Elaichi

  • List all dbt Labs users
  • Get single dbt Labs user by ID
  • List all dbt Labs accounts
Ask anything…
Governance / Audit log Last 24 hours
dbt Labs List all dbt Labs accounts Emily Carter · ChatGPT · 9:41 AM Done
dbt Labs Get single dbt Labs user by ID Emily Carter · ChatGPT · 9:41 AM Done
dbt Labs List all dbt Labs users Emily Carter · ChatGPT · 9:41 AM Done
dbt Labs Update a dbt Labs user by ID Megan Brooks · Claude · 9:38 AM Done
dbt Labs Get single dbt Labs account by ID Ryan Hayes · Cursor · 9:35 AM Done

How to connect dbt Labs to Claude, ChatGPT, Cursor or Microsoft Copilot

Step by step, for each AI app

dbt Labs MCP connector for Claude

  1. 1

    Open Customize, then Connectors.

  2. 2

    Press Add.

  3. 3

    Name it, paste the MCP server URL, then Continue.

    https://api.elaichi.ai/mcp
  4. 4

    Sign in and approve.

On Team and Enterprise, an Owner adds it once. Everyone else turns it on for themselves.

dbt Labs MCP connector for Claude Code

  1. 1

    In a terminal, run claude mcp add with the endpoint.

    https://api.elaichi.ai/mcp
  2. 2

    Start Claude Code and run /mcp.

  3. 3

    Pick elaichi, then sign in and approve in the browser.

Terminal

$ claude mcp add --transport http elaichi --scope user https://api.elaichi.ai/mcp

Use --scope project instead to share it with the repository through .mcp.json.

dbt Labs MCP connector for ChatGPT

  1. 1

    Open Plugins, then press the + button.

  2. 2

    Name it and paste the endpoint into Server URL.

    https://api.elaichi.ai/mcp
  3. 3

    Leave Authentication on OAuth, then tick the risk acknowledgement.

  4. 4

    Press Create, then sign in and approve.

Works on the web. The plugin directory lives at chatgpt.com/plugins.

dbt Labs MCP connector for Cursor

  1. 1

    Open ~/.cursor/mcp.json.

  2. 2

    Add the endpoint under mcpServers.

    https://api.elaichi.ai/mcp
  3. 3

    Reload Cursor, then sign in and approve.

~/.cursor/mcp.json

{
  "mcpServers": {
    "elaichi": {
      "url": "https://api.elaichi.ai/mcp"
    }
  }
}

Set up per machine, so repeat it on each computer you work from.

dbt Labs MCP connector for Microsoft Copilot

  1. 1

    In Copilot Studio, open your agent, then Tools, Add a tool, New tool and Model Context Protocol.

  2. 2

    Paste the endpoint into Server URL, choose OAuth 2.0, then Dynamic discovery, and press Create.

    https://api.elaichi.ai/mcp
  3. 3

    Create a new connection, sign in and approve, then press Add to agent.

  4. 4

    Under Channels, open Teams and Microsoft Copilot and make the agent available in Microsoft Copilot.

Server URL
https://api.elaichi.ai/mcp
Authentication
OAuth 2.0
Type
Dynamic discovery

Microsoft Copilot was called Microsoft 365 Copilot. Keep the tool on end-user credentials, so each person signs in as themselves.

Connect dbt Labs to any MCP client

  1. 1

    Add the endpoint as a remote MCP server.

    https://api.elaichi.ai/mcp
  2. 2

    Sign in and approve.

{
  "mcpServers": {
    "elaichi": {
      "url": "https://api.elaichi.ai/mcp"
    }
  }
}

The Elaichi Agent already has these tools, with nothing to set up.

What teams do with dbt Labs through Elaichi

Ask in plain English. Each person’s AI can do only what they’re allowed to, and every action it takes in dbt Labs is logged.

  • Data platform

    Check who can reach the production warehouse

    Ask which groups hold permissions on each dbt Labs warehouse connection and which users sit in those groups, then tighten what needs tightening before the next review.

  • IT

    Onboard a new analyst in one ask

    Send the dbt Labs invite, create or pick the right group, and assign the new hire to it without opening the admin console.

  • Security

    Pull the audit log before a compliance check

    List recent dbt Labs account audit events and the IP restrictions in force, and get a plain summary of what changed and who changed it.

  • Analytics engineering

    Update a warehouse connection without a ticket

    When credentials rotate or a host changes, update the dbt Labs connection details yourself and confirm the change took.

  • Operations

    Chase invites nobody accepted

    See every open dbt Labs invite, how long it has been sitting, and who sent it, then follow up or resend.

  • Finance

    Reconcile seats ahead of renewal

    List the users on each dbt Labs account and spot people who no longer need a seat before the invoice arrives.

Try asking

  • “Which dbt Labs users aren't in any group yet?”
  • “List pending invites to our dbt Labs account.”
  • “Who has permissions on the production warehouse connection?”

See all 205 dbt Labs tools →

What connecting dbt Labs gets you

6 screens from Elaichi, each doing one job for your dbt Labs account.

Elaichi Agent

Ask Elaichi to work across your apps.

Which dbt Labs users aren't in any group yet?

List pending invites to our dbt Labs account.

Who has permissions on the production warehouse connection?

Also runs in Claude, ChatGPT, Cursor or Microsoft Copilot

The agent

Ask about dbt Labs users in plain words.

Who still needs a group, which invites are open, answered from live dbt Labs records.

ElaichiAI apps
Claude ChatGPT Cursor Microsoft Copilot

Copy the endpoint

https://api.elaichi.ai/mcp
Client Connected by Status Last used
Claude
E

Emily Carter

• Connected 4 minutes ago
Cursor
M

Megan Brooks

• Connected 2 hours ago
ChatGPT
R

Ryan Hayes

• Connected Yesterday

AI apps

One endpoint, every client, dbt Labs connected once.

Claude, ChatGPT and Cursor reach dbt Labs through one governed endpoint, no SDK, no shared key.

ElaichiTools
Tool Action Description
List all dbt Labs users List List the dbt Cloud users associated with an account. Returns: id, created_at, updated_at. Required: account_id.
Get single dbt Labs user by ID Get Get a single dbt Cloud user by id. Returns: id, created_at, updated_at. Required: account_id, id.
Update a dbt Labs user by ID Update Update an existing dbt Cloud user by id. Returns the updated user record: id plus the user's schema-defined attributes. Required: id (integer user id) and a UserRequest JSON body.
List all dbt Labs accounts List List the dbt accounts your API token is authorized to access. Returns: id, created_at, updated_at.
Get single dbt Labs account by ID Get Get a single dbt Cloud account by its numeric id. Returns: id, created_at, updated_at. Required: id, account_id.

Tool catalog

205 dbt Labs tools, no code required.

Users, groups, invites, connections, audit logs and IP restrictions, cataloged and ready to call.

ElaichiToolboxes
Name Source template Tools Created

Data platform toolbox

dbt Labs · warehouse connections and groups

dbt Labs starter 18 Mar 4, 2026

Analytics engineering toolbox

dbt Labs · favorite assets and accounts

— 9 Mar 2, 2026

IT toolbox

dbt Labs · users and invites

— 24 Feb 27, 2026

Security toolbox

dbt Labs · audit logs and IP restrictions

dbt Labs starter 6 Feb 19, 2026

Operations toolbox

dbt Labs · invites and group assignments

— 31 Jan 30, 2026

Finance toolbox

dbt Labs · seats and accounts

— 12 Jan 22, 2026

Toolboxes

Each team gets its own dbt Labs toolbox.

Platform admins manage connections while analysts browse favorite assets, each scoped to their team.

ElaichiConnections
Connection Scope Status Access
DB

dbt Labs (Data platform)

Connected by Emily Carter

Personal • Active 1 team · 6 members
DB

dbt Labs (Analytics)

Connected by Jake Morgan

Organization • Active 3 teams · 24 members
DB

dbt Labs (IT admin)

Connected by Megan Brooks

Organization • Active 2 teams · 11 members
DB

dbt Labs (Security)

Connected by Tyler Reed

Personal • Needs re-auth 1 team · 3 members
DB

dbt Labs (Finance)

Connected by Ryan Hayes

Personal • Active Not shared
DB

dbt Labs (Production)

Connected by Ashley Parker

Personal • Active 2 teams · 9 members

Shared connections

Share dbt Labs access, never the API key.

One person connects dbt Labs and teammates work through it without seeing a credential.

ElaichiAudit log
When Who What happened Type

2 minutes ago

Mar 6, 2026, 3:10 PM

E

Emily Carter

[email protected]

Restriction Created Access

8 minutes ago

Mar 6, 2026, 3:04 PM

J

Jake Morgan

[email protected]

Restriction Updated Access

14 minutes ago

Mar 6, 2026, 2:58 PM

M

Megan Brooks

[email protected]

Role Assigned Access

20 minutes ago

Mar 6, 2026, 2:52 PM

T

Tyler Reed

[email protected]

dbt Labs Users Updated MCP

26 minutes ago

Mar 6, 2026, 2:46 PM

R

Ryan Hayes

[email protected]

dbt Labs Users Created MCP

32 minutes ago

Mar 6, 2026, 2:40 PM

A

Ashley Parker

[email protected]

dbt Labs Users List Toolbox

Audit log

Every dbt Labs call names who did it.

When, who, what happened and which user, group or connection was touched.

From answering questions to doing the work

A trigger starts the work, inside the same permissions and the same audit log as everything else. Workflows, collections and live dashboards come with the Black plan.

dbt Labs digest

Run 418 · started 2 minutes ago · on behalf of Emily Carter

  1. ✓

    Schedule

    Every weekday at 8:00 AM

    0.2s
  2. ✓

    Fetch users

    dbt Labs

    1.4s
  3. ✓

    Group by owner

    Transform

    0.1s
  4. ✓

    Draft the digest

    Agent step

    Ran with 4 tools, returned a structured summary

    6.2s
  5. Approve the digest

    Needs approval

    Assigned to Jake Morgan

    Approve
  6. Post the digest

    dbt Labs

    Queued

Workflows

Schedules run dbt Labs reviews end to end.

Open invites are fetched, grouped, drafted into a digest, approved, then posted to dbt Labs.

dbt Labs health

Refreshed 4 minutes ago · every 15 minutes · from the users collection

Live

Users

1,284 ↓ 12%

Groups

96 ↓ 8%

Needs attention

3 ↑ 2

Updated this week

412 ↑ 9%

Users created

Last 14 days

By team

Share of activity

Data platform 34%

Analytics 27%

IT admin 21%

Security 18%

Collections and dashboards

dbt Labs health numbers, computed without a model.

Users, groups, invites and connections charted over 14 days by team, refreshed on schedule.

For IT and engineering

Elaichi vs Zapier MCP vs Composio for dbt Labs

All three can connect dbt Labs to an AI assistant, and all three have admin controls. They differ in where access lives and how you pay.

Elaichi compared with Zapier MCP and Composio for dbt Labs, by what to check
What to check Elaichi Zapier MCP Composio
Where the AI connects One address for the whole organization. https://api.elaichi.ai/mcp A server per member, created at sign-in. An MCP endpoint per team, or an SDK.
Control over dbt Labs tools Allow or restrict single dbt Labs tools, per role or user. App and action restrictions on the account. Role permissions, down to the action.
Record of calls One audit entry per dbt Labs call. A History tab of tool calls. A log of every tool call.
Single sign-on SAML or OIDC, plus SCIM, on Gold. SAML on Enterprise. SAML and OIDC on Enterprise.
Price Free for one person; $15 per user per month on Gold. 2 tasks per successful call. Billed per tool call.

Sources: Zapier MCP docs, security, usage; Composio docs, gateway, enterprise, pricing. Checked September 2026.

Longer take: Zapier MCP alternative and when you don't need an MCP gateway.

dbt Labs tools for your AI agents

205 tools are ready to call through Elaichi's MCP endpoint the moment you connect dbt Labs, governed by the same roles, restrictions, and audit log as everything else in Elaichi.

Questions, answered

How do I connect dbt Labs to Claude?

Connect dbt Labs in Elaichi first, which asks only for a dbt Labs API key, so there is no OAuth application to register and no client ID or secret to generate. Then in Claude go to Customize, then Connectors, then Add, and paste https://api.elaichi.ai/mcp. Sign in as yourself and dbt Labs is available in your chat.

Does dbt Labs work with ChatGPT and Cursor as well as Claude?

Yes. Once dbt Labs is connected in Elaichi, the same endpoint, https://api.elaichi.ai/mcp, works in Claude, ChatGPT, Cursor, Microsoft Copilot, any MCP client and the Elaichi Agent. You connect dbt Labs once, not once per client.

What can an AI agent actually do with my dbt Labs data?

It can list the users and groups on your dbt Labs account, send invites, assign people to groups, read the account audit log, check IP restrictions and view or update warehouse connections. Short, concrete asks such as "list open dbt Labs invites" work better than long sentences.

Does connecting dbt Labs give the AI access to everything in my account?

No. Every request to dbt Labs runs with the access of the person who signed in to Elaichi, so an analyst who cannot edit connections in dbt Labs cannot edit them through an agent either. Elaichi can narrow that access further with restrictions, and it never widens it.

Can my team share one dbt Labs connection?

Yes. One person connects dbt Labs with the API key and shares the connection with a team, and nobody else ever sees or handles the key. Each teammate still signs in to Elaichi as themselves, so the audit log names the actual person behind every dbt Labs call.

Can I stop an agent from deleting or changing things in dbt Labs?

Yes. Restrictions in Elaichi apply per action, so you can allow reading dbt Labs users and connections while restricting updates, invites or deleting a connection, on a role or on one person. A restricted action still appears in Elaichi's tool search, flagged as restricted, but no client can run it whatever the prompt says.

What happens to a dbt Labs connection when someone leaves?

Offboarding that person in Elaichi ends their access to dbt Labs through every client at once. A shared dbt Labs connection keeps working for everyone else on the team. If you want the connection gone entirely, disconnecting dbt Labs once in Elaichi removes it from Claude, ChatGPT, Cursor and every other client.

Does the dbt Labs MCP connector work with Gemini, Codex, Claude Code or other MCP clients?

Yes. dbt Labs is reached over the same MCP endpoint every client uses, so anything that speaks MCP can call it — Gemini, Codex, Claude Code, Windsurf, Cline, Zed and OpenCode among them — alongside Claude, ChatGPT, Cursor, Microsoft Copilot, and the Elaichi Agent. The tools on offer and the access behind them are identical whichever client asks. Only the setup screen differs.

Is Elaichi an alternative to Zapier MCP for dbt Labs?

Yes. Both let Claude, ChatGPT or Cursor use dbt Labs. Zapier MCP fits a team that already automates in Zapier, since each person signs in and acts as themselves in that account. Elaichi fits when IT wants one address for the whole company, per-tool rules by role, and a record of every dbt Labs call.

How is Elaichi different from Composio for dbt Labs?

Composio gives AI agents tools and sign-in handling across 1,000+ apps, for developers building agents or people using an assistant, billed per tool call. Elaichi gives a company's own people governed access to dbt Labs: one address, restrictions per role or user, and $15 per user per month. Both have role permissions and a log of every call.

Put dbt Labs in front of your team

14 days of Black, no credit card. Connect it once and pick what each team can call.

When the trial ends, nothing is deleted. You move to the free Personal plan, and connections, roles and the audit log stay where they are.

Add one link to your AI app

The same link for everyone on your team.

https://api.elaichi.ai/mcp
  • ChatGPT
  • Claude
  • Cursor
  • Microsoft Copilot