He is a green anthropomorphic sprinkle with two arms and two legs. He doesn't seem to have any eyes. He is extremely small, and is around the same height as CreamBob's shoes.
CreamBob ConePants introduces him, along with the other main ice cream characters, to SpongeBob and Patrick. It is then implied that he, along with everyone else in Pint Bottom, is eaten by SpongeBob and Patrick.