excel-mcp: Command for Claude Code

Analyze PRP Results

PRP File: $ARGUMENTS

Post-execution analysis of a PRP implementation to capture lessons learned, success metrics, and template improvements.

Analysis Process

1. Execution Metrics Collection

   • Measure actual vs estimated token usage
   • Track implementation time and iterations
   • Document test failures and fixes
   • Analyze code quality metrics

2. Success Pattern Analysis

   • Identify what worked well
   • Extract reusable patterns
   • Document effective context elements
   • Capture successful validation strategies

3. Failure Pattern Learning

   • Document encountered issues
   • Analyze root causes
   • Create prevention strategies
   • Update known gotchas database

4. Template Improvement Recommendations

   • Identify context gaps
   • Suggest validation enhancements
   • Recommend documentation updates
   • Propose new anti-patterns

5. Knowledge Base Updates

   • Add new failure patterns to database
   • Update success metrics
   • Enhance similar feature detection
   • Improve confidence scoring

Analysis Framework

Metrics Collection

# Collect implementation metrics
echo "Collecting execution metrics..."

# Get git statistics
COMMITS_DURING_IMPL=$(git rev-list --count HEAD --since="2 hours ago")
FILES_CHANGED=$(git diff --name-only HEAD~$COMMITS_DURING_IMPL HEAD | wc -l)
LINES_ADDED=$(git diff --shortstat HEAD~$COMMITS_DURING_IMPL HEAD | grep -o '[0-9]* insertion' | grep -o '[0-9]*' || echo 0)
LINES_DELETED=$(git diff --shortstat HEAD~$COMMITS_DURING_IMPL HEAD | grep -o '[0-9]* deletion' | grep -o '[0-9]*' || echo 0)

# Get test results
TEST_RESULTS=$(pytest tests/ --tb=no -q 2>&1 | tail -n 1)
TEST_COUNT=$(echo "$TEST_RESULTS" | grep -o '[0-9]* passed' | grep -o '[0-9]*' || echo 0)
TEST_FAILURES=$(echo "$TEST_RESULTS" | grep -o '[0-9]* failed' | grep -o '[0-9]*' || echo 0)

# Get code quality metrics
RUFF_ISSUES=$(ruff check . 2>&1 | grep -c "error\|warning" || echo 0)
MYPY_ERRORS=$(mypy . 2>&1 | grep -c "error:" || echo 0)

echo "📊 Implementation Metrics:"
echo "- Commits: $COMMITS_DURING_IMPL"
echo "- Files changed: $FILES_CHANGED"
echo "- Lines added: $LINES_ADDED"
echo "- Lines deleted: $LINES_DELETED"
echo "- Tests passing: $TEST_COUNT"
echo "- Tests failing: $TEST_FAILURES"
echo "- Ruff issues: $RUFF_ISSUES"
echo "- MyPy errors: $MYPY_ERRORS"