Princess Celestia always knew that Twilight Sparkle was destined for great things, but she never revealed the source of that knowledge, not even to those closest to her. When the day of Twilight's true destiny finally arrives, can Celestia fulfill an ancient promise to save Equestia's past, present, and future, even it means saying goodbye to Twilight forever? How can Celestia refuse her mother's last wish?

Art by the inimitable Harwick

Twilight Sparkle has always loved Celestia—as a friend, and a mentor, and something else as well. And she finally, finally found the courage to admit those feelings.

Celestia turned her down as gently as she could. That's what she thought, anyway.

But the night is still young—and it's a night for being wrong.

[Rated T for suggestive sexual content. This story takes place between the Season 2 and 3 finales. Additionally, I wasn't able to find the artist who did the cover art, if anyone knows please drop me a line so I can credit them.]

This story is a sequel to The Celestia Code

When the monsters created by the dark crystal engine escape their prison, it's up to Princess Twilight Sparkle to deal with them. She gets help and advice from Princess Luna, but things don't go as planned. In fact, when a pony who relies on logic and rationality tries to navigate the stormy seas of emotional entanglement while simultaneously saving Equestria from a horde of evil creatures intent on destroying everything they encounter, nothing goes as planned.
AUDIOBOOK by VisualPony
WARNING: Major spoilers in the comments.

Book 2 of the Alicorn Adventure series.

Goodreads Page
100% Approved by Twilight's Library!

The Badass Twilight tag applies more than ever, but please note the new tags.

This story is a fairly direct continuation of The Celestia Code. You might be able to follow it without having read The Celestia Code first, but it's better if you do.

The sequel is here: The Twilight Enigma

Most excellent pre-reading/editing done by the erudite AcademicPony and the dapper statoose!

On the Density of Alicorn Skulls: A sharp blow to the head can do odd things to one's personality. This is particularly problematic if the victim in question is a widely respected leader of her people.
On the Classification of Divinity: In some other worlds where magic exists, the inhabitants have attempted to quantify the different levels of godhood. Unfortunately, it is not a perfect system, and the Princesses have never been ones to flaunt their absurd levels of power.

This is a series of unrelated one-shots focused around Celestia, who remains one of my favourite ponies. It's marked completed, since there won't be a continuing narrative going between all of the shorts. It will continue to see updates though, since I have plenty more ideas for the Princess!

Now available in Spanish!

This story is a sequel to Of the Hive

Having fully embraced her new changeling heritage, Twilight Sparkle turns to the past to learn more about her people. A difficult task, given that every other queen cares next to nothing about it.

What she finds will shed unwanted light on a secret better left forgotten.

Editor in Chief: ABitterPill

Coverart: Tulip

Alicorns are immortal. Earth ponies, unicorns, and pegasi are not.

Princess Twilight Sparkle has no intention of going through life without her dearest friends...

Even if she has to do something extremely questionable to make that happen.

The Canterlot Archive decides to create a document listing the age of every pony in Equestria. It's impossible to mess this up.

The Canterlot Archive messes this up.

Proofread by Octavia Harmony.

Special thanks to Selbi for additional help.

Live reading by CaptainBron3y

This story is a sequel to For the Hive

A few months after the events of Queen Twilight Sparkle's reveal that she and her hive can produce love, the changeling hives find themselves in an arms race. As Aegis Altair watches over her queens haggling with the minotaur emperor, she finds something that just might give Phoenix's Roost the edge it needs to come out on top.

This is a short interlude before hive book 3.

Collab with The Abyss (Chapters 1 and 2)

Proofread by Neko Majin C and edited by The Abyss (Chapters 3 onwards)

Twilight Sparkle has always ignored Hearts and Hooves Day, seeing it as just another normal day with extra chocolate and the occasional broken-hearted friend to comfort. But when Rarity convinces her that not having a date during the holiday is contrary to proper princess protocol, Twilight rushes to do everything in her power to live up to the expectations presented to her.

There’s just one problem, though: Twilight has never been on a proper date before.

After a few rather disastrous attempts to find a date in Ponyville, Twilight goes to her mentor in Canterlot in a last ditch effort in the hopes of finding the answers she seeks. Princess Celestia, however, may have something more for her than either of them had anticipated.

After being summoned to a meeting with Wonderbolt Commander Spitfire, Rainbow Dash finally learns the truth about why she has been passed over by the Wonderbolts all this time. A little bit of Rainbowfire.