cognito-user-analysislisted
Install: claude install-skill ClipboardHealth/groundcrew
# Cognito User Analysis
Analyze and fix duplicate Cognito users in clipboard-production by comparing against backend data.
**Skill directory:** This skill's scripts are in `scripts/` relative to this file.
## When to Use
- User reports "403 Forbidden" or can't log in (possible duplicate blocking)
- Need to look up Cognito user details from sub UUIDs
- Finding accounts sharing same phone/email
- Cleaning up orphaned UNCONFIRMED signups
- Backend `cbh_user_id` doesn't match Cognito
**Not for:** Single user attribute updates (use AWS CLI directly)
## Quick Start
```bash
# 1. Verify prerequisites
scripts/check-prerequisites.sh
# 2. Create input file (one sub per line)
echo "68e1e380-d0c1-7028-4256-3361fd833080" > subs.txt
# 3. Pipeline: lookup → find duplicates → analyze → fix
scripts/cognito-lookup.sh subs.txt results.csv
scripts/cognito-find-duplicates.sh results.csv duplicates.csv
scripts/cognito-analyze-duplicates.sh duplicates.csv analysis.csv
# 4. Review analysis.csv, then fix (ALWAYS dry-run first!)
scripts/cognito-fix-duplicates.sh analysis.csv --dry-run
scripts/cognito-fix-duplicates.sh analysis.csv
```
## Prerequisites
Run `scripts/check-prerequisites.sh` to verify. Requirements:
| Requirement | Setup |
| ------------------------------------- | ----------------------------------------------------------- |
| AWS profile `cbh-production-platform` | `aws sso login --profile cbh-pro