Acme

Built with
Ever Works
Ever Works

Connect with us

Stay Updated

Get the latest updates and exclusive content delivered to your inbox.

Product

  • Categories
  • Tags
  • Pricing
  • Help

Clients

  • Sign In
  • Register
  • Forgot password?

Company

  • About Us
  • Admin
  • Sitemap

Resources

  • Blog
  • Submit
  • API Documentation
All product names, logos, and brands are the property of their respective owners. All company, product, and service names used in this repository, related repositories, and associated websites are for identification purposes only. The use of these names, logos, and brands does not imply endorsement, affiliation, or sponsorship. This directory may include content generated by artificial intelligence.
Copyright © 2025 Acme. All rights reserved.·Terms of Service·Privacy Policy·Cookies
  1. Home
  2. Data Access & Integration Mcp Servers
  3. dbt-mcp

dbt-mcp

The official MCP server for dbt (data build tool), providing integration with dbt Core/Cloud, metadata discovery, model info, and semantic layer querying.

🌐Visit Website

About this tool

Surveys

Loading more......

Information

Websitegithub.com
PublishedMay 14, 2025

Categories

1 Item
Data Access & Integration Mcp Servers

Tags

5 Items
#mcp
#dbt
#data-integration
#metadata
#data-analysis

Similar Products

6 result(s)
mcp-flowcore-platform

An MCP server enabling interaction with Flowcore for data ingestion, analysis, and cross-referencing, utilizing human language to manage data across public and private data cores.

databricks-genie-mcp

A server implementing the MCP protocol to connect with Databricks Genie API, enabling LLMs to ask questions, execute SQL, and interact with Databricks conversational agents.

Excel-MCP

Allows LLMs to read and write data to Excel spreadsheets through MCP, supporting data analysis, manipulation, and integration with other systems.

graphlit-server

A Model Context Protocol (MCP) Server that integrates MCP clients with the Graphlit service, allowing ingestion and retrieval of diverse data sources. Demonstrates a robust MCP server implementation for data integration and search.

mcp-google-sheets

MCP server for Google Sheets, providing tools to create, read, update, and manage spreadsheets via the Google Sheets API.

modbus-mcp

An MCP server for standardizing and contextualizing industrial Modbus data through the Model Context Protocol.

dbt-mcp

Source Code

Description

dbt-mcp is an open-source MCP (Model Context Protocol) server designed for integration with dbt (data build tool). It enables interaction with dbt resources, providing metadata discovery, model information, and semantic layer querying capabilities. It works with both dbt Core and dbt Cloud environments.

Features

Integration with dbt

  • Connects to both dbt Core and dbt Cloud installations
  • Allows running commands through the local dbt Core or dbt Cloud CLI

Model Information and Metadata Discovery

  • Retrieve information about models and transformations in a dbt project
  • Discovery API:
    • get_mart_models: Fetch all mart models
    • get_all_models: Fetch all models
    • get_model_details: Fetch details for a specific model
    • get_model_parents: Fetch parent models of a specific model

Semantic Layer Querying

  • Interact with the dbt Cloud Semantic Layer gateway
  • Retrieve and query analytics metrics and dimensions:
    • list_metrics: List all defined metrics
    • get_dimensions: Get dimensions for specified metrics
    • get_entities: Get entities for specified metrics
    • query_metrics: Query metrics with grouping, ordering, filtering, and limiting

dbt CLI Command Support

  • build: Execute models, tests, snapshots, and seeds
  • compile: Generate executable SQL from models, tests, and analyses
  • docs: Generate documentation for the dbt project
  • ls: List resources in the dbt project
  • parse: Parse and validate project files for syntax
  • run: Execute models to materialize them in the database
  • test: Run tests to validate data and model integrity
  • show: Run a query against the data warehouse

Flexible Configuration

  • Enable or disable CLI, Semantic Layer, and Discovery features via environment variables
  • Support for multi-cell dbt Cloud configurations
  • Customizable connection and authentication settings

Client Integrations

  • Can be used with MCP clients such as Claude Desktop, Cursor, and VS Code
  • Example configurations provided for client setup

Installation and Setup

  • Easy installation via shell script or manual setup
  • Environment variable-based configuration

Pricing

No pricing information is provided; dbt-mcp is an open-source project.

Tags

mcp, dbt, data-integration, metadata, data-analysis