Tabitha

"There are times the world is scary, Times the world is bad, But when your godmother's a fairy There's no reason to be sad."

- Fairy Godmother's song

The Fairy Godmother is a mystical being with the power of wish bestowal. She was serving various humans, before eventually being banished to Mallus's realm. After Mallus was freed and his escape opened the door for other mystical beings banished to his realm, she became a magical fugitive who was hiding in Salem, Massachusetts during the Witch Trials, intent on bringing vengeance upon humans, she is revealed to be Tabitha the love of the demon Neron.

Wishes and Banishment
The Fairy Godmother's original role was to grant wishes to various children she had a contract with. Her power was dependent on the contract she had with her "godchild": although she could influence their opinion, she could not wield power without a wish from the "godchild". She had little love for her "pets", as vain girls often asked her for petty trinkets, such as shoes of glass, instead of something worthwhile. Eventually, humans banished her to Mallus's realm, a "dreadful dimension" in which she and many other mystical beings were trapped.

Freedom and Damnation
After the Legends allowed Mallus to enter Earth-1 to destroy him, his escape prompted the release of other mystical creatures banished inside his realm. This accelerated the rate of Rising Darkness, prompting John Constantine to look into the case of mystical "fugitives", joining the time traveling team of Legends. As Mallus was a "time god", his prisoners ended up in various points of the timeline, with Fairy Godmother turning up in Salem during the infamous witch trials. Thereupon she made a contract with the accused "witch's" daughter, Prudence. Angry at humans for banishing her into the Spirit Realm, the Godmother was eager to help the girl's revenge against the villagers, trying to seduce her into using the power of wishes to bring fire and brimstone upon the angry Puritans of Salem. John Constantine wasn't able to banish the Fairy Godmother, as her spellcasting was much quicker, allowing her to overpower the Legends. She then stayed in the background, discussing her powers with Constantine and waiting for the moment to influence Prudence. When Prudence got restless, the Fairy Godmother appeared before her with a crystal ball, showing her Sara Lance's words about having to abandon the girl's mother in accordance with history. When John tried to stop Fairy Godmother and Prudence from leaving the ship, he was silenced by the fairy's spell, sealing his mouth shut. The fairy then marched towards the witch pyre together with Prudence, they stopped the whole crowd with magic and freed the girl's mother along with Zari, replacing them upon the pyre with the local reverend. Godmother urged the girl to punish the Puritans of Salem for their deeds with fire and brimstone, but after Zari Tomaz and Sara Lance managed to convince Prudence to call off the Fairy Godmother and renounce her vengeance, the girl released her from their contract, allowing Constantine to incapacitate the mystical witch. He then brought her to the forest and discussed the Godmother's fate, offering her a deal: either she enters a contract with him, or he sends her to Hell. Although she was scared of Hell, the Fairy Godmother chose to refuse John's offer, saying that she'd rather take on the forces of Hell than the being that is currently pursuing Constantine. She taunted him on being "far more damned than she is" before John opened a portal that siphoned her into Hell.

Alternate Timelines
Fairy Godmother had different destinies in the alternate timelines caused by John Constantine. In the "Sirens of Space-Time" timeline she was the entity behind the murder of Mick Rory, Ray Palmer, and Nate Heywood, causing the surviving female members of the Legends to become much deadlier in their methods. In the "Puppets of Tomorrow" timeline she was captured by the Legends, but managed to make a pact with Mick Rory due to his conflicts with the rest of the team over being "Time Bureau puppets". Fairy Godmother turned the team into literal puppets and granted Mick Rory various wishes, having him return to the life of crime as Heat-Wave, with Fairy Godmother becoming his partner; another Captain Cold. Presumably, her fate was reverted after Constantine agreed to reset the timeline.

Personality
The Fairy Godmother tried to appear generous and lovely, claiming that her only wish is to make the world a better place. However, she was in fact vindictive and disdainful of humans, calling them "pets" or even "pests". She despised the vanity of her previous charges, thinking them too greedy. Being banished by humans to Mallus' realm, she grew to hate humanity and wanted to take some bloody revenge. Her own wish regarding Prudence was to convince the girl to become the instrument of her revenge against the humans, sending hellfire upon their heads. She was shocked when Constantine intended to send her to Hell, but refused to comply with his proposition of a pact, claiming that there was no helping John, as he was more damned than she, and that the being that was coming after him was far more terrible than Hell itself.

Powers

 * Magic:
 * Wish bestowal: Fairy Godmother has the ability to grant the wishes of her charge.
 * Reality warping: Fairy Godmother are able to use some of her powers on the whim, like turning reality into a musical, similarly to the Music Meister.
 * Multiversal awareness: She has knowledge of the different dimensions of the Multiverse.
 * Temporal awareness: She had knowledge of John Constantine and his troubles from the year 2018 despite being from a different time period.

Abilities

 * Persuasion: Fairy Godmother cannot user her powers on her own, relying on her charge's wishes to cast magic. To do what she wants, she needs to persuade her charge to ask for that wish.
 * Singing: Fairy Godmother is a proficient singer.

Weaknesses

 * Host dependence: Fairy Godmother cannot user her powers on her own without the charge's consent. If the charge breaks their bond she is completely powerless. If renounced by the host, she will be unable to use magic.

Former equipment

 * Cold Gun: In an alternate timeline, Fairy Godmother made a pact with Mick Rory, taking on the role of Captain Cold, complete with his Cold Gun, goggles and signature parka. However, the timeline in which she used the Cold gun was later erased.
 * Wand: She uses a wand to cast her magic. As soon as she was released from her charge, she lost her wand.
 * Tiara: The Fairy Godmother wore a silver tiara on her head. When she was sent to Hell, her tiara fell off.

Behind the scenes

 * Historically, Fairy Godmother is a character in fairy tales, primarily associated with Cinderella, 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. In Perrault's Cinderella, he concludes the tale with the cynical moral that no personal advantages will suffice without proper connections.
 * In the comics, the Godmother has made appearances based on her classic fairy tale appearance.