Shadowjoin
Local MCP server that measures how many matches an exact join silently drops
- 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 shadowjoinAdd 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.

