Musiql is a command-line front-end to MPlayer that provides SQL-based music library management features using SQLite. The project's goal is to provide a full set of music library management features without resorting to a menu-based interface. It imports music files into its database, extracting metadata from tags using Mutagen. SQL queries can then be used to retrieve lists of songs and play them in MPlayer. Static and dynamic playlists can be saved, and Musiql keeps track of playcounts and ratings for each track. Tracks can also be submitted to Last.FM as they are played, using lastfmsubmitd.
Musiql is written in Python, and uses pysqlite for database access.
For more information, see the README.