This story is a sequel to The Freeport Venture

As Freeport's best problem solver, Puzzle Piece finds himself helping the Magus-for-hire Sunset Shimmer with a job once again. The Sweetash family, one of the richest families in Freeport, has contacted Sunset with a new job to investigate ugly new rumors surrounding one of their rivals.

While the job seems straightforward enough, they quickly find out how a sweet deal can become sour.

Three rules:

Understand these, then contract negotiations may begin.

A side story to Chengar Qordath's The Freeport Venture. A different perspective to the infamous port city.
Written with permission.

It’s not every day you discover that your friend is in an adventure novel, but that’s exactly the situation Sunset Shimmer and Kukri Doo find themselves in when Puzzle Piece, Freeport’s foremost problem solver, makes an appearance in the latest Daring Do book. They only naturally ask Puzzle about it, and uncover a truth far stranger than fiction: a tale of adventure, intrigue, tyrant lizards, the mysterious dromaed people, and the fabled City of Giants.

A Freeport Venture prequel.

This story is a sequel to Northern Venture

Kukri Doo has a lot to think about after her trip to Northmarch. What was supposed to be a once-in-a-lifetime field trip with Sunset Shimmer turned into a horrifying struggle for survival—one that left hundreds dead and a city razed to the ground. It's a lot for anyone to deal with, let alone a changeling who's not even thirteen years old.

Kukri's come home to Freeport. If only it was that easy to leave all the memories of Northmarch behind.

Puzzle Piece is the premier information broker in the infamous nation of Freeport, leading one of the most powerful and wealthy organizations in the islands. However, after months of absence from Freeport, he returns to find everything he built in shambles and his lieutenants fighting over the remnants. With chaos reigning in the streets, the Council tells him to get his house in order or see his life’s work swept away. Unfortunately for Puzzle, there are forces in Freeport that don’t want to see him succeed. Nobody can be trusted, nothing is safe—not even his deepest secrets.

A chronological sequel to Northern Venture.

This story is a sequel to Freeport Venture: Auction Night

As Freeport’s foremost problem solver, Puzzle Piece knows that nothing is ever simple. An easy job today can create complications months or even years down the line. Sunset Shimmer’s acquisition of the Black Codex—a potent, ancient book of black magic—was just such a job. Now the warlocks she took it from have come to Freeport to take it back, and to put an end to Sunset for ruining their plans.

Puzzle Piece has no intention of letting that happen. Whether he can stop them is another matter entirely.

Sunset Shimmer originally went to Freeport to escape Celestia's influence, and to make some progress towards becoming an alicorn princess. She's certainly done her share of good in the infamous city of rogues, but after almost two years away from Canterlot she doesn't feel any closer to achieving her big goals. At this point, any reasonable pony could wonder if they made a mistake...

Faced with the unpleasant prospect of possibly going back to Canterlot in order to advance her goals, Sunset finds herself with one last option to preserve her independence: the great dragon Argentium the Runescaled, far to the north, wants to meet with her. However, her journey becomes far more than a simple social call, and Sunset has no idea just how much danger she and her friends will face.

Or how much she'll have to sacrifice—not just for her dreams, but survival.

This story is a sequel to Northern Venture

When Sunset Shimmer's father shows up in Freeport chasing the infamous warlock Steel Rose, the last thing she wants is to get involved. She's still recovering from the madness in Northmarch and her battle against the dragon Blackfyre, and her father's obsession with capturing Steel Rose drove him to effectively abandon his family.

However, as the magus of Freeport Sunset can't ignore a dangerous warlock running loose in her city's streets just because of personal baggage. Once she finds herself reluctantly dragged into her father's obsession, she discovers there's far more going on than she's been told.

This story is a sequel to Freeport Venture: Old Wounds

When one of her apprentice's friend-of-a-friends goes missing, Archmagus Sunset Shimmer doesn't hesitate to get involved. However, what initially appears to be a simple case of a missing child will wind up leading her to a criminal conspiracy and political intrigue at the highest levels of Freeport.

This story is a sequel to Freeport Venture: Blood and Iron

War rages throughout Equestria. The return of the Crystal Empire has seen years of strife and millions dead as Princess Celestia’s forces strain against Sombra's seemingly endless hordes.

However, the entry of Freeport’s forces turn the tide in Equestria’s favor. Archon Sunset Shimmer and her army smash into the fray, breaking the long, brutal siege of Manehattan and shifting the balance in Equestria’s favor. With Sombra's army falling back to his home territories, there's finally reason to hope again.

If only they knew something far, far worse than Sombra loomed on the horizon.