excel-mcp: Command for Claude Code

Validate PRP

PRP File: $ARGUMENTS

Pre-flight validation of a PRP to ensure all context and dependencies are available before execution.

Validation Process

1. Parse PRP

   • Read the specified PRP file
   • Extract all file references, URLs, and dependencies
   • Parse validation checklist items

2. Context Validation

   • Check all referenced files exist
   • Validate all URLs are accessible
   • Verify environment dependencies are available
   • Check for required API keys/credentials

3. Codebase Analysis

   • Scan for similar patterns mentioned in PRP
   • Validate existing examples are current
   • Check for architectural consistency

4. Dependency Check

   • Verify all required libraries are installed
   • Check version compatibility
   • Validate external service connectivity

5. Risk Assessment

   • Analyze failure patterns mentioned in PRP
   • Assess complexity and confidence score
   • Identify potential bottlenecks

Validation Gates

File References

# Check all referenced files exist
echo "Validating file references..."
for file in $(grep -o 'file: [^[:space:]]*' "$PRP_FILE" | cut -d' ' -f2); do
    if [ ! -f "$file" ]; then
        echo "❌ Missing file: $file"
        exit 1
    else
        echo "✅ Found: $file"
    fi
done

URL Accessibility

# Check all referenced URLs are accessible
echo "Validating URL references..."
for url in $(grep -o 'url: [^[:space:]]*' "$PRP_FILE" | cut -d' ' -f2); do
    if curl -s --head "$url" > /dev/null; then
        echo "✅ Accessible: $url"
    else
        echo "⚠️  Cannot access: $url"
    fi
done

Environment Dependencies

# Check environment setup
echo "Validating environment dependencies..."

# Check Python dependencies
if command -v python3 &> /dev/null; then
    echo "✅ Python3 available"

    # Check specific imports mentioned in PRP
    python3 -c "
import re
import sys
# Read PRP file and extract import statements
with open('$PRP_FILE', 'r') as f:
    content = f.read()
# Find import statements in code blocks
imports = re.findall(r'^(?:import|from)\s+([a-zA-Z_][a-zA-Z0-9_]*)', content, re.MULTILINE)
unique_imports = set(imports)
failed_imports = []
for module in unique_imports:
    try:
        __import__(module)
        print(f'✅ Module available: {module}')
    except ImportError:
        failed_imports.append(module)
        print(f'⚠️  Module missing: {module}')
if failed_imports:
    print(f'❌ Missing modules: {failed_imports}')
    sys.exit(1)
"
else
    echo "❌ Python3 not available"
    exit 1
fi