{"id":"niclasolofsson-dbt-core-mcp","name":"dbt-core-mcp","homepage":null,"repo_url":"https://github.com/NiclasOlofsson/dbt-core-mcp","category":"devtools","subcategories":[],"tags":["mcp","dbt","data-analytics","developer-tools","python","model-context-protocol","lineage","impact-analysis"],"what_it_does":"A Model Context Protocol (MCP) server that lets AI assistants interact with dbt projects: inspect project/resource metadata (models, sources, seeds, snapshots, tests), analyze lineage and impact, and run dbt commands/queries using the user’s existing dbt/adapter/environment via “bridge execution” (no dbt-core/adapters required on the server).","use_cases":["Ask questions about dbt projects (models, sources, tests) and retrieve compiled SQL/metadata","Lineage and impact analysis prior to changes (what is upstream/downstream of a resource)","Run smart dbt builds and tests for changed models and downstream dependencies","Debug transformations by inspecting compiled SQL and (claimed) CTE-level details","Validate connection/environment via dbt debug through the tooling"],"not_for":["Running or introspecting non-SQL dbt models (Python models are explicitly not supported)","Scenarios requiring a hosted SaaS API with centralized authentication/quotas (this is local/workspace-oriented tooling)","Production workflows that need strong enterprise security guarantees without additional hardening/controls around dbt execution and database credentials"],"best_when":"You have a local dbt project and want an agent to safely operate within your environment (workspace directory, dbt version, adapter, and credentials) to inspect metadata and execute dbt commands.","avoid_when":"You cannot grant the agent permission to run dbt commands against your data warehouses (or you require strict restrictions on execution). Also avoid if your dbt project relies heavily on Python models.","alternatives":["dbt Power User (Copilot) / other Copilot-oriented dbt helpers","dbt CLI with a custom agent wrapper (run dbt compile/list/ls/test via tooling)","Direct querying of dbt artifacts (manifest.json/catalog.json) with a custom script","dbt Cloud APIs (for hosted contexts) plus a separate MCP/agent integration layer"],"af_score":53.2,"security_score":27.5,"reliability_score":35.0,"package_type":"mcp_server","discovery_source":["github"],"priority":"high","status":"evaluated","version_evaluated":null,"last_evaluated":"2026-03-30T15:42:07.346349+00:00","interface":{"has_rest_api":false,"has_graphql":false,"has_grpc":false,"has_mcp_server":true,"mcp_server_url":null,"has_sdk":false,"sdk_languages":[],"openapi_spec_url":null,"webhooks":false},"auth":{"methods":["No explicit auth mechanism described for the MCP server itself; uses the user’s local dbt configuration/credentials to connect to the target warehouse during dbt execution."],"oauth":false,"scopes":false,"notes":"The README focuses on local execution and workspace detection rather than MCP/API authentication. Security therefore depends on your local environment, dbt profiles/credentials, and MCP client/host access controls."},"pricing":{"model":null,"free_tier_exists":false,"free_tier_limits":null,"paid_tiers":[],"requires_credit_card":false,"estimated_workload_costs":null,"notes":"No pricing information provided; repository appears to be an MIT-licensed open source tool installed locally."},"requirements":{"requires_signup":false,"requires_credit_card":false,"domain_verification":false,"data_residency":[],"compliance":[],"min_contract":null},"agent_readiness":{"af_score":53.2,"security_score":27.5,"reliability_score":35.0,"mcp_server_quality":72.0,"documentation_accuracy":60.0,"error_message_quality":0.0,"error_message_notes":null,"auth_complexity":80.0,"rate_limit_clarity":5.0,"tls_enforcement":20.0,"auth_strength":25.0,"scope_granularity":10.0,"dependency_hygiene":55.0,"secret_handling":35.0,"security_notes":"No explicit transport/authentication controls are documented for the MCP server. The primary security risk is that the agent can cause execution of dbt commands against configured warehouses, potentially using sensitive credentials from local dbt profiles. Dependency hygiene appears moderate (explicit pins include psutil==7.2.1; other deps are unpinned). TLS and secret-handling behavior are not documented in the provided content.","uptime_documented":0.0,"version_stability":55.0,"breaking_changes_history":45.0,"error_recovery":40.0,"idempotency_support":"false","idempotency_notes":null,"pagination_style":"none","retry_guidance_documented":false,"known_agent_gotchas":["Executing dbt commands can be long-running and can fail due to warehouse/adapter/auth/profile issues; the server mentions optional timeouts for dbt commands.","Only SQL models are supported; Python models are not.","The tool may trigger dbt compile when requesting compiled SQL (can be expensive/time-consuming and may require access to your project and dependencies)."]}}