Fairies

Fairies are beings with natural magical aptitude, particularly with the ability to warp reality on a small scale. They are usually depicted as small humans with wings and a wand, although they can likely alter their size.

History
Fairies have only been seen on Earth-1.

Earth-1
The only known example of a fairy at the moment is Tabitha, the Fairy Godmother. Tabitha began on Earth, her original role being to grant wishes to children whom she had a contract with. She had no power without the will of her host. Over time, she began to view her "godchildren" as "pets", and became annoyed when the more vain of them would ask for useless things like trinkets, like glass shoes, rather than carefully wishing for something more worthwhile. In the end, she was imprisoned in Mallus's realm by the humans she once served, which Tabitha described as a "dreadful dimension".

Eventually, Tabitha was released from the realm accidentally by the Legends, when Mallus escaped. The Fairy Godmother was transported to Salem during the witch trials, where she met the daughter of an accused witch, Prudence Hawthorne. More than eager to help Prudence get her revenge, she influenced Prudence with promises of power, such as raining down fire and brimstone on the Puritans in Salem.

However, Prudence was ultimately convinced by Sara Lance and Zari Tomaz to end her contract with Tabitha, renouncing her vengeance, leaving the Fairy Godmother with no host for her magic. John Constantine was then able to cast her into Hell, but not before offering her a contract with him so he defeat Neron. Tabitha refused, not wanting to bother Neron, so Constantine sent her into Hell.

Tabitha was later released from Hell by her lover, none other than the demon Neron. Forcing Constantine to make a two-way portal to the hellish domain, he summoned Tabitha from Hell and brought her to her new host, Gary Green.

Powers
Fairies are magical beings, so as such are able to use magic, although in a slightly more unique way, in terms of the Fairy Godmother.
 * Magic: Tabitha possesses impressive magical powers. Even John Constantine considered having a contract with her, in order to defeat demon Neron.
 * Telekinesis: She was able to grip Charlie's neck telekinetically.
 * Temporal awareness: She had knowledge of John Constantine and his troubles from the year 2018 despite being from a different time period.
 * Multiversal awareness: She has knowledge of the different dimensions of the Multiverse.
 * Magic via wand: Fairies, such as Tabitha, may also possess wands that grant them a further set of abilities:
 * Wish bestowal: Fairy Godmother could grant her hosts wishes, usually with a mere flick of her wand. Tabitha had a tendency to speak in rhyming couplets whenever casting her spells.
 * Teleportation: She could appear or disappear in a swirl of light orbs.
 * Conjuration: She was able to create simple objects, such as a crystal ball, from thin air.
 * Scrying: She could spy on another person using a reflective surface, like a crystal ball. She used this to show Prudence Hawthorne how Sara Lance intended to allow her mother to die as history intended, in order to convince Prudence to stay on her side.
 * Transformation: Tabitha could transform humans into animals, like pigs.
 * Biokinesis: With a wand gesture, she was able to prevent John Constantine from speaking.
 * Telekinesis: With a hand gesture, she threw John Constantine away.
 * Apportation: She was able to teleport people from one location to another, as in the case of Jane Hawthorne, Zari and Reverend Parsons.
 * Pyrokinesis: She could summon fire from the pit of Hell to burn Salem people.
 * Reality warping: Tabitha was able to use some of her powers on the whim, like turning reality into a musical, similar to Music Meister.

Former weaknesses

 * Host dependence: Fairies that require hosts can only use their powers under the explicit consent of their charge. If the host breaks their bond or renounces them, the fairy will be unable to cast magic. Since giving the Fairy Godmother's wand to Nora and being released from the curse, this is no longer a weakness for her.