recce-mcp-e2e — analytics-engineering recce-mcp-e2e, community, analytics-engineering, ide skills, data-engineering, data-validation, dataops, Claude Code, Cursor, Windsurf

v1.0.0
GitHub

About this Skill

The data-validation toolkit for enhanced dbt (data build tool) PR review

# Core Topics

analytics-engineering data-engineering data-validation dataops
DataRecce DataRecce
[447]
[25]
Updated: 3/19/2026
Labs Demo

Browser Sandbox Environment

⚡️ Ready to unleash?

Experience this Agent in a zero-setup browser environment powered by WebContainers. No installation required.

Boot Container Sandbox

recce-mcp-e2e

Install recce-mcp-e2e, an AI agent skill for AI agent workflows and automation. Works with Claude Code, Cursor, and Windsurf with one-command setup.

SKILL.md
Readonly

MCP E2E Verification

Full-stack verification of all 8 MCP tools against a real dbt project.

When to Use

  • After modifying recce/mcp_server.py or _tool_* handlers
  • After changing single-env logic or error classification
  • Before merging any MCP-related PR
  • Not for: unit test changes only, frontend-only changes, docs-only changes

Usage

Invoke as /recce-mcp-e2e or /recce-mcp-e2e <project_path>.

  • With argument: use the given path as the dbt project directory
  • Without argument: ask the user for the dbt project path

The project directory must contain target/manifest.json and target-base/manifest.json.

Process

  1. Resolve project path from argument or user input
  2. Validate target/ and target-base/ exist with manifest.json
  3. Detect recce source — find the repo root containing recce/mcp_server.py. If recce-nightly is also installed (pip show recce recce-nightly), set PYTHONPATH=<RECCE_REPO_ROOT>:$PYTHONPATH
  4. Generate test_mcp_e2e.py in the project directory from test_mcp_e2e_template.py (in this skill directory). Replace PROJECT_DIR_PLACEHOLDER with the resolved absolute path.
  5. Execute with appropriate PYTHONPATH prefix
  6. Report results — all 13 checks must show PASS. Expected output: 
    === FULL MODE (8 tools) ===
  PASS lineage_diff: PASS
  ...
=== SINGLE-ENV MODE ===
  PASS row_count_diff (_warning): PASS
  ...
ALL PASS
  7. Clean up — delete test_mcp_e2e.py

Quick Reference

Test SuiteChecksWhat's Verified
Full mode (8 tools)lineage_diff, schema_diff, row_count_diff, query, query_diff, profile_diff, list_checks, run_checkNon-empty results from each tool
Single-env _warning (3)row_count_diff, query_diff, profile_diff_warning field present with SINGLE_ENV_WARNING
Single-env no _warning (2)lineage_diff, schema_diff_warning field NOT present

Additional manual checks (not in script):

CheckCommand/Action
--helprecce mcp-server --help shows Prerequisites section
Server modesNon-server mode: list_tools returns only lineage_diff + schema_diff

Common Mistakes

ProblemFix
ImportError: cannot import name 'SINGLE_ENV_WARNING'recce-nightly conflict — use PYTHONPATH=<RECCE_REPO_ROOT>:$PYTHONPATH
lineage_diff returns emptyUse view_mode="all" (default changed_models filters out unchanged)
list_checks returns emptyPreset checks from recce.yml must be loaded via load_preset_checks() — script handles this
portalocker FileNotFoundError on exitCosmetic thread error in event collector — does not affect results
Single-env test uses target-baseBy design — load_context needs both, single_env=True flag simulates the mode

FAQ & Installation Steps

These questions and steps mirror the structured data on this page for better search understanding.

? Frequently Asked Questions

What is recce-mcp-e2e?

The data-validation toolkit for enhanced dbt (data build tool) PR review

How do I install recce-mcp-e2e?

Run the command: npx killer-skills add DataRecce/recce. It works with Cursor, Windsurf, VS Code, Claude Code, and 19+ other IDEs.

Which IDEs are compatible with recce-mcp-e2e?

This skill is compatible with Cursor, Windsurf, VS Code, Trae, Claude Code, OpenClaw, Aider, Codex, OpenCode, Goose, Cline, Roo Code, Kiro, Augment Code, Continue, GitHub Copilot, Sourcegraph Cody, and Amazon Q Developer. Use the Killer-Skills CLI for universal one-command installation.

↓ How To Install

  1. 1. Open your terminal

    Open the terminal or command line in your project directory.

  2. 2. Run the install command

    Run: npx killer-skills add DataRecce/recce. The CLI will automatically detect your IDE or AI agent and configure the skill.

  3. 3. Start using the skill

    The skill is now active. Your AI agent can use recce-mcp-e2e immediately in the current project.

Related Skills

Looking for an alternative to recce-mcp-e2e or another community skill for your workflow? Explore these related open-source skills.

View All

widget-generator

Logo of f
f

f.k.a. Awesome ChatGPT Prompts. Share, discover, and collect prompts from the community. Free and open source — self-host for your organization with complete privacy.

★ 149.6k
⑂ 0
AI

flags

Logo of vercel
vercel

flags is a Next.js feature management skill that enables developers to efficiently add or modify framework feature flags, streamlining React application development.

★ 138.4k
⑂ 0
Browser

zustand

Logo of lobehub
lobehub

The ultimate space for work and life — to find, build, and collaborate with agent teammates that grow with you. We are taking agent harness to the next level — enabling multi-agent collaboration, effortless agent team design, and introducing agents as the unit of work interaction.

★ 72.8k
⑂ 0
AI

data-fetching

Logo of lobehub
lobehub

The ultimate space for work and life — to find, build, and collaborate with agent teammates that grow with you. We are taking agent harness to the next level — enabling multi-agent collaboration, effortless agent team design, and introducing agents as the unit of work interaction.

★ 72.8k
⑂ 0
AI