dbt MCP Server vs OpenMemory 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	OpenMemory MCP Mem0's local-first memory layer: a Dockerized MCP server plus dashboard that keeps agent memories on your machine. Unverified SSE (remote) API key Python
Category	AI, Data & Knowledge	AI, Data & Knowledge
Language	Python	Python
Transport	stdio (local)	SSE (remote)
Auth	API key	API key
GitHub stars	584	60k
Last commit	1 month ago	1 month ago
Verified
Actively maintained
Install	`uvx dbt-mcp`	`curl -sL https://raw.githubusercontent.com/mem0ai/mem0/main/openmemory/run.sh \| OPENAI_API_KEY=your_api_key bash`
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 OpenMemory MCP if you want the official, vendor-maintained server, and you prefer the more popular, battle-tested option.

Add dbt MCP Server

Install / run

uvx dbt-mcp

Paste 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 OpenMemory MCP

Install / run

curl -sL https://raw.githubusercontent.com/mem0ai/mem0/main/openmemory/run.sh | OPENAI_API_KEY=your_api_key bash

Paste into ~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "openmemory-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-remote",
        "http://localhost:8765/mcp/<client-name>/sse/<user-id>"
      ]
    }
  }
}

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 OpenMemory 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 OpenMemory 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 OpenMemory 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 OpenMemory MCP work with Claude, Cursor and Windsurf?

Both do. Copy the per-client config below into Claude Desktop, Cursor, or Windsurf.

View dbt MCP Server →View OpenMemory MCP →More comparisons →