# Resolve Playlist

> Resolve YouTube video IDs for unmatched tracks in a stored playlist. Uses yt-dlp (no API quota). Scores candidates on channel quality, duration match, and title similarity.

- Skill: `alexknowshtml/resolve-playlist` (Agent Skill)
- Install (CLI): `npx skillmds@latest add alexknowshtml/resolve-playlist`
- Raw SKILL.md: https://api.skillmd.com/api/skills/alexknowshtml/resolve-playlist/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Integrations & APIs
- Author: alexknowshtml (https://skillmd.com/u/alexknowshtml)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/alexknowshtml/resolve-playlist

---


# resolve-playlist

Resolve YouTube video IDs for tracks in the local database using yt-dlp.

## When to Use

- After importing a playlist, user wants to find YouTube matches
- Running batch resolution on multiple playlists

## Prerequisites

- `yt-dlp` must be installed: `brew install yt-dlp` or `pip install yt-dlp`
- Playlist must already be in the DB (run save-playlist or sync-spotify first)

## Running the Resolver

```bash
spoti-bye resolve --playlist=<id> --threshold=5 --delay=1500
```

Options:
- `--playlist=ID` — required
- `--threshold=N` — minimum score to auto-accept (default: 5; use 1 for aggressive auto-accept)
- `--delay=MS` — delay between searches in ms (default: 1500; increase if hitting bot detection)
- `--dry-run` — preview without writing to DB
- `--verbose` — show scoring details for each candidate

## Scoring System

Each YouTube candidate is scored on:
1. **Channel quality**: VEVO/official artist channel (+3), Topic channel (+2), name match (+2)
2. **Duration match**: Within 5s (+3), 15s (+2), 30s (+1), >60s off = skip
3. **Negative keywords**: cover/remix/live/karaoke/acoustic = skip unless in original title
4. **Title similarity**: artist+title match (+2), title only (+1)
5. **View count**: >1M views (+1)

Tracks scoring below threshold go to a review file at `~/.spoti-bye/youtube-review-<id>.json`.

## After Resolving

```bash
spoti-bye review    # process flagged tracks
```

## Bot Detection

If yt-dlp starts failing with "Sign in to confirm", increase `--delay` or wait a few hours.

## Batch Processing All Playlists

```bash
for id in $(sqlite3 ~/.spoti-bye/playlists.db "SELECT DISTINCT pt.playlist_id FROM songs s JOIN playlist_tracks pt ON pt.song_id = s.id WHERE s.youtube_video_id IS NULL ORDER BY pt.playlist_id;"); do
  echo "=== Playlist $id ==="
  spoti-bye resolve --playlist=$id --threshold=1 --delay=1500
done
```