Oscar Brand released an album (I Like Cats) that was all songs about cats. Cheryl Wheeler included a song about her cats (Meow) on her album Sylvia Hotel.

Then there are the traditional ones like The Body In The Bag and The Cat Came Back.

I like Sam The Skull. Is there a tune out there for it?