resolve-playlist

name: resolve-playlist description: 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. triggers: - "resolve youtube ids" - "resolve playlist" - "find youtube videos" - "match youtube"

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

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:

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

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

After Resolving

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

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