generate_dbt_model · Claude MCP Data Engineer Server MCP

WHAT IT DOES

What generate_dbt_model does on Claude MCP Data Engineer Server

AI agents use generate_dbt_model to create or update resources in Claude MCP Data Engineer Server — usually the action step of a workflow, after the agent has gathered context. Every call changes real data in your Claude MCP Data Engineer Server environment.

WHY IT NEEDS A POLICY

Why generate_dbt_model needs a policy

The tool creates or generates a new dbt model file. This is a reversible write operation (the generated file can be deleted or modified). It doesn't execute arbitrary code, delete data, or move money. While it could potentially cause issues if the generated SQL is flawed, the primary action is file creation/writing.

From the tool's definition Tool generates a dbt model SQL file, which creates a new file artifact. The description states 'Generate a basic dbt model SQL file with source reference' — this is file creation/modification rather than retrieval.

Attacks that exploit this kind of access

Recommended rule Ready

Verdict

generate_dbt_model Rate-limited

generate_dbt_model stays usable, but capped — an agent stuck in a loop can't make hundreds of changes a minute. Everything else on the server is denied unless you say otherwise.

View as policy code

policy.json

{
  "version": "1",
  "default": "deny",
  "tools": {
    "generate_dbt_model": {
      "limits": [
        {
          "counter": "generate_dbt_model_rate",
          "window": "minute",
          "max": 30,
          "scope": "grant"
        }
      ]
    }
  }
}

LIMIT THIS TOOL →

Instant setup, no code required.

PolicyLayer is an MCP gateway: every tool call is checked against your rule before it reaches Claude MCP Data Engineer Server, so you can run agents against it safely.

FAQ

Questions about generate_dbt_model

What does the generate_dbt_model tool do? +

Generate a basic dbt model SQL file with source reference,. It is categorised as a Write tool in the Claude MCP Data Engineer Server MCP Server, which means it can create or modify data. Consider rate limits to prevent runaway writes.

How do I enforce a policy on generate_dbt_model? +

Register the Claude MCP Data Engineer Server MCP server in PolicyLayer and add a rule for generate_dbt_model: allow, deny, rate-limit, or require approval. Point your MCP client at the PolicyLayer proxy URL and the rule is enforced on every call, before it reaches Claude MCP Data Engineer Server. Nothing to install.

What risk level is generate_dbt_model? +

generate_dbt_model is a Write tool with medium risk. Write tools should be rate-limited to prevent accidental bulk modifications.

Can I rate-limit generate_dbt_model? +

Yes. Add a rate_limit block to the generate_dbt_model rule in your PolicyLayer policy. For example, setting max: 10 and window: 60 limits the tool to 10 calls per minute. Rate limits are tracked per agent session and reset automatically.

How do I block generate_dbt_model completely? +

Set action: deny in the PolicyLayer policy for generate_dbt_model. The AI agent will receive a policy violation error and cannot call the tool. You can also include a reason field to explain why the tool is blocked.

What MCP server provides generate_dbt_model? +

generate_dbt_model is provided by the Claude MCP Data Engineer Server MCP server (itsnikhile/claude-mcp-data-engineer). PolicyLayer sits as a proxy in front of this server to enforce policies before tool calls reach the server.