Fairy Queen

The Fairy Queen, also sometimes referred to as the Queen Fairy or Queen of Fairies, is the fairy that rules over all of the fairies and Great Fairies in The Legend of Zelda series. They are known to be much more powerful than the Great Fairies, and as such, they can empower Link with abilities that no Great Fairy can bestow upon the young hero. Various Fairy Queens have appeared throughout the series with their appearances changing drastically between each game.

A Link to the Past
Venus, the Queen of Fairies, lives in the Wishing Well located inside a cave on an island in the middle of Lake Hylia. Once inside, Link finds a long hallway leading up to a small pond, the Pond of Happiness, with two statues on each side. The pond asks Link how many Rupees he would like to throw in, which would then tell him whether he would have "good" or "bad" luck. The responses include "Great Luck", "Good Luck", "A Little Luck", and "Big Trouble". For every 100 Rupees Link deposits into the pond, Venus appears and grants the young hero the ability to either carry more bombs or arrows, with the maximum being 50 and 70, respectively. The Bomb capacity increases by increments of 5 until Link reaches 40 Bombs, where the capacity will then increase by an increment of 10 Bombs to 50. Likewise, the Arrow capacity increases by increments of 5 until Link reaches 60 Arrows, where the capacity will then increase by an increment of 10 Arrows to 70. After Link has received the maximum carrying capability for both his bombs and arrows, Venus will redirect him to a friend of hers, the Waterfall of Wishing fairy, who will grant him even more happiness.

Venus is last seen during the ending credits at her home in the Wishing Well, being named as the Queen of Fairies.

Link's Awakening DX
In Link's Awakening DX, a Great Fairy who is proclaimed as the Fairy Queen can be found within the Link's Awakening DX-exclusive dungeon, the Color Dungeon. She is residing in the last room in a pool, and as thanks for visiting her, she will offer to grant Link the 'power of color' by changing his green tunic into either a red tunic or a blue tunic. The red tunic will increase the offense of Link's weapons, whereas the blue tunic will increase his defense against attacks. Link can revisit the Fairy Queen to change between the two tunics, but he can never change back into his green tunic.

Oracle of Ages
The Queen Fairy in Oracle of Ages is known as the guardian of the sea and lives near the Eyeglass Island Library, protecting the waters of the Zora Seas. When Link first meets her, she has been transfigured by Veran into an Octorok, and informs the young hero that only by sprinkling the Fairy Powder on her can she return to her normal appearance. Link finds the powder and uses it on her, restoring her as the Queen Fairy and cleansing the sea of Veran's evil influence.

Curiously, the Queen Fairy from Oracle of Ages has the same appearance as the Great Fairies from this and other portable Zelda games.

The Wind Waker
The Queen of Fairies in The Wind Waker is located in the Mother & Child Isles, which can be accessed only by using the Ballad of Gales and after rescuing Aryll from the Forsaken Fortress. She rewards Link with the ability to wield the Fire Arrow and Ice Arrow.

Unlike previous Fairy Queens, she has the voice, appearance, and mannerisms of a child, although it is unknown if this is her true form. She also holds a doll resembling a Great Fairy, which is what she uses to grant the young hero the Fire and Ice Arrows. After the Queen of Fairies hands over the powerful arrows, she flirts with Link by saying that he is just her type, which causes him to blush.

Four Swords Adventures
The Queen of Fairies also makes a small cameo in Four Swords Adventures during the Hyrule Castle level. She had heard the Shrine Maidens' cries from afar and came to the castle in an attempt to help them, but found that the castle was overtaken by fiends who captured her and split her into two River Zoras. She asks the four Links to find her other half, and when he does, they reunite and reveal themselves to be the Fairy Queen, who easily obliterates the barrier and soldiers guarding the entrance to the castle. As thanks for helping her, the Queen of Fairies promises the four Links to tell the other Great Fairies to help them whenever needed.

Even though the Fairy Queen has a similar appearance as the one from The Wind Waker, she curiously refers to herself as a Great Fairy after she recovers her true form. The power used by the Fairy Queen during the Hyrule Castle level is the first and only time thus far that allows the audience to catch a glimpse of the tremendous power that Fairy Queens possess.

Theory
In the concept art of The Legend of Zelda: Skyward Sword, released during E3 2009, Link was seen lacking any sort of sword, although he was accompanied by Fi, who was unrevealed at that point. The theories at the time were that it was either an anthropomorphization of the Master Sword or that it was the Fairy Queen as she appears in The Wind Waker and Four Swords Adventures. However, no connection has been confirmed between the Fairy Queen and Fi, and the resemblance may simply be a design choice on the part of the development team.