MCPApps.net logoMCPapps.net
 

dbt MCP ServerServer

integrations
GitHub
data transformationdbtdata analytics

Loading subscription status...

💡 Description

The dbt MCP Server is a platform that allows AI agents to interact with dbt projects and execute dbt CLI commands, thus facilitating the transformation of data in data warehouses through SQL. It provides tools for managing data workflows, executing commands, and accessing project metadata.

📝 JSON Entries

{
  "mcpServers": [
    {
      "dbt_server": {
        "env": {
          "DBT_PROFILE": "<DBT_Profile_Name>"
        },
        "args": [
          "run",
          "--profiles-dir",
          "<Dbt_Profile_Path>"
        ],
        "command": "dbt"
      }
    }
  ]
}

🛠️ Tools

dbt CLIdbt Semantic Layer

⚡ Features

  • Execute dbt CLI commands
  • Access Semantic Layer
  • Explore models and their relationships

💬 Example Queries

  • Execute dbt run command
  • Get a list of all models in the dbt project
  • Compile a dbt project