dbt-doctor
★ 138
vs
fastmcp
★ 25.4k
dbt-doctor vs fastmcp
dbt-doctor: dbt-doctor is an MCP server that gives AI coding assistants deep awareness of dbt project health. It enables natural language auditing, profiling, schema drift detection, and auto-documentation without manual CLI commands. It complements the official dbt-labs/dbt-mcp by focusing on analysis and generation rather than execution.; fastmcp: FastMCP is a standard framework for building Model Context Protocol (MCP) applications, which connect LLMs to tools and data. It simplifies the process by automatically generating schemas, validation, and documentation for tools, and managing transport negotiation and authentication for server connections. FastMCP offers a comprehensive solution for developing, deploying, and scaling MCP-powered systems.
01
TL;DR
Choose dbt-doctor if…Auto-document the worst covered model in a project with a single AI request.
Choose fastmcp if…Building LLM applications that interact with custom tools and data sources
02
Side-by-Side Comparison
03
Features
dbt-doctor01Project Auditing: score project 0–100% on documentation, testing, and naming conventions with ranked worst models.
02Data Profiling: single-pass column statistics (NULL rate, cardinality, min/max, uniqueness) using batched SQL queries.
03Schema Drift Detection: compare current warehouse columns against manifest.json to detect added, removed, or type-changed columns.
04Intelligent Test Suggestions: convert profile statistics into concrete dbt test recommendations (e.g., not_null, unique, accepted_values).
05Non-Destructive YAML Writing: update schema.yml files preserving hand-written comments and formatting using ruamel.yaml.
fastmcp01Automatic schema, validation, and documentation generation for tools
02Managed transport negotiation, authentication, and protocol lifecycle for server connections
03Wraps Python functions into MCP-compliant tools, resources, and prompts (Servers)
04Connects to any MCP server with full protocol support (Clients)
05Provides interactive UIs for tools rendered directly in conversations (Apps)
04
Use Cases
dbt-doctor↳Auto-document the worst covered model in a project with a single AI request.
↳Detect schema drift before deployment by comparing warehouse columns to the manifest.
↳Perform DAG health checks to identify orphans, high fan-out, and structural issues.
fastmcp↳Building LLM applications that interact with custom tools and data sources
↳Creating interactive conversational UIs for backend functionalities
↳Developing and deploying scalable MCP servers and clients
05
Best For
dbt-doctorTrendingRAG / Knowledge BaseSecurity & Safety
fastmcpMost PopularDev ToolingLLM Infra
FAQ
FAQ
What is the difference between dbt-doctor and fastmcp?
Both dbt-doctor and fastmcp are in the RAG / Knowledge Base category. dbt-doctor has 138 stars, while fastmcp has 25.4k stars.
Which is better, dbt-doctor or fastmcp?
The best choice depends on your use case. Choose dbt-doctor if Auto-document the worst covered model in a project with a single AI request., and fastmcp if Building LLM applications that interact with custom tools and data sources.
Is dbt-doctor free or open source?
Yes, dbt-doctor is open source on GitHub (MIT).
Is fastmcp free or open source?
Yes, fastmcp is open source on GitHub (Apache-2.0).
→