Fairy godmother : In fairy tales, a fairy godmother is a fairy with magical powers who acts as a mentor or parent to someone, in the role that an actual godparent was expected to play in many societies. There are present in Charles Perrault's Cinderella, Dickens'The Magic Fishbone and many more.
Abonde -- Dame good fairy who brings children presents on New Year’s Eve. [French. Folklore: Brewer Dictionary, 3]
The Sleeping Beauty Fairies -- Flora, Fauna, Merriweather are fairy guardians sent to watch over mortals throughout their lives.
Cinderella’s Fairy Godmother -- She fulfills Cinderella’s wishes and helps her win the prince. [French Fairy Tale: Cinderella ]
The Blue Fairy in Pinocchio
Fairy from Beauty and the Beast -- In this case it was the prince’s utter selfishness in the presence of an ugly yet powerful fairy that caused him to become the Beast.
Mrs Doasyouwouldbedoneby -- This fae is a water elemental who guides young Tom (who fell into the river and thus became a water baby) in his new lifein the book The Water Babies, by Rev. Charles Kingsley, published around 1863.
The Sugar Plum Fairy -- In the story, The Sugar Plum Fairy rules the Land of Sweets. She puts on a fabulous celebration for Clara for saving the life of her former-nutcracker Prince, when they come to visit this magical land.
Thumbelina -- Very charming tale from the viewpoint of fae who are no bigger than a thumb and living amongst nature by Hans Christian Andersen .
Tom Thumb -- This old English tale is based upon legends of a tiny character who was especially well-known amongst the common folk, often used to scare.
Lady of the Lake -- The fae that guards Excalibur, the magical sword, in Arthur legends and myths.
Iolanthe -- The mistress of fairy revels, who arranged all the fairy dances and songs, committed the capital crime (under fairy law) of marrying a mortal human.
Ondine -- A water spirit who falls in love with a dashing knight and then marries him, so she can get a soul. A soul, that is, the way people of the time defined it. This was another tragedy that was also made into a ballet.
Alberich and Mime -- Dwarves in the Ring Cycle story operas by Wagner. Alberich was known as king of the dwarves or elves (depending on different versions of several tales of the time) in German folklore and myth. Variously spelled Aelfric, Alferich, Elberich.
Ariel -- The fae servant to Prospero, in Shakespeare’s, The Tempest. That Ariel, a male, had been imprisoned inside a tree by an evil sorcerer until Prospero freed him. He was then indebted to become a slave until his loyalty and service finally set him free.
The Seven Dwarves in Snow White.
Mazilla -- The wicked fairy godmother of homely Princess Turritella, in The Blue Bird, by Madame d'Aulnoy.
Queen of Elphame (or Elphen) -- a beautiful, magical fae who can shape shift, often seen as evil, in Thomas the Rhymer and other stories.