Dbt vs Hindsight

A side-by-side look at the Dbt and Hindsight MCP servers: transport, auth, tools, quality signals, and the config to install either one in Claude, Cursor, Windsurf or VS Code.

Dbt logoDbtData Platforms · Local subprocess (stdio)dbt MCP — manifest/run_results/sources/catalog parsing + DQ result tables (BigQuery/Postgres)51GoodAuth: not declaredHindsight logoHindsightKnowledge & Memory · Local subprocess (stdio)Hindsight: Agent Memory That Works Like Human Memory - Built for AI Agents to manage Long Term Memory57GoodAuth: api key required

Verdict: choose Dbt for data platforms work as a local process; choose Hindsight for knowledge & memory as a local process. You can also run both side by side in one mcpServers block.

Which MCP server should you choose?

Dbt logoChoose Dbt when

  • You need dedicated capabilities in the Data Platforms domain.
  • You prefer a local stdio subprocess transport.
  • You have the keys it needs: DBT_PROJECT_DIR.
  • You want tools like dbt-list-models, dbt-get-model, dbt-list-tests.
Explore Dbt

Hindsight logoChoose Hindsight when

  • You need dedicated capabilities in the Knowledge & Memory domain.
  • You prefer a local stdio subprocess transport.
  • Its auth model fits you: API key required.
  • You have the keys it needs: HINDSIGHT_API_LLM_API_KEY, HINDSIGHT_API_LLM_PROVIDER, HINDSIGHT_DB_PASSWORD.
Explore Hindsight

Feature & specification comparison

Rows where the two servers differ are marked.

SpecDbt logoDbtHindsight logoHindsight
CategoryData PlatformsKnowledge & Memory
Quality signal51/100 · Good57/100 · Good
Install commandConfirmedConfirmed
TransportLocal subprocess (stdio)Local subprocess (stdio)
AuthNot declaredAPI key required
PricingNot declaredFree
Required env varsDBT_PROJECT_DIRHINDSIGHT_API_LLM_API_KEYHINDSIGHT_API_LLM_PROVIDERHINDSIGHT_DB_PASSWORD
Verified ownerCommunity listingCommunity listing
GitHub stars053,323
Directory activity 3 views 0 installs 0 upvotes 14 views 0 installs 0 upvotes
Tools26Not listed

Tools & capabilities

Dbt tools 26

  • dbt-list-models
  • dbt-get-model
  • dbt-list-tests
  • dbt-get-test
  • dbt-list-sources
  • dbt-get-source
  • dbt-list-exposures
  • dbt-list-macros
  • dbt-get-macro
  • dbt-list-runs
  • dbt-get-run-results
  • dbt-failed-tests
  • +14 more on the listing page

Hindsight tools

No tool names declared yet. Check the project README from the listing page.

Ready-to-paste client configs

Paste either block (or both) into your client config, e.g. claude_desktop_config.json or ~/.cursor/mcp.json. We only show a config when the install command is confirmed.

Dbt

mcpServers (Claude Desktop / Cursor)
{
  "mcpServers": {
    "dbt": {
      "command": "npx",
      "args": [
        "-y",
        "@us-all/dbt-mcp"
      ],
      "env": {
        "DBT_PROJECT_DIR": "YOUR_DBT_PROJECT_DIR_HERE"
      }
    }
  }
}

Hindsight

mcpServers (Claude Desktop / Cursor)
{
  "mcpServers": {
    "vectorize-io-hindsight": {
      "command": "npx",
      "args": [
        "-y",
        "@vectorize-io/hindsight-coding-agents"
      ],
      "env": {
        "HINDSIGHT_API_LLM_API_KEY": "YOUR_HINDSIGHT_API_LLM_API_KEY_HERE",
        "HINDSIGHT_API_LLM_PROVIDER": "YOUR_HINDSIGHT_API_LLM_PROVIDER_HERE",
        "HINDSIGHT_DB_PASSWORD": "YOUR_HINDSIGHT_DB_PASSWORD_HERE"
      }
    }
  }
}

Frequently asked questions

Dbt is categorized under Data Platforms and uses a local stdio subprocess. Hindsight belongs to Knowledge & Memory and uses a local stdio subprocess. Pick Dbt for data platforms work and Hindsight for knowledge & memory.

Copy the mcpServers block from the config section on this page into your client's config (for example claude_desktop_config.json or ~/.cursor/mcp.json), then fully restart the client.

Dbt has no declared pricing — check the project's own site. Hindsight is listed as free. Auth: api key required. If a server needs environment variables such as API keys, define them under the env key in your client's MCP config.

Yes. MCP clients support multiple servers: add dbt and vectorize-io-hindsight as separate keys in the same mcpServers object, and your assistant will call tools from either one.

On AllMCPs, Dbt has a quality signal of 51/100 (Good) with 3 views, 0 installs and 0 GitHub stars. Hindsight has 57/100 (Good) with 14 views, 0 installs and 53,323 GitHub stars.