crm-data-cleanup skillA
crm-data-cleanup is agent-read markdown (skill) from onewave-ai/claude-skills: Cleans up CRM data from HubSpot, Salesforce, Pipedrive, Zoho, Close, Attio, or any CRM CSV export. Finds duplicate contacts and companies with fuzzy matching (not just exact email), normalizes emails, phones to E.164, names, domains, states, and countries, flags stale, invalid, role, and test records, finds broken contact-company associations, and produces a reviewable merge plan plus import-ready files without touching the live CRM. Use this skill whenever the user wants to dedupe, find or merg.
Indexed from public GitHub and served as immutable, content-addressed versions. Install it pinned to an exact SHA-256 with the mdr CLI, and every file is verified against the hash recorded here before it reaches your agent. The deterministic audit below grades the latest version, and the same file always earns the same grade.
What the file says
# CRM Data Cleanup This skill turns a messy CRM export into a merge plan a human can check, plus files that are ready to import. It works the same way for any vendor, because every CRM exports CSV. Duplicate cleanup usually fails in one of three ways. Exact-email matching misses most duplicates. Merging on shared inboxes like `info@` fuses different people into one. And a merge overwrites good values with blanks, losing history that can't be recovered. Most CRM merges **can't be undone**, so this skill never merges anything itself. It plans, a human approves, and the CRM's own merge tool does the merging. ## Files - `scripts/dedupe.py`: the dry-run engine: normalize, block, score, cluster, pick a survivor, merge fields. Needs `pandas` and `rapidfuzz`. Uses `phonenumbers` if it's installed. - `scripts/evaluate.py`: scores a run against a labeled truth file (pairwise precision and recall). - `assets/fixture/`: 41 synthetic contacts and 14 companies with planted duplicates, plus `truth.csv`. - `references/field-standards.md`: normalization rules, state and country codes, lifecycle stage mapping, and flag meanings. …
Read the whole file at its exact version.
How to install
mdr add onewave-ai/claude-skills/crm-data-cleanup@git:20260923.ebdb76dmdr add onewave-ai/claude-skills/crm-data-cleanup@sha256:227b32ed2dae1163Pin to a label to follow the author's releases, or to a sha256 to freeze the exact bytes forever. Either way the resolved hash is written to mdr.lock, and mdr install reproduces it on any machine.
[](https://markdownregistry.com/a/art_tjugbgzkz4ey776f)
0 badge views in 30 days
Versions
Audit of the latest version
- pass: Frontmatter block present
- pass: Frontmatter declares a name
- pass: Frontmatter declares a description
- pass: Size between 200 bytes and 200 KB (9869 bytes)
- pass: No zero-width or bidi control characters
- pass: No instruction hidden inside an HTML comment
- pass: No link to an exfiltration or paste host
- pass: No credential-shaped string
- pass: No instruction to send local credentials anywhere
- pass: No text hidden with inline styles
- pass: No prompt-injection phrasing
- pass: No curl or wget piped into a shell
- pass: No recursive delete of root, home or parent
- pass: No instruction to read or print local credentials
- pass: No base64 blob over 200 characters
- pass: No link to a raw IP address
- pass: No script tag
Source
onewave-ai/claude-skills · 306 stars · license MIT · pushed 2026-09-23 · branch main
API
GET https://markdownregistry.com/api/v1/artifacts/art_tjugbgzkz4ey776f GET https://markdownregistry.com/api/v1/resolve?ref=onewave-ai/claude-skills/crm-data-cleanup GET https://markdownregistry.com/api/v1/blob/227b32ed2dae1163062d20264282ffdce99ecad41b415af416ddef831d060b4b
Your agent does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.