Petrichor is an offline music player for macOS that reads music files from directories without altering them, using a SQLite database to store metadata. The app's database schema includes tables for folders, artists, albums, tracks, playlists, and more, with relationships between them to enable features like searching and smart playlists.