Skip to content
MCP server

Shadowjoin

Local MCP server that measures how many matches an exact join silently drops

Runs locallyStatus and history
Install
Pricing
Open source
Platforms
CLI, self-hosted
Runs
Locally
Version
0.4.0
Listing updated
today

Similar MCP servers

About Shadowjoin

Shadowjoin is an open-source MCP server for analytics and data. It runs locally on your machine and is started by your AI client.

Joining two sources on a name, email or SKU quietly loses rows that differ only by punctuation, suffixes or word order. Shadowjoin runs a shadow matcher beside the real key, reports a lower bound on lost matches, and names the normalization rules that would recover them, in order of marginal gain. When you supply a ground-truth column it also checks whether the recoveries are right.

The README's worked examples include S&P 500 names against exchange listings, where an exact join found 1 match and the shadow join recovered 428, with 99.76% precision on verified rows. It also shows that applying every rule can recover nothing while a two-rule subset recovers five, and it separates mechanical misses from semantic ones such as Cape Verde versus Cabo Verde that need an alias table. Multi-column keys report which component disagreed.

It runs over stdio from npm with no postinstall script. SHADOWJOIN_CONFIG must point to a config file naming your data sources; connection strings stay in that file and never pass through a tool call.

Install

Run in a terminal

claude mcp add shadowjoin --env SHADOWJOIN_CONFIG='<SHADOWJOIN_CONFIG>' -- npx -y shadowjoin

Add to claude_desktop_config.json

{
  "mcpServers": {
    "shadowjoin": {
      "command": "npx",
      "args": [
        "-y",
        "shadowjoin"
      ],
      "env": {
        "SHADOWJOIN_CONFIG": "<SHADOWJOIN_CONFIG>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "shadowjoin": {
      "command": "npx",
      "args": [
        "-y",
        "shadowjoin"
      ],
      "env": {
        "SHADOWJOIN_CONFIG": "<SHADOWJOIN_CONFIG>"
      }
    }
  }
}

Add to .vscode/mcp.json

{
  "servers": {
    "shadowjoin": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "shadowjoin"
      ],
      "env": {
        "SHADOWJOIN_CONFIG": "<SHADOWJOIN_CONFIG>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "shadowjoin": {
      "command": "npx",
      "args": [
        "-y",
        "shadowjoin"
      ],
      "env": {
        "SHADOWJOIN_CONFIG": "<SHADOWJOIN_CONFIG>"
      }
    }
  }
}

Add to your client's MCP settings (most use this shape)

{
  "mcpServers": {
    "shadowjoin": {
      "command": "npx",
      "args": [
        "-y",
        "shadowjoin"
      ],
      "env": {
        "SHADOWJOIN_CONFIG": "<SHADOWJOIN_CONFIG>"
      }
    }
  }
}

Using several servers? Build one config file with the MCP config generator.

Configuration

  • SHADOWJOIN_CONFIGAbsolute path to shadowjoin.config.json, which names your data sources. Connection strings live here and never pass through a tool call.Required

What it does

Lost-match floor
Report a lower bound on matches an exact join misses.
Ranked rules
List normalization rules in order of marginal recovery.
Ground-truth checking
Verify recoveries with a truth column and report precision.
Multi-column keys
Show which key component disagreed on missed rows.
Mechanical vs semantic misses
Separate fixable string issues from ones needing entity resolution.
Safe install
No postinstall script; credentials stay in a config file.

Good for

  • Audit a customer-to-CRM join before trusting a dashboard
  • Find which cleaning rules to add to a pipeline
  • Check a country-name join against ISO codes
  • Decide whether misses need an alias table

Pricing

Open source

Free npm package

Shadowjoin FAQ

Does it change my data?

The README describes measurement only: it reports lost matches and suggested rules.

Where do connection strings go?

In the file named by SHADOWJOIN_CONFIG, never in a tool call.

Does it run install scripts?

No, the README says there is no postinstall script.

Can I run it without MCP?

Yes, the README shows a CLI: npx shadowjoin scan with left and right sources and keys.

Is Shadowjoin free?

Yes. Shadowjoin is open source, so you can use and self-host it for free.

How do I add Shadowjoin to Claude Code?

Run this command in your terminal: claude mcp add shadowjoin --env SHADOWJOIN_CONFIG='<SHADOWJOIN_CONFIG>' -- npx -y shadowjoin

What are the best alternatives to Shadowjoin?

The closest alternatives to Shadowjoin are Agent-Native Analytics, Google Ads + Meta Ads + SEO/GEO MCP, dashboard-icons, Tapetide - Indian Stock Market MCP and World Monitor.

Where this comes from

  • Description: written from the project's README.
  • Install steps: from the official MCP Registry entry.

How AIPoweredBot checks servers