dbt MCP Server vs AWS Knowledge MCP
A side-by-side comparison of two AI, Data & Knowledge servers — tools, transport, auth, maintenance, and copy-paste config for each.
| dbt MCP Server Give AI agents context of your dbt project — run dbt CLI, query the Semantic Layer, explore lineage, and manage jobs. Unverified stdio (local) API key Python | AWS Knowledge MCP Fully managed remote server for AWS docs, blogs, What's-New and Well-Architected guidance — no key. Verified HTTP (remote) No auth Hosted | |
|---|---|---|
| Category | AI, Data & Knowledge | AI, Data & Knowledge |
| Language | Python | Hosted |
| Transport | stdio (local) | HTTP (remote) |
| Auth | API key | None |
| GitHub stars | 584 | 7.0k |
| Last commit | 1 day ago | 5 months ago |
| Verified | ||
| Actively maintained | ||
| Install | uvx dbt-mcp | Add URL https://knowledge-mcp.global.api.aws as an HTTP MCP server |
| Repo | Open | Open |
Verdict
Pick dbt MCP Server if you want a local (stdio) server that keeps data on your machine, and you need the broadest set of tools.
Pick AWS Knowledge MCP if you want the official, vendor-maintained server, and you prefer the more popular, battle-tested option.
Add dbt MCP Server
uvx dbt-mcpPaste into ~/Library/Application Support/Claude/claude_desktop_config.json
{
"mcpServers": {
"dbt-mcp-server": {
"command": "uvx",
"args": [
"dbt-mcp"
],
"env": {
"DBT_HOST": "cloud.getdbt.com",
"DBT_PROD_ENV_ID": "your-production-environment-id",
"DBT_DEV_ENV_ID": "your-development-environment-id",
"DBT_USER_ID": "your-user-id",
"DBT_TOKEN": "your-service-token-or-pat",
"DBT_PROJECT_DIR": "/path/to/your/dbt/project",
"DBT_PATH": "/path/to/your/dbt/executable"
}
}
}
}Requires `uv` (the Python package runner). Install it from https://docs.astral.sh/uv/ if `uvx` is not found.
Add AWS Knowledge MCP
Add URL https://knowledge-mcp.global.api.aws as an HTTP MCP serverPaste into ~/Library/Application Support/Claude/claude_desktop_config.json
{
"mcpServers": {
"aws-knowledge-mcp": {
"command": "npx",
"args": [
"-y",
"mcp-remote",
"https://knowledge-mcp.global.api.aws"
]
}
}
}Claude Desktop connects to remote servers through the `mcp-remote` proxy (installed on first run via npx). Restart Claude Desktop after saving.
FAQ
dbt MCP Server or AWS Knowledge MCP — which is better?
Pick dbt MCP Server if you want a local (stdio) server that keeps data on your machine, and you need the broadest set of tools. Pick AWS Knowledge MCP if you want the official, vendor-maintained server, and you prefer the more popular, battle-tested option.
Can I use both dbt MCP Server and AWS Knowledge MCP?
Yes — MCP clients let you enable multiple servers at once. Add both configs to your client's mcpServers and use whichever tool fits the task.
Do dbt MCP Server and AWS Knowledge MCP work with Claude, Cursor and Windsurf?
Both do. Copy the per-client config below into Claude Desktop, Cursor, or Windsurf.