dbt-labs/dbt-mcp
Official MCP server for dbt (data build tool) providing integration with dbt Core/Cloud CLI, project metadata discovery, model information, and semantic layer querying capabilities.
Ads
Overview
Official MCP server for dbt (data build tool) providing integration with dbt Core/Cloud CLI, project metadata discovery, model information, and semantic layer querying capabilities.
Capabilities
- get_all_models
Explore your dbt project’s data models — ask for all models with `get_all_models`, then inspect any node’s full details via `get_node_details`.
- get_lineage
Trace upstream and downstream lineage — use `get_lineage` to see ancestors and descendants for a model, filtered by type and depth.
- list_metrics
Query metrics through the Semantic Layer — list available metrics with `list_metrics`, then run filtered, grouped metric queries via `query_metrics`.
- get_model_health
Check model health and performance — retrieve run status, test results, and source freshness with `get_model_health`, or get execution history via `get_model_performance`.
- generate_model_yaml
Generate project boilerplate — create model YAML, source YAML, or staging model SQL using `generate_model_yaml`, `generate_source`, and `generate_staging_model`.
- list_jobs
Manage dbt Cloud jobs — list and trigger jobs with `list_jobs` and `trigger_job_run`, then inspect run details or artifacts using `get_job_run_details` and `list_job_run_artifacts`.
Tags
- database
- analytics
- data-analysis
- sql
- devops-infrastructure
- awesome-list
Related MCP servers
Data Platforms
r3dz4r/datapulse-my
Trust layer for 418 official Malaysian public datasets — freshness, licence, provenance, drift and signed-evidence checks, with an offline-verifiable attestation chain. Remote streamable-http at https://mcp.data-pulse.my/mcp, no API key.
Data Platforms
mbrummerstedt/powerbi-analyst-mcp
Connect LLMs to Power BI semantic models. Browse workspaces, tables, and measures, run DAX queries, and automatically page large results via local CSV.
Data Platforms
alanpcf/brasil-data-mcp
Brazilian public data for AI agents — companies (CNPJ), addresses (CEP), banks (BACEN), national holidays — via [BrasilAPI](https://brasilapi.com.br). No auth, no API key. Install: `npx -y brasil-data-mcp`.
Data Platforms
yashshingvi/databricks-genie-MCP
A server that connects to the Databricks Genie API, allowing LLMs to ask natural language questions, run SQL queries, and interact with Databricks conversational agents.
Data Platforms
soil-dev/capsulemcp
MCP server for [Capsule CRM](https://capsulecrm.com). 81 tools (49 in read-only mode) covering contacts, opportunities, projects, tasks, timeline activity, structured + saved filters, workflow tracks, and file attachments. Two transports — stdio (`npx capsulemcp`) and HTTP+OAuth for hosted Custom Connectors. Read-only-mode env flag for safer defaults. Apache 2.0.
Data Platforms
Osseni94/oyemi-mcp
Deterministic semantic word encoding and valence/sentiment analysis using 145K+ word lexicon. Provides word-to-code mapping, semantic similarity, synonym/antonym lookup with zero runtime NLP dependencies.
Data Platforms
paracetamol951/caisse-enregistreuse-mcp-server
Allows you to automate or monitor business operations, sales recorder, POS software, CRM.
Data Platforms
keboola/keboola-mcp-server
interact with Keboola Connection Data Platform. This server provides tools for listing and accessing data from Keboola Storage API.
6 tools · Build workflow pipelines, Control tool access