- Home
- Skills
- Data & Databases
- List Hygiene Checker
Works with the AI Agents you already use
List Hygiene Checker
Find duplicates, missing information and stale records in business lists, without changing your original data.
Free
List Hygiene Checker
Example session with this skill installed
Review this fictional membership list for duplicate records, missing information, stale entries and test records.
Member ID, name and email are required. Flag entries last active before 1st January 2026 as stale.
| Row | Member ID | Name | Telephone | Last active | |
|---|---|---|---|---|---|
| 1 | M-101 | Alex Patel | alex@example.test | 07000 000001 | 2026-09-15 |
| 2 | M-101 | Alex Patel | alex@example.test | 07000 000001 | 2026-09-15 |
| 3 | M-102 | Sam Green | family@example.test | 07000 000002 | 2026-09-01 |
| 4 | M-103 | Lee Green | family@example.test | 07000 000002 | 2026-08-25 |
| 5 | TEST | Test Person | test@example.test | ||
| 6 | M-104 | Jamie Reed | 07000 000004 | 2025-01-10 |
Don't change any records. Show me the evidence for each issue and what I should verify before making corrections.
- Read your context and instructions
- Compiled the list hygiene checker
List Hygiene Audit
Records reviewed: 6
Required fields: Member ID, name, email
Staleness rule: Last active before 1st January 2026
Findings
| Issue | Records | Evidence |
|---|---|---|
| Likely duplicate | 1 and 2 | Same Member ID and email |
| Possible duplicate | 3 and 4 | Shared household email and telephone, but different names and member IDs |
| Test or placeholder | 5 | TEST identifier and test name |
| Missing required information | 6 | Email is blank |
| Stale record | 6 | Last activity predates the supplied threshold |
What needs checking
Rows 1 and 2: Confirm they refer to the same record before merging.
Rows 3 and 4: Do not merge automatically. These may be two different people sharing household contact details.
Row 5: Check whether this is an intentional test record.
Row 6: Verify the missing email and whether the membership remains active.
Recommended action
Review the flagged records with the list owner before making changes. Keep an original copy of the data and record any approved corrections.
No records have been modified.
Illustrative output using fictional data, not a real customer audit.
Connects securely to your tools. The creator never sees your data.
About this skill
Find the problems hiding in your business lists
Customer records, contact lists, membership databases and operational spreadsheets can become difficult to trust as people add and update information.
List Hygiene Checker reviews your records and shows you what needs attention, without making changes automatically.
What you'll get
- Likely duplicates: Records supported by multiple matching identifiers.
- Possible duplicates: Suspicious matches that need human confirmation.
- Missing information: Records missing fields you've identified as required.
- Stale records: Entries that fall outside your chosen activity or date rules.
- Test and placeholder rows: Entries that might not represent genuine records.
- Clean records: Rows that pass the checks performed.
- Review checklist: Clear findings and what needs verifying before correcting anything.
Who it's for
Operations teams, small businesses, administrators, consultants and anyone maintaining spreadsheets or structured business records.
How it works
Supply your list, identify the important fields and explain any rules that matter, such as what counts as an inactive record.
The skill reviews the information, groups its findings and explains the evidence behind each flagged issue.
You stay in control
List Hygiene Checker never automatically deletes, merges or changes records.
It doesn't assume two people are the same simply because they share a name, email address or telephone number.
Every proposed correction remains subject to your review.
Important information
The skill is designed for read-only analysis of supplied information. It doesn't connect to your CRM, independently verify records against external databases or guarantee that every possible error will be detected.
The underlying project is also available as an open-source tool under the MIT licence.
Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Data & Databases.
Read-only audit only; no automated merging or deletions. Requires manual definition of staleness rules. Names alone are not used for duplicate matching.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before buying a skill.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Free to use
No account required to browse
Trust & safety
Security scan
Security scan passed 21 days ago
- Free with an Agensi account