The whole point of the aptly named otherKatsuhiro Otomo masterpiece The Legend Of Mother Sarah, which features a mother trying to retrieve her lost children and who will stop at nothing to do so, including brawling and using guns. It helps that she's an unusually tall and jacked woman.
Nanoha and Fate, the co-leads of Magical Girl Lyrical Nanoha StrikerS, are mothers through adoption and still amongst the best combat mages out there. When their daughter Vivio is kidnapped, both Nanoha and Fate proceed to kick ass and take names, Nanoha to get Vivio back and Fate to take down the man behind it all.
There's also Quint Nakajima, Subaru and Ginga's mother, who was an Enforcer until her death. It's revealed in the Sound Stages that Quint was considerably stronger than Subaru or Ginga, being able to wield both Revolver Knuckles (her two girls inherited one each), while neither of them can do so as of the end of StrikerS.
Eureka in Eureka Seven, a mecha pilot who adopts three children before the series starts. Three children she personally orphaned.
Izumi Curtis from Fullmetal Alchemist is a housewife and proud of it, and more or less adopted the protagonists after they lost their mother. She can - and does - beat up most of the other characters in the series (and, for bonus points, does so despite the fact that she's missing several internal organs).
Although all the action is performed by mind-controlled robots, and, in the anime, she's in a wheelchair, Shuuko from Kidou Tenshi Angelic Layer decimates every other opponent in the Tournament Arc except one (and she wins that one in the manga). She has taken the abandon-your-child-to-relatives-and-then-to-your-sister path (in the anime, she fears her child would be ostrasized for having an "useless" mother), but in the end, reunites with her daughter and is seen competing side-by-side with her.
A subtle example is Shizuka Kusanagi, Kyo's mom who has only appeared in the The King of Fighters: Kyo manga. She is a beautiful woman who only wears kimonos and is all polite and motherly...and also points a naginata to the neck of the ninja Eiji Kisaragi when she finds him digging in the archives of the Kusanagi family, sweetly asking him to stop whatever he's doing. When Kyo comes back home, he finds his mother and Eiji calmly drinking tea, and Shizuka is all smiles but Eiji looks still unnerved.
By Macross 7, she's a mother seven times over (plus one adoption) and she still can keep up with her husband. And yes, they're both probably the best pilots in Macross 7 despite being in their 40s-50s, as Macross 7 is set 35 years or so into the future. So, yeah.
Empress Marianne vi Britannia, a.k.a. Marianne the Flash, from Code Geass, who managed to be a Humongous Mecha test pilot, Lady of War, and Rebellious Princess, all while still being a sweet and loving mother to her two children. It's no wonder that she serves as inspiration not only to them, but also to the majority of her step-children who appear in the anime.
Misaki Jurai Masaki, the junior Empress of Jurai, is not only the Aeka and Sasami's mom, but also the head of Emperor's Guard and uncontested martial arts champion of the whole Jurai Empire for as long as she is bothered to compete. And her mom, Seto Kamiki Jurai, while actually ruling in place of her son-in-law, still finds the time to justify the reputation that gave her the famous nickname of "Devil Princess of Jurai" (Even the first Big Bad of the series gave her a wide berth!).
The senior Empress of Jurai, Funaho (Yosho's mom), is director of the Intelligence division. In one episode of the Manga, an assassin tries to kill her on a trip to Earth by dropping a steel girder on her. She stops its fall with a single jab, nearly bending it in half, without even standing up.
Lena Sayers from Mai-Otome, the original Blue Sky Sapphire holder, whose past is explored in the prequel. She's the mother of the main series' heroine, Arika. While she was defeated in the Aswad's attack on Windbloom's castle because she lost her powers, she was apparently able to put up enough of a fight to be considered a Worthy Opponent by the Aswad, who hoped to give her a proper burial.
Naomi Armitage from Armitage III, though it doesn't seem that way at first. She, her human husband Ross and her daughter Youko were hiding from All of the Other Reindeer at that point, Fantastic Racism having won the day in the form of feminists who weren't fond of the concept of being replaced by machines; She really needed to keep her head down. You could tell Armitage was having the time of her life showing off her cyborg Mama Bear side after little Youko is kidnapped and she had to go after the culprits.
In Ikki Tousen, Hakufu's Older than They Look mother Goei (expy of Madame Wu, mother of Sun Ce's aka Hakufu's past self) is no frontline fighter and prefers to take care of the Shuuyu household, but either call her "old woman" or threaten her directly, and you'll have her prove that she can defend herself rather well.
In GEAR Fighter Dendoh, Ginga's mom is a Kenpo instructor who will beat the crap out of almost anyone smaller than a Monster of the Week. And then there's Vega, who turns out to be Hokuto's mom in disguise.
In Kekkaishi Yoshimori's mother Sumiko seems to be this, she appears to be Walking the Earth leaving her very domestic husband and Old Master father to raise her kids, her only appearance outside of flashbacks involved her throwing a dragon(which she had apparently beaten unconscious and dragged across the country) at her son The Hero from great height, then beating said dragon into submission when it came for her. Also in a flashback she killed a god seemingly just for shits and giggles, and because the god's still-in-the-womb kid told her too.
First and foremost was Bellmere, who was a Marine on the front lines of battle when she discovered two orphaned children, Nojiko and Nami, and took them home to raise. When Arlong attacked their island, she alone attempted to fight back. Failing that, she willingly gave her own life to ensure Nojiko and Nami's safety.
Cattleya in Queen's Blade is a mother, weaponsmith, retired adventurer and owner of some of the largest breasts in all of anime. Bonus points in usually fighting with her son Rana tucked under her arm.
Aki Hinata from Keroro Gunsou kicks butt when she has to. For starters, she's got a black belt in aikido.
Oka Nishizawa, Momoka's mother, is an even bigger example. She met her husband Baio during a world martial arts tournament, and is introduced when she sneaks into her husband's mansion in Japan and beats the crap out of the security.
A later chapter shows that Aki is apparently the only person who can match Oka in a fight.
Tsume Inuzuka of Naruto is the single mother of two teenagers yet has maintained not only active ass-kicking status as an elite kunoichi but also runs her own clan.
Kiba: (thinking to himself) Yeah, mom... just like with dad.
Kushina Uzumaki, Naruto's mother, battles the series Eldritch Abomination and the Big Bad controlling it while dying. She takes a claw longer than she is tall to the stomach and catches it on its way out to protect her son. This all takes place about one hour after she gave birth and then had the Kyuubi forcefully dragged out of her, something that was previously always fatal.
Princess Kaguya effectively became a Physical God before giving birth to her children and only got stronger after that. Unfortunately, she also became Drunk with Power.
Ryougi Shiki in Kara no Kyoukai. No surprise there, you knew it was gonna happen eventually.
In an episode of the original Digimon Adventure, Sora Takenouchi's very traditional mom, Toshiko, takes up this mantle for an episode in a Mama Bear bid to rescue her daughter from Phantomon. She comes up with a plan to disguise herself as one of the hordes of Bakemon (along with Biyomon) and then volunteer as the one to "capture" her daughter, who's being pursued by them. Her bid pays off and Sora is rescued, even if Toshiko ends up captured in her place. Maybe not true Action Mom status, but about the closest one has ever gotten in a Digimon series.
Cordelia Gallo in Gosick. Try not to cheer when she goes on a Roaring Rampage of Revenge against the man who destroyed her life by kidnapping and raping her and forcing her to bear his daughter, in the name of the daughter who she loves anyway, and kills him. She dies shortly afterward, but damn.
Alanna Strange from the DC Universe definitely fits the trope, seeing as she's apparently capable of fighting her way past the bad guy's guards, sneak into the room where he's gloating over her captured husband, take out the guards there with nerve pinches without him noticing, trading insults with him for a few minutes and then knocking him out - all while carrying her daughter in a sling around her neck.
The original Red Tornado, although mostly played for laughs.
Julia Diggers of Gold Digger, where having three grown-up kids doesn't keep her from still being one of the top fighters of the fantasy world of Jade. In the series the parents getting involved is generally a big warning sign that things either have gotten really serious or are about to be wrapped up very quickly and painfully for the other party.
Now that she's had a daughter of her own, Julia's adopted daughter Brittany Diggers has become a rather fierce example herself.
Julia's own mother, Brunhilda Brigand, is an action mom herself, one of the few fighters who can match Julia. It really runs in the family.
Hippolyta of the Wonder Woman mythos. Never mind the fact that Diana is an adult...
The female Dr. Light is the mother of two, and the former leader of a Justice League team.
Talia Al Ghul after giving birth to Damian Wayne is still badassed enough to brandish a handgun and wear a sexy catsuit or have Batman tied up against his will.
Nomi Sunrider of Tales of the Jedi serves as a knight in the Krath and Great Sith Wars. In one ambush, she actually fights with her daughter Vima on her hip, and in fact got started on the Jedi path when defending herself and her daughter from her husband's murderers.
In the Fanfic What Have You Done, Twilight Sparkle's mother, Twilight Velvet is well trained in emphatic spells, and uses them quite effectively against a group of Changelings. Before that glorious moment, we saw her stand up to Princess Celestia for her daughter's sake. Bad.Ass.
Field Of Innocence: Before she died, Lu Ten's mother, Colonel Kei Rin, was one. She was such a feared soldier that the Earth Kingdom army had a 'flee on sight' order for her.
In AA Pessimal's Discworld imaginings, Doctor Davinina Bellamy is the Action Mum. in appearance blonde, bespectacled and mumsy, she runs her own floristry business, has a PHD in Botany, and is married with three sons. Her knowledge of the language of flowers note specifically, how to say Drop Dead! in a dozen stylish and inventive ways draws her to the notice of the Guild of Assassins, who need a Botany teacher for the School. She passes the Mature Students Course and takes up a new career, all the time being a devoted wife and mother. She even gets two of her sons accepted by the School for Assassin training.
Film — Animation
Pictured on this page is Helen Parr, a.k.a. Elastigirl of The Incredibles, who can still kick butt with the rest of her family despite having more than a decade of hiatus.
Helen herself seems to invoke a kind of this trope in one deleted scene, by blowing her gasket at an Iron Lady who belittled her choice to become a stay at home mom, ranting about how raising children is, when you come down to it, a much more difficult job that is much more important to the survival of humanity than said business lady's swanky executive position ever will be, even when you don't consider that Helen's children will save the world.
In Meet the Robinsons, Franny's main hobby outside of conducting frog bands is practicing her karate skills, demonstrated at the dinner table complete with bad kung fu movie dubbing.
Though they aren't technically mother and children, 7 from 9 plays this role to 3 and 4.
Crouching Tiger, Hidden Dragon. Jade Fox, while not a blood relative, appears to be a stronger maternal figure to Jen than her own mother. She seems to look up to Shu Lien in the same way, later in the film.
Karen Barclay is forced to become this over the course of the first Child's Play film.
Brooke Smith pushes this trope to its logical extreme in the dark comedy Series 7: The Contenders in which unwilling contestants in a reality TV show are forced to hunt down and kill each other. Smith plays Dawn, the heavily pregnant reigning champion, waddling her way between hits.
Jane and Jeff Blue from Undercover Blues are total Action Parents, bringing their baby girl with them through all kinds of spy adventures.
Ellen Ripley. In Aliens, her relationship with Newt is completely maternal, even though they're not biologically mother and daughter. Much ass-kicking is induced by that relationship. "GET AWAY FROM HER, YOU BITCH!", indeed. The directors cut of the film also reveals that she had a daughter back on Earth before leaving on the trip that sets off the series. Said daughter grew old and died while Ripley was lost in cryogenic sleep for 57 years, making her connection with Newt all the more significant.
Although she tries and fails to embrace the housewife role, Beatrix from Kill Bill could fit this trope, especially since in the end it is implied that even though she is reunited with her daughter, she's probably not going to be able to go forever without kicking ass.
Zin from Chocolate is a former loan shark. She spends most of the movie trying to give up her old life, but when she's threatened she proves she's still extremely dangerous.
Mrs. Peltzer from 'Gremlins'' goes to some...extreme lengths to defend her home from the titular monsters.
A brief moment in Thor has Frigga proving that a strong son comes from a strong mother. When she sees that the Frost Giants are invading and Odin was under the Odinsleep at the time, she wastes no time grabbing a sword and killing Laufey's lackey with one hit for coming after her husband.
This is upped in Thor: The Dark World, where she duels the main villain Malekith and defeats him, only to be stabbed in the back by his Dragon.
Both Helena and Titania of the Alterien series fit this category well, as they continued to occasionally kick ass as the mothers of many children.
Astral Dawn. If one counts the many children Ixchel has had in previous lives, then she too could be considered an "action mom". The same is true of other goddesses in the series as well.
Tamara Hoyle from Remnants, a former Marine who fought off countless aliens with her Enfant Terrible strapped to her hip.
Magrat Garlick from Discworld, who became a far more competent and dangerous witch when she upgraded from Maiden to Mother. This is not entirely unexpected by witches. Nanny Ogg is still technically the Mother in a coven by reason of having a lot of (grown) children, not being young.
Thursday Next, in the later books has a regular habit of dashing back from her action exploits to look after her child.
Charity Carpenter of The Dresden Files has seven kids, but that doesn't stop her from kicking ass. We learn in Death Masks that she makes all of her Holy Knight husband's armor, and in Proven Guilty,she joins Harry in storming a faerie queen's stronghold to rescue her kidnapped daughter, armed with swords and mail she herself forged.
She's also her husband Michael's training partner. She can definitely wield a sword.
Lisanne Norman's Sholan Alliance Series features Carrie Hamilton-Aldatan. She finally gives birth at the end of the third book, but continues on her merry butt-kicking way.
In Christopher Stasheff's Warlock of Gramarye series, Gwen Gallowglass is a devoted wife and a loving mother to her four children. She is also a ridiculously high-powered psychic, and God help you if you lay a finger on her or her family.
Leia counts as well, though the "action" part doesn't suit her in the traditional sense (what with getting caught up in politics and all). Not at first, anyway; she eventually goes full-time action-y in the Dark Nest series (she got sick of politics).
And another EU example: Tenel Ka, Dark Nest onward. While we don't see her fight much (queen and all), she's proven herself more than capable of defending herself and her daughter, who just happens to be Leia and Han's granddaughter, from all sorts of threats, including two assassination attempts.
Having three kids hasn't slowed Tamora Pierce's Alanna the Lioness down at all; she's continued to be the King's Champion and one of the most notable knights of the realm for over two decades.
Daine appears to be doing fine with two kids. And Aly has triplets, according to Pierce, and shows no signs of slowing down. This technically makes Alanna an Action Grandma. Observe the entirely unsurprised fandom.
IIRC, Keladry's mom was pretty badass, too.
Caroline Wagner of The New Heroes continued to fight as her superhero alterego Energy for three years after her son was born. Even after she lost her powers she continued to be an action Mum, teaching her son how to fight, outwitting mecha-armoured baddies and making sure everyone in Sakkara gets their homework done.
The eponymous Jennifer in Jennifer Government is a single mother and a government agent. Also, badass.
The Temeraire series features several action girls and action moms despite the era (Napoleonic wars), because of a quirk of dragon biology: one breed, the Longwing, will almost never accept a male captain. Jane Roland is a fine example of a rare Action Mom who is not a total Mama Bear as well. For that matter, any female dragons that have had eggs that hatched would probably count.
As noted on the Lady of War page, this is what David Weber's idea of an empowered woman looks like. So it's a no-brainer that his series — mostly Honor Harrington, but others as well — are chock full of them. If you see an Action Girl there, who also happened to discover the joys of motherhood, you can safely bet on her being an Action Mom too.
Ramses' wife, Nefret Emerson, seems to be carrying on her mother-in-law's legacy quite well, being the mother of twins and still keeping up with her husband in the dangerous games of disguise and espionage that he plays with his bloodbrother, David Todros.
Sally Jackson in The Last Olympian. When faced with an army of some of mythology's deadliest monsters, she grabs a shotgun from the nearest police car and joins the fight, despite having apparently never fired a shotgun before in her life and being a (for the most part) normal, mortal mother.
Liadan in Son of the Shadows fights her way through Side Dubh to save Bran with her infant son strapped to her back.
The Codex Alera's resident Mama Bear, Isana, doesn't do much action-wise at first, but as the books go on she gets more and more involved and in the second half of the series participates in breaking a prisoner out of The Alcatraz, challenges a noble to single combat, and single handedly takes down a half-dozen Vord warriors.
In the Star Wars Expanded Universe novel Han Solo at Stars' End we have Atuarre the catfolk "Trianii Ranger." Her husband and son were captured by the evil Corporate Sector Mega Corp., but she rescued the kid herself. He had been tortured and the trauma left him mute. Now, with the cub in tow as a sidekick, she will join Han Solo and whatever to face overwhelming odds, defy the bad guys and make hubby proud—if he's still alive. She probably went Mama Bear to save the son, but that was off-screen.
The hero of Princess of Wands is one of these, although not really known by most of the rest of her family since she keeps those activities separate from her housewife life.
Ann Vinn Mullhaney of Time Scout is Time Terminal 86's second/third most deadly individual (it's a toss-up). She also happens to be happily married and a mother.
Bridget, mom of one teenager, in the Inheritance Cycle is the sole female from Carvahall to join the Varden army. She does this to protect one of the main characters so she can have revenge on him for the death of her husband. She is also the sole female fighter in the entire human army aside from the Herbalist Angela and the leader of the Varden, Nasuada.
While a few main characters are old enough to have children, and grandchildren, the standout Action Mom in the Breaking the Wall trilogy is Nissa Nita, who's raising her two year old daughter while learning the magic necessary to perform her role as one of the Thirteen Orphans.
Warrior Cats. Though she-cats take a break from their warrior duties when they have kits, they still have to be ready to protect their kits if the camp is attacked. One gift that new leaders are often given as part of their nine lives is the love a mother has for her kits, in order to help them protect the Clan; this life is often expected to feel gentle, and the new leader is often shocked by how painfully fierce it is - mothers are willing to face any amount of enemies or even die for their kits. One particular Action Mom is Leafstar: leaders normally are not allowed to have kits because it conflicts with their duties, but Leafstar decided to have kits anyway.
Also Daphne in one possible future that appears more and more likely to come to pass. Technically a "Dark Action Mom" as she's working for the bad guys, but it's more out of ignorance than genuine malevolence.
Piper Halliwell from Charmed, especially since she became the strongest sister after Prue's death.
It doesn't happen until very near the end of the miniseries, so she doesn't get much time, but Aeryn Sun wastes none: she gives birth to her child and moments later takes point on the team that intends to get the protagonists back to their ship.
Mahou Sentai Magiranger: Ozu Miyuki is the transforming superheroine MagiMother. When the bad guys awaken, her five children must join her as Magirangers and fight them. She is defeated by Wolzard at the start of the second episode and spends the bulk of the series presumed dead. her first action upon her return is to stop the Hades God Toad's Divine Punishment and then lead her family in killing him.
Since being a mother is mandatory on a soap opera, many female characters eventually become an Action Mom. This was particularly evident on General Hospital during the 1980s, as (former spy turned police commissioner turned private investigator) Anna Devane regularly fought off various villains and enemy spies all the while raising her young daughter Robin.
The mother of Principal Wood in Buffy was a slayer and so fought the vampires even after Wood was born. And Spike had to kill her...
Gwen cements her status as Action Mom in the first episode of Miracle Day. Holding a pistol with one hand and her infant daughter with the other (having first slapped a pair of earmuffs on the tyke in order to protect her baby ears), she proceeds to have a decent go at shooting down a helicopter full of men with machine guns.
Star Trek: Voyager. Captain Janeway is openly referred to as being a "mother to the crew", and certainly gets Sigourney Weaver on the ass of anyone who threatens them. Probably the most overt example is in "Dark Frontier" when the Borg Queen retakes Seven of Nine back into the Collective, resulting in a custody battle fought with phaser rifles. The two-parter even ends with Janeway "tucking Seven into bed" (i.e. plugging her into the regeneration alcove).
Jennifer "JJ" Jareau of Criminal Minds continues to work for the BAU after she has her son.
Lindsay Messer on CSI NY. Continues to work as a detective while raising a daughter with Danny. Goes all Mama Bear when Shane Casey is holding her daughter with a gun to her head. One shot, one kill.
Catherine Willows on CSI: Crime Scene Investigation probably counts too. She isn't a cop, but still gets her share of actions sequences. And Do NOT mess with Lindsey.
In the second season of Falling Skies, Dr. Glass specifically delays telling the father of her child that she's pregnant because she wants to go on a particularly dangerous mission with him.
Mrs. McCall of Teen Wolf is an interesting example. At first, she was unaware of her son Scott's being a werewolf—but once she became privy not only to that, but all of the supernatural goings-on in her town, she quickly rose to Action Mom status, helping to fight off the various monsters that attack Scott and his friends.
Carol from The Walking Dead Carol She is a zombie killing Bad Ass. This trope is subverted when Her daughter gets infected, and subsequently gets the shit shot out of her.
I Love Bees had Gilly and Gladys, ass-kicking special forces soldiers, and biological and surrogate mothers respectively to Action Girl Jan.
When Kharma / Awesome Kong gave birth to her first child on December 31, 2011, people did not expect her to be back in the ring for a few more months. So imagine everybody's surprise when she apeared less than one month later as the third woman to ever participate in the Royal Rumble, easily tossing around any male wrestler who tried to confront her.
Sadly, it was later revealed that her child did not survive birth.
Catholic military victories tend to get attributed to the intercession of Mary. There's a reason one of her titles is "Our Lady of Victory."
Sarah Bishop in Dino Attack RPG fits this role rather nicely. At first she seems a rather gentle woman who just wants her daughter to be safe... that is until she gets a chance to actually go out onto the battlefield.
Spanish fanzine-turned-comic-book-turned-RPG Fanhunter introduced the generic character of the "Ninja Granny" (original: "Ag? ninja"; later concretized in at least one individual), who supposedly learned ninjitsu in some Age Concern course, kicking the players' collective ass and them intending them to eat her "coqrettes" (original "cocretas" instead of "croquetas").
In the Fanhunter comic there's also Belit. She keeps her badassery even after giving birth to John and Erika.
The Weapons Of The Gods RPG has the "Xia Pregnancy" martial arts technique that allows a woman to fight at (almost) full strength while pregnant. It also protects the foetus from any attack that does not kill the mother, and, during the third trimester, protects it from attacks that DO kill her.
Sophitia Alexandra from the Soul Calibur series doesn't count originally, being retired after becoming a mother in Soul Calibur 2, with her younger sister Cassandra stealing Sophitia's weapons and going off to destroy the Soul Edge and save her two infected children in her sister's place. However, Sophitia gets brought back in the home versions of the game, where she has her husband Rothion (the same blacksmith who forged the blessed weapons that Cassandra stole before she ran away) make her new weapons and sets out to correct the matter. She has remained an Action Mom ever since.
Misato from Triangle Heart 3: Sweet Songs Forever is Miyuki's mother and one of the toughest enemies in the story. Nanoha got it from somewhere. Like Shuuko, she abandoned her child to relatives, but getting her back didn't diminish her fighting skills, and she becomes a high-ranking member of the Hong Kong special forces.
Yuuno/Juno the Falcoknight from Fire Emblem: Binding Blade. She returned to the battlefield to protect Ilia, her homeland, few months after giving birth to her unnamed daughter. It also helps that her sisters (Thite and Thany, whom she raised due to Parental Abandonment) and husband (Lord Zealot of the Odessa clan) are members of Roy's party as well.
Even earlier, there's Eyvel from Thracia 776, fighting to protect her adoptive children and her village. She actually turns out to be a biological mom with a bad case of Identity Amnesia; in her ending, she recovers her memories of being Princess Bridget of Jugby, and reunites with her kids.
Taken to ridiculous space-time bending levels in Fire Emblem Awakening, where every married first-gen female party member will each have at least one recruitable time-traveling kid from the future, though only Chrom's wife will have actually birthed a child during the events of the game.
For more space-time shenanigans, the second-gen ladies can also become this if they marry the Avatar, in which case their child will come from an alternate future.
The Boss of Metal Gear Solid 3 is the greatest solider of the century, and is also a figurative mother to her Quirky Miniboss Squad and Big Boss, and a literal mother to Ocelot, whom she gave birth to on the beaches during the Normandy invasion.
And by "gave birth", we mean "self-administered caesarean".
Big Mama also qualifies.
Chun-Li becomes this after adopting not only a little girl she rescued from Gill's clutches, but also other children in Street Fighter III 3rd Strike: Fight for the Future.
Crimson Viper from Street Fighter IV has a daughter, Lauren, who she calls in one of her win poses. Her Super SF IV ending features a really sweet meeting between them.
Emma Honeywell from The Last Remnant. And she's a complete Bad Ass at that. Her daughter Emmy is just as good of a fighter, and is one of the best party members you can use (though her bearing on the actual plot is nowhere near what her mother's is).
Warcraft has some of these, such as Vereesa Windrunner and Garona Halforcen.
Karin from Shadow Hearts: Covenant could be argued to be one, though the time loop complicates things.
Female dwarves in Dwarf Fortress have no problems with serving in the military. The frequent breaks associated with military service, however, tends to lead to these dwarves having lots of babies if they ever get married. They also don't mind charging into battle juggling a crossbow and three babies. Nor do they mind using the babies as impromptu shields.
In Dragon Age: Origins, the Human Noble's mother is implied to be a Retired Badass, and describes herself as "no Orlesian wallflower." When your castle is under attack, she is pretty handy with a bow and arrows... unfortunately, she dies at the end of the origin, after staying behind to defend her mortally wounded husband.
In addition, the City Elf's mother is stated as having been one of these before she tragically died. She's the one who trained you, and Duncan mentions having wanted to recruit her for the Wardens years earlier.
If the Warden's Keep DLC is installed, the Warden and company will learn about Sophia Dryden, the great-great-grandmother of new acquaintance Levi Dryden. She was a noblewoman sentenced to join the Grey Wardens, and retaliated against the sentence by working her way up to the rank of Warden-Commander. Her children are never seen nor mentioned, but given that Levi is her direct descendant, the implication is that she must have had at least one.
Flemeth is a villainous example of this, with her daughter as her arch-nemesis. However, in both the first and second games, she also provides both the Warden and Hawke with a well-timed rescue from Darkspawn, the former occuring off-screen, while the latter involves her showing up as a dragon and roasting the Darkspawn, before transforming into a Witch and casually introducing herself.
Providing the Dark Ritual is performed, Morrigan can become this.
Etsuko from Incredible Crisis. Despite being an average-looking Japanese housewife, she manages to dodge heavily-armed bank robbers on a snowboard, then pilots a fighter jet into battle with a giant rampaging teddy bear.
The hero's mother, Miranda, in Grandia III taught him how to use battle magic. She also apparently sparred with him to teach him swordsmanship. When you fight alongside her, she's... intense. Out of combat, she's a different kind of intense.
And it's implied in the first Grandia that the hero's mother, Lily, could have qualified for this trope as well.
Lucia form Suikoden III. The main character's mother and a playable combatant.
In the Spacer background for Mass Effect, Shepard's mother is the executive officer of an Alliance warship. In the sequel, she's a Captain who, according to news reports, passed up an Admiralty to remain a Captain; and after the Reapers hit Earth in the third game, Admiral Hackett mentions to an obviously concerned Shepard that, yes, she did indeed survive the attack, has been promoted to Rear-Admiral and is one of the people in charge of the Crucible Project.
Most of the female characters in Dynasty Warriors naturally have children at one point or another, and all of them kick major ass, but Zhang Chunhua is the only one whose sons are also playable characters - that she fights alongside on multiple occasions - and she is characterized as an Almighty Mom feared by enemy and family alike.
The Pokémon Kangaskhan is a kangaroo-like Pokemon that has a baby in her pouch.
Fate/stay night: Saber and Caster. Mordred is actually King Arthur's bastard child in the legends. Caster is actually Medea, who was a mother in the Grecian myths; a crazy ass mother who killed her own children to get revenge for her husband Jason both dumping and horribly defiling her in the view of everyone, but a mother nonetheless. She also gives birth to more children later on; probably the most notable is King Medus.
Well, Saber is debatable. Apparently, Mordred was given birth to by Morgan Le Fay, with Arturia just serving as a sperm donor while being under a Gender Bender spell by Merlin.
Umineko: When They Cry's Eva Ushiromiya is a master of a bunch of different martial arts (very soon after her introduction, she threatens her brother Rudolf playfully by almost kicking him in the face), which she then taught to her son, George. They actually fight against each other in the sixth arc.
Plum Kitaki of Apollo Justice: Ace Attorney might count as one. She's the wife of the most powerful mobster in the city, and as such is one of the forces behind the criminal empire they run; she also has a son, Wocky, who she loves dearly. Plum is a big, jolly woman who spends most of her time sweeping the street outside her family's estate...using a broom with an extremely sharp katana hidden in the handle. When the police come to seize the family's weapons, she refuses to part with it. And whenever she shows you the blade, her face goes from broad and smiling to a look that shows she knows how to use that thing to do more than clean. You don't want to mess with her.
Vanessa Olsen from The Overture is a dotting mother of four and brutal warlord with a knack for Decapitation Presentation. Those who oppose her have a tendency to disappear, including her own sister-in law.
Mitzi McNinja of The Adventures of Dr. McNinja, who toughens up her sons by either poisoning her beets or challenging her eldest son (whose chosen profession as a medical professional she frowns upon) anytime he comes over to their house. In one story arc, Dr McNinja knows that something is very wrong because he doesn't have to fight his way into the house past her.
Jack Cannon was trained by his mother, who has shown herself to be more than competent in combat.
The backstory of Dragon Ball Multiverse 's Universe 3 brings us the saiyan Hanasia, aka: Goku's mom. Who starts training her newborn son at the tender age of one day. Later, when Bardock leads a rebellion against Freeza, Hanasia is chosen to break into the ship and wreak havoc with the enemy forces. This includes taking on Dodoria.
El Goonish Shive: Word of God says this is why Nanase's mother wants her to excel with a 4.0 GPA and be a master level martial artists despite contradiction of also wanting her to be a House Wife. ("Moms have to be intelligent, knowledgeable, and capable of utterly destroying anything that dares to threaten their children.")
AmberWatch Alert, a group that is obsessed with the possibility of pedophiles in our midst, made a gun porn PSA featuring four ostensible mothers, a metric ton of gun unsafety, and the tagline "You don't have to have a gun to protect your kid, but it helps". One netizen made the obvious connection; four people + gun porn = Left 4 Dead advertisement. The slightly altered video makes both an excellent parody and an excellent L 4 D 3 advertisement.
Lana from The Lionhearts is this, as she's a former circus lion and rather skilled on the trapeze.
Cheshire from Young Justice, who brings her baby daughter to a rescue mission to the annoyance of her husband.
The Legend of Korra: Suyin Beifong is a very capable Metalbender like her mother Toph was, and very protective of her children. When her daughter Opal is taken hostage (alongside the rest of the new Air Nation) by Arc Villain Zaheer, she immediately decides to participate in the fight against the villains.
Kerri Walsh Jennings, three-time Olympic gold-medalist in Women's Beach Volleyball, gave birth to two children in between her gold-medal victories in Beijing 2008 and London 2012.
Oksana Aleksandrovna Chusovitina, artistic gymnast and world champion who competed for the Soviet Union, the Unified Team, her native Uzbekistan, and Germany — in the last case, it was because of her motherhood, as it's in Germany that she and her husband found medical aid for their Ill Boy son. She's actually one of the very few gymnasts who have returned to high-level competition after having kids, which has made her a sort-of role model for female gymnasts. Not only that, she has had far and away the longest competitive career of any female gymnast ever, competing in six Olympic Games (she's currently planning to retire after her seventh, Rio 2016). To put this in perspective, she was an international elite world champion before most of her London 2012 competition had even been born. Bad. Ass.