dbt-mcp vs filesystem
Side-by-side comparison to help you pick between these two MCP servers.
dbt-mcp by dbt-labs | filesystem by modelcontextprotocol | |
|---|---|---|
| Stars | ★ 562 | ★ 85,748 |
| 30d uses | — | — |
| Score | 53 | 77 |
| Official | — | ✓ |
| Categories | DatabaseDeveloper ToolsAI / LLM Tools | File SystemDeveloper ToolsProductivity |
| Language | Python | TypeScript |
| Last commit | this month | this month |
dbt-mcp · Summary
A comprehensive MCP server for dbt Core, Fusion, and Platform, providing SQL, semantic layer, and dbt CLI tools.
filesystem · Summary
A feature-rich MCP server for filesystem operations with dynamic directory access control.
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
filesystem · Use cases
- Enable AI models to read and write project files during development
- Allow Claude or other MCP clients to browse and analyze codebases
- Provide secure sandboxed access to specific directories for content generation
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.mcpbfilesystem · Install
Installation
Using NPX
{
"mcpServers": {
"filesystem": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-filesystem",
"/path/to/allowed/directory"
]
}
}
}Using Docker
{
"mcpServers": {
"filesystem": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"--mount", "type=bind,src=/path/to/allowed/dir,dst=/projects/allowed/dir",
"mcp/filesystem",
"/projects"
]
}
}
}VS Code Extension
Click the installation buttons in the README to install directly in VS Code.