---
name: duplicate-record-review
description: >-
  Identifies likely duplicate profiles or companies using available
  record evidence. Use when the user provides a list and wants
  duplicate groups, match confidence, and merge recommendations.
  Describe records as likely duplicates unless there is an exact
  deterministic match.
license: MIT
metadata:
  author: ProfileSpider
  version: "1.0"
  category: data-cleanup
  source: https://profilespider.com/resources/duplicate-record-review
---

# Duplicate Record Review

## Purpose

Identify likely duplicate profiles or companies using available record evidence.

## When to use this skill

- De-duplicating a merged or re-scraped list
- Catching the same company under different names
- Preventing double outreach to one contact
- Producing a reviewable merge plan

## When not to use this skill

- The records share no comparable identifiers
- You need an irreversible automatic merge (always review)
- The list is already known to be unique

## Required inputs

- A list of company or profile records

## Optional inputs

- Match keys to prioritize (domain, email)
- A confidence threshold
- Fields that must match exactly

## Rules

1. Describe matches as likely unless an exact deterministic key matches.
2. Report match confidence and the evidence behind it.
3. Never auto-merge; recommend and flag for review.
4. List conflicting fields explicitly.
5. Prefer the most complete record as the survivor.

## Process

1. Compare records on available keys.
2. Group likely duplicates.
3. Assess confidence and list matching/conflicting fields.
4. Recommend a survivor and merges.
5. Set manual-review status.

## Output format

Return one record per duplicate group with the following fields:

- duplicate_group
- match_confidence
- matching_fields
- conflicting_fields
- merge_recommendation
- manual_review_status

## Validation

- Confirm only exact key matches are called certain.
- Confirm conflicts are listed for each group.
- Confirm no merge is performed automatically.

## Limitations

- Without unique keys, matches are probabilistic.
- Distinct entities can share names; review before merging.

## Source and license

Source: https://github.com/spiralcrew-ou/profilespider-agent-skills/blob/6c65d0507687364704a180476613b72467028e87/duplicate-record-review/SKILL.md

MIT License

Copyright (c) 2026 SpiralCrew

Permission is hereby granted, free of charge, to any person obtaining a copy
of this software and associated documentation files (the "Software"), to deal
in the Software without restriction, including without limitation the rights
to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
copies of the Software, and to permit persons to whom the Software is
furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all
copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
SOFTWARE.