{"id":"astoriel-dbt-doctor","name":"dbt-doctor","af_score":59.5,"security_score":57.2,"reliability_score":25.0,"what_it_does":"dbt-doctor is a Python Model Context Protocol (MCP) server that connects an AI assistant to a dbt project to audit project quality, profile warehouse data, detect schema drift vs manifest.json, suggest dbt tests, and update schema.yml non-destructively via ruamel.yaml.","best_when":"You want an AI-assisted, conversational workflow for dbt project auditing and schema.yml governance using MCP, with access to a reachable data warehouse and a compiled dbt target/manifest.json.","avoid_when":"You cannot allow read-only warehouse querying or schema.yml rewriting (even if non-destructive/append-only), or you require a standard HTTP API surface with OpenAPI/SDKs rather than MCP.","last_evaluated":"2026-03-30T13:49:39.478129+00:00","has_mcp":true,"has_api":false,"auth_methods":["MCP server run locally via CLI/args"],"has_free_tier":false,"known_gotchas":["Requires `dbt compile` prior to usage so `target/manifest.json` exists.","`execute_query` depends on being able to perform read-only SQL against the configured warehouse; failures likely occur if credentials/network permissions are missing.","YAML updates depend on having writable access to schema.yml files; ensure filesystem permissions and review diffs before commit.","Tool coverage: only the listed MCP tools are described; if the assistant requests additional operations, capability gaps may surface as errors."],"error_quality":0.0}