wdm0006/evergreen-stale-data-audit
skills/stale-data-audit/SKILL.md
Audits Evergreen CRM for stale or incomplete contact data — outdated titles, missing fields, potential duplicates, and contacts that may have changed jobs. Use for periodic database hygiene, before a big outreach push, or when data quality feels off.
testing
Updated Apr 23, 2026
$ install --global
skillsauthnpx skillsauth add wdm0006/evergreen-skills evergreen-stale-data-auditInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Apr 24, 2026, 2:36 AM68.6s1 file scanned
SKILL.md
- name:
- evergreen-stale-data-audit
- description:
- Audits Evergreen CRM for stale or incomplete contact data — outdated titles, missing fields, potential duplicates, and contacts that may have changed jobs. Use for periodic database hygiene, before a big outreach push, or when data quality feels off.
Stale Data Audit
Works with Evergreen, a local-first personal CRM for macOS. Get it on the Mac App Store.
When to Use
- Quarterly database cleanup
- Before a bulk outreach or newsletter send
- When you notice contact details are outdated
- After importing contacts from another source
How It Works
- Search all contacts with
search_contactsto get the full database - For each contact, check for data quality issues using
get_contact - Flag incomplete records, stale information, and potential problems
- Prioritize fixes by relationship importance
- Generate a cleanup task list with suggested fixes
Data Quality Checks
| Check | What to Look For | Priority | |-------|-----------------|----------| | Missing email | Contact has no email address | High | | Missing organization | No company/org listed | Medium | | Stale title | Title unchanged for 12+ months on active contact | Medium | | No interactions | Contact exists but zero interactions logged | Low | | No tags | Contact has no tags for filtering | Low | | Empty notes | No context about the relationship | Medium | | No location | Missing city/region | Low | | Orphaned contacts | No relationships, no interactions, no tags | High |
Example Output
## Data Audit Report — April 2026
### Summary
- **Total contacts:** 187
- **Complete records:** 112 (60%)
- **Needs attention:** 75 (40%)
### Critical Issues (12)
1. **Sarah Chen** — Email missing (have everything else)
2. **Marcus Webb** — Title still says "Stealth Mode" (company launched 6 months ago)
3. **[5 contacts]** — No interactions ever logged (orphaned?)
4. **[5 contacts]** — Duplicate suspected (same org + similar name)
### Missing Fields Summary
| Field | Missing Count | % of Contacts |
|-------|--------------|---------------|
| Email | 23 | 12% |
| Organization | 18 | 10% |
| Title | 31 | 17% |
| Location | 45 | 24% |
| Tags | 38 | 20% |
### Likely Job Changes
Contacts where title was set 12+ months ago and they're at a startup
(high likelihood of role change):
1. **Jamie Rodriguez** — "Senior Engineer at Acme Labs" (set 14 months ago)
2. **Priya Sharma** — "ML Engineer at NewCo" (set 13 months ago)
### Suggested Actions
1. Enrich the 12 critical contacts (use contact-enrichment skill)
2. Review 5 suspected duplicates for merging
3. Archive or delete 5 orphaned contacts with no activity
4. Batch-update missing tags for 38 untagged contacts
Checklist
Data Audit:
- [ ] All contacts scanned for completeness
- [ ] Critical issues (missing email, duplicates) flagged first
- [ ] Missing fields summarized by type
- [ ] Potentially stale titles identified
- [ ] Orphaned contacts flagged for review
- [ ] Cleanup actions prioritized by impact
Learn More
- Evergreen — Local-First Personal CRM
- Evergreen Gets Serious
- Evergreen Gets Even Evergreener
Related Skills
wdm0006/evergreen-weekly-report
business
VerifiedTrustedCommunity
Generates a weekly relationship management digest from Evergreen CRM — interactions logged, follow-ups completed vs missed, network growth, and a spotlight contact. Use for weekly reviews, accountability, or planning the week ahead.
SKILL.mdUpdated Apr 23, 2026
wdm0006/drafting-warm-introductions
testing
VerifiedTrustedCommunity
Drafts double-opt-in introduction emails connecting two Evergreen CRM contacts. Use when someone asks for an introduction, when you spot a mutually beneficial connection, or when facilitating networking between contacts.
SKILL.mdUpdated Apr 23, 2026
wdm0006/evergreen-relationship-health
business
VerifiedTrustedCommunity
Scores and surfaces relationship health across your Evergreen CRM contacts — identifies thriving relationships, ones at risk, and dormant connections needing attention. Use when you want a high-level view of your network health or need to prioritize relationship investment.
SKILL.mdUpdated Apr 23, 2026
wdm0006/re-engaging-evergreen-contacts
business
VerifiedTrustedCommunity
Identifies dormant contacts in Evergreen CRM and drafts natural re-engagement messages. Use when you want to reconnect with people you haven't spoken to in months, revive stale relationships, or systematically re-engage your extended network.
SKILL.mdUpdated Apr 23, 2026