dbt agent skills for Claude Code, Cursor and RevampKey

4 ready-made playbooks that teach an AI agent how to do real dbt work: which tools to call, what to check first, and when to stop and ask you.

Download RevampKey, free I have it: connect dbt

Connect dbt once and all 4 skills install themselves and stay up to date. Mac, Windows and Linux.

All 4 dbt skills

Each skill is one job. You ask in plain words and the agent loads the skill that matches, then follows its steps.

Start hereAsks before writing18 dbt tools

Use the dbt MCP server well and safely

Sets up how an AI assistant connects to your dbt project, picks the right dbt tool for each question, and keeps results small. It asks before running anything that changes data or switches environments.

Use it when

You have just connected dbt and want to know what the assistant can do.
A dbt tool is missing or returns an error and you want to know why.
You want to query dbt metrics or metadata without accidentally using the wrong environment.

Tools it uses

list_metrics
get_dimensions
get_dimension_values
query_metrics
list_saved_queries
get_model_details
get_model_parents
get_model_children
get_lineage
get_all_models
get_mart_models
get_model_health
get_model_performance
get_exposures
execute_sql
text_to_sql
get_all_sources
get_all_macros

Example

Connect to our dbt project and tell me which environment you are querying and what you can do with it.

You are querying the production environment of the analytics project through the remote server. I can read metrics, metadata and lineage, and run SQL. I cannot run dbt builds on this setup. I found 214 models in the project and 38 metrics; I will filter before listing them in full.

Use in RevampKeyRead the full skill →

Asks before writing14 dbt tools

Find the right dbt model, mart or metric

Finds the dbt model, mart, source or metric that answers a warehouse question, and explains why it is the canonical choice over the alternatives. It reads metadata and health before recommending anything, and makes no changes.

Use it when

You need to know which table holds a number before you build on it.
Several models look similar and you want to know which one the team relies on.
You want to confirm a column's meaning before using it.

Tools it uses

list_metrics
list_saved_queries
get_all_models
get_mart_models
get_all_sources
get_entities
get_dimensions
get_related_models
get_model_details
get_model_health
get_model_performance
get_model_parents
get_dimension_values
execute_sql

Example

Where do I find monthly recurring revenue per customer in our dbt project?

The best match is the governed metric monthly_recurring_revenue, which is exposed at one row per customer per month. I rejected the staging model stg_subscriptions because it is a cleaning step, and a legacy mart named mrr_old because it has no recent runs. Its column descriptions are complete and the last run succeeded yesterday.

Use in RevampKeyRead the full skill →

Asks before writing10 dbt tools

Answer business questions with dbt metrics

Answers a business question with a governed dbt metric or saved query through the Semantic Layer, checking grain, dimensions and filters, and falling back to SQL only when the metric layer cannot answer.

Use it when

A finance lead asks for last quarter's net revenue by region and wants it to match the dashboard.
A product manager asks how many active users signed up in a given month.
An analyst asks for churn broken down by plan, and needs to know which definition is official.

Tools it uses

list_metrics
list_saved_queries
get_entities
get_dimensions
get_dimension_values
query_metrics
get_metrics_compiled_sql
text_to_sql
execute_sql
get_model_details

Example

What was net revenue by region last quarter? It should match the finance dashboard.

Net revenue last quarter was $4.2M. I used the governed net_revenue saved query, grouped by region, for Jan 1 to Mar 31 on the calendar quarter. EMEA contributed $1.9M, NA $1.6M and APAC $0.7M, which adds to the total. The dimension values matched the stored region names, and the compiled SQL excludes internal test accounts as the metric defines.

Use in RevampKeyRead the full skill →

Read-only15 dbt tools

Analyse the impact of a dbt model change before you make it

Traces what depends on a dbt model, source or macro through lineage, children and exposures, and rates how risky the change is. It reads the graph and does not edit your project.

Use it when

Before renaming or dropping a column in a shared model
Checking which dashboards a refactor of an intermediate model would affect
Assessing whether a macro edit is safe across the whole project

Tools it uses

get_model_details
get_all_sources
get_macro_details
get_model_children
get_lineage
get_mart_models
get_related_models
get_model_parents
get_exposures
get_exposure_details
list_metrics
get_dimensions
get_entities
get_model_health
get_model_performance

Example

What would break if I rename customer_id to account_id in stg_orders?

stg_orders feeds 4 direct children and 9 downstream models across 2 marts. The rename is a breaking shape change, so risk is high. The orders_by_region exposure reads customer_id directly and will fail until it is updated. I suggest adding account_id beside the old column, moving the two marts across, then removing customer_id.

Use in RevampKeyRead the full skill →

Get all 4 without copying a file

RevampKey adds the skills when you connect dbt, updates them for you and removes them when you disconnect.

Download RevampKey

How dbt skills work

Connect dbt
The dbt MCP server gives the agent its tools.
Ask in plain words
“Where do I find monthly recurring revenue per customer in our dbt project?” Each SKILL.md says when it applies, so only the one that fits is loaded.
Approve any change
The agent calls the tools in order, checks its work, and shows you any change before it makes it.

How to install dbt skills

In RevampKey the skills install themselves when you connect dbt. In other tools each skill is one folder with a SKILL.md file, and you also need the dbt MCP server connected there.

About 1 minute · nothing to copy

Download RevampKey for Mac, Windows or Linux and sign in.
Open Connectors and connect dbt. All 4 skills come with it and stay up to date; they go away when you remove the connector.
Ask in plain language, for example “Where do I find monthly recurring revenue per customer in our dbt project?”
Download RevampKeyConnect dbt · 1 click
Get RevampKey to connect dbt
RevampKey is a free desktop app for Mac, Windows and Linux. Install it, sign in, and dbt is one click away with its skills already attached.
Download RevampKey
Not now? Use the skills in your current tool
for s in essentials data-discovery metric-question-answering model-impact-analysis; do curl -fsSL --create-dirs -o .claude/skills/dbt-$s/SKILL.md https://revampkey.com/marketplace/dbt/skills/$s/SKILL.md done
Other tools

Into this project’s .claude/skills folder

Connect the dbt MCP server in Claude Code.

Run this in your project folder to add all 4 skills:

for s in essentials data-discovery metric-question-answering model-impact-analysis; do
  curl -fsSL --create-dirs -o .claude/skills/dbt-$s/SKILL.md https://revampkey.com/marketplace/dbt/skills/$s/SKILL.md
done

Ask in plain language, for example “Where do I find monthly recurring revenue per customer in our dbt project?”

Into the shared .agents/skills folder

Connect the dbt MCP server in Cursor.

Run this in your project folder to add all 4 skills:

for s in essentials data-discovery metric-question-answering model-impact-analysis; do
  curl -fsSL --create-dirs -o .agents/skills/dbt-$s/SKILL.md https://revampkey.com/marketplace/dbt/skills/$s/SKILL.md
done

Ask in plain language, for example “Where do I find monthly recurring revenue per customer in our dbt project?”

Into the shared .agents/skills folder

Connect the dbt MCP server in Codex.

Run this in your project folder to add all 4 skills:

for s in essentials data-discovery metric-question-answering model-impact-analysis; do
  curl -fsSL --create-dirs -o .agents/skills/dbt-$s/SKILL.md https://revampkey.com/marketplace/dbt/skills/$s/SKILL.md
done

Ask in plain language, for example “Where do I find monthly recurring revenue per customer in our dbt project?”

Into the shared .agents/skills folder

Connect the dbt MCP server in VS Code.

Run this in your project folder to add all 4 skills:

for s in essentials data-discovery metric-question-answering model-impact-analysis; do
  curl -fsSL --create-dirs -o .agents/skills/dbt-$s/SKILL.md https://revampkey.com/marketplace/dbt/skills/$s/SKILL.md
done

Ask in plain language, for example “Where do I find monthly recurring revenue per customer in our dbt project?”

RevampKey or copy the files?

In RevampKey

One click when you connect dbt
Updated for you when a skill improves
Removed when you disconnect
The MCP server is set up for you
800+ other connectors, same way

Download free

Copy into your project

One command per project
Run it again to get updates
You connect the dbt MCP server yourself
Works in Claude Code, Cursor, Codex and VS Code

See the command

dbt skills FAQ

What is a dbt agent skill?

A SKILL.md file: a short playbook an AI agent loads when your request matches it. Each dbt skill describes one job, which dbt tools to use in which order, what to check first and when to stop and ask you.

Do the dbt skills change anything on their own?

1 of the 4 only read. The others tell the agent to show you the change and wait for a yes before it creates, edits or deletes anything in dbt.

Which tools can use these skills?

Any agent that reads the open Agent Skills format: Claude Code, Cursor, Codex, VS Code with Copilot and RevampKey. In RevampKey they are attached when you connect dbt; elsewhere you copy the folders into your project or skills directory.

Do I need the dbt MCP server too?

Yes. The skills tell the agent how to do the work; the dbt MCP server gives it the tools to do it. The dbt MCP setup guide covers every client.

dbt MCP server setup · This page as Markdown

Put dbt’s best workflows in your agent

Download RevampKey, connect dbt and ask your first question in about a minute.

Download RevampKey Connect dbt · 1 click

All 4 dbt skills

Use the dbt MCP server well and safely

Use it when

Tools it uses

Find the right dbt model, mart or metric

Use it when

Tools it uses

Answer business questions with dbt metrics

Use it when

Tools it uses

Analyse the impact of a dbt model change before you make it

Use it when

Tools it uses

Get all 4 without copying a file

How dbt skills work

How to install dbt skills

RevampKey or copy the files?

In RevampKey

Copy into your project

dbt skills FAQ

Put dbt’s best workflows in your agent

Skills for related tools