data-api-builder vs dbt-mcp
Side-by-side comparison to help you pick between these two MCP servers.
data-api-builder by Azure | dbt-mcp by dbt-labs | |
|---|---|---|
| Stars | ★ 1,410 | ★ 562 |
| 30d uses | — | — |
| Score | 53 | 53 |
| Official | — | — |
| Categories | DatabaseDeveloper ToolsCloud Storage | DatabaseDeveloper ToolsAI / LLM Tools |
| Language | C# | Python |
| Last commit | this month | this month |
data-api-builder · Summary
Azure's Data API Builder provides REST and GraphQL endpoints for Azure databases with upcoming MCP tools support.
dbt-mcp · Summary
A comprehensive MCP server for dbt Core, Fusion, and Platform, providing SQL, semantic layer, and dbt CLI tools.
data-api-builder · Use cases
- Create REST and GraphQL APIs for Azure databases
- Build secure data access layers for applications
- Generate API endpoints for on-premises databases in any cloud
dbt-mcp · Use cases
- AI-powered data analysis and SQL generation in dbt projects
- Automating dbt project documentation and model lineage analysis
- Integrating dbt with AI agents for automated data modeling and testing
data-api-builder · Install
- Install .NET 8 or later runtime: https://get.dot.net
- Install the DAB command line tool:
``sh dotnet tool install microsoft.dataapibuilder -g ``
- Initialize and configure DAB with:
``sh dab init --database-type mssql --connection-string "@env('my-connection-string')" --host-mode development ``
- Add your database entities and start the server:
``sh dab add Todo --source "dbo.Todo" --permissions "anonymous:*" dab start ``
dbt-mcp · Install
Installation
Claude Desktop
Add to your Claude Desktop configuration:
{
"mcpServers": {
"dbt": {
"command": "npx",
"args": ["@dbt-labs/dbt-mcp"],
"env": {
"DBT_PROJECT_DIR": "/path/to/your/dbt/project"
}
}
}
}Other MCP clients
Use the experimental MCP bundle (dbt-mcp.mcpb) available in the latest release assets. Follow the [mcpb CLI](https://github.com/modelcontextprotocol/mcpb) documentation to install or inspect the bundle.
npm install -g @modelcontextprotocol/mcpb
mcpb install https://github.com/dbt-labs/dbt-mcp/releases/download/vX.X.X/dbt-mcp.mcpb