Check Health

Purpose: Quickly assess overall data quality and identify issues requiring attention.

Instructions for Claude

When this skill is invoked:

1. •

   Create and run a Node.js script that connects to MongoDB and performs these checks:

   Basic Stats:

   • •Total people count
   • •Total visits count
   • •Total scans count
   • •Total dead letters count
   • •Recent observations (last 24h, last 7d)

   Identity Issues:

   • •People without canonical_id
   • •People with missing Sales Nav ID
   • •People with unstable IDs (URL-based _id)
   • •Duplicate aliases (same alias.value on multiple people)

   Data Quality:

   • •People without observations
   • •People with missing critical fields (fullName, currentTitle, etc.)
   • •Orphaned observations (not linked to any person)
   • •Observations with missing stable identifiers

   Dead Letters:

   • •Count by status (pending, replayed, failed_again)
   • •Most common error types
   • •Oldest pending dead letter
   • •Recent failure rate

   Role & Company Issues:

   • •People with overlapping role timelines
   • •Companies missing canonical IDs
   • •Locations missing structured data
2. •

   Output format:

   code

   DATABASE HEALTH CHECK
   ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
   
   📊 BASIC STATS
   ✓ People: [count]
   ✓ Visits: [count]
   ✓ Scans: [count]
   ⚠ Dead Letters: [count]
   
   📈 RECENT ACTIVITY
   • Last 24h: [count] observations
   • Last 7d: [count] observations
   
   🔍 IDENTITY ISSUES [priority: high]
   ⚠ Missing canonical_id: [count]
   ⚠ URL-based IDs: [count]
   ⚠ Duplicate aliases: [count]
   
   📋 DATA QUALITY [priority: medium]
   • Missing names: [count]
   • Missing positions: [count]
   • Orphaned observations: [count]
   
   💀 DEAD LETTERS
   • Pending: [count]
   • Failed again: [count]
   • Common errors:
     - [error type]: [count]
     - [error type]: [count]
   
   ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
   
   [SUMMARY]
   Overall health: [GOOD/WARNING/CRITICAL]
   Priority actions: [list top 3 issues to fix]
   

3. •

   Priority levels:

   • •CRITICAL: > 10% people have identity issues
   • •WARNING: > 5% people have quality issues or > 100 pending dead letters
   • •GOOD: < 5% issues overall
4. •

   Detailed mode (--detailed flag):

   • •Show sample records for each issue type
   • •List specific people with problems
   • •Provide SQL/MongoDB queries to investigate further

Error Handling

• •If database connection fails, show clear error
• •If any check fails, continue with others and note the failure