get_playlist_tracks
Retrieve a list of tracks from a specific playlist within the rekordbox DJ database by providing the unique playlist identifier. Supports read-only access to manage and analyze playlist content.
Instructions
Get all tracks in a specific playlist.
Args: playlist_id: The unique playlist identifier
Returns: List of tracks in the playlist
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| playlist_id | Yes |
Implementation Reference
- rekordbox_mcp/server.py:304-319 (handler)MCP tool handler and registration for get_playlist_tracks. Fetches tracks via database instance and returns serialized dicts.@mcp.tool() async def get_playlist_tracks(playlist_id: str) -> List[Dict[str, Any]]: """ Get all tracks in a specific playlist. Args: playlist_id: The unique playlist identifier Returns: List of tracks in the playlist """ if not db: raise RuntimeError("Database not initialized.") tracks = await db.get_playlist_tracks(playlist_id) return [track.model_dump() for track in tracks]
- rekordbox_mcp/database.py:267-308 (helper)Supporting database method that implements the core logic for retrieving ordered tracks from a playlist using pyrekordbox database queries.async def get_playlist_tracks(self, playlist_id: str) -> List[Track]: """ Get all tracks in a specific playlist. Args: playlist_id: The playlist's unique identifier Returns: List of tracks in the playlist """ if not self.db: raise RuntimeError("Database not connected") try: # Get song-playlist relationships for this playlist playlist_songs = list(self.db.get_playlist_songs(PlaylistID=int(playlist_id))) # Filter out soft-deleted relationships active_songs = [s for s in playlist_songs if getattr(s, 'rb_local_deleted', 0) == 0] # Get all content to match against all_content = list(self.db.get_content()) active_content = [c for c in all_content if getattr(c, 'rb_local_deleted', 0) == 0] # Create a lookup for faster access content_lookup = {str(c.ID): c for c in active_content} # Build tracks list maintaining playlist order tracks = [] # Sort by TrackNo to maintain playlist order sorted_songs = sorted(active_songs, key=lambda x: getattr(x, 'TrackNo', 0)) for song_playlist in sorted_songs: content_id = str(song_playlist.ContentID) if content_id in content_lookup: track = self._content_to_track(content_lookup[content_id]) tracks.append(track) return tracks except Exception as e: logger.error(f"Failed to get playlist tracks for playlist {playlist_id}: {e}") return []
- rekordbox_mcp/models.py:13-37 (schema)Pydantic model defining the structure of Track objects used in get_playlist_tracks output after model_dump().class Track(BaseModel): """ Rekordbox track model with comprehensive metadata. """ id: str = Field(..., description="Unique track identifier") title: str = Field(..., description="Track title") artist: str = Field(..., description="Track artist") album: Optional[str] = Field(None, description="Album name") genre: Optional[str] = Field(None, description="Musical genre") bpm: float = Field(0.0, description="Beats per minute") key: Optional[str] = Field(None, description="Musical key (e.g., '5A', '12B')") rating: int = Field(0, ge=0, le=5, description="Track rating (0-5)") play_count: int = Field(0, ge=0, description="Number of times played") length: int = Field(0, ge=0, description="Track length in seconds") file_path: Optional[str] = Field(None, description="Path to audio file") date_added: Optional[str] = Field(None, description="Date track was added to library") date_modified: Optional[str] = Field(None, description="Date track was last modified") # Additional metadata bitrate: Optional[int] = Field(None, description="Audio bitrate in kbps") sample_rate: Optional[int] = Field(None, description="Audio sample rate in Hz") color: Optional[str] = Field(None, description="Track color tag") comments: Optional[str] = Field(None, description="Track comments")