Bleach: Shinigami are a military of ghostly warriors who protect the balance of souls between world and save humans from hollows. Although their primary focus is on channelling their power through their weapons, they do have the ability to use kidou. Those shinigami that manage to become kidou masters are therefore known for their ability to fight with both magic and weapons in battle. Level 90s kidou has such a mystique among shinigami that anyone who is capable of using it is extremely powerful. Yamamoto, Aizen, Urahara, Tessai and Hacchi are the only Kidou Masters who have so far used such powerful kidou. Aizen, Urahara and Hacchi have further developed their own customised high-level kidou techniques. Lieutenants such as Hisagi, Iba and Rukia are also well know for their kidou ability. Iba defied the 11th division tradition to learn kidou so that he could become a lieutenant in an unusually short space of time. Hisagi is a very balanced physical/magical fighter and Rukia's an expert at double-chanting (casting two spells at the same time). It's strongly implied that Yumichika is also a Kidou Expert due to his combat weapon's specialisation, which he keeps secret due to the 11th division being anti-kidou. it's confirmed in the final arc.
Unohana is the specialist Combat Medic of the military, her healing kidou being second to none (within the Gotei 13, that is). It's eventually confirmed she used to be an Ax-CrazyMartial Medic who used her healing kidou to keep herself and her opponent alive for as long as possible just so she could enjoy a good fight.
Byakuya is famous for his kidou ability and regularly supplements his fights with carefully placed, and extremely powerful kidou.
Hinamori is famous for her kidou ability. She was able to drive three fraccions to their resureccion through a complicated stacking of several kidou spells. Prior to that, she had more infamously escaped gaol by destroying the ward a captain had created around the prison and then cloaking herself well enough to go unnoticed by even the captains for a while.
Kira used to be a member of the Fourth Division so is one of the few shinigami outside the Fourth Division to have mastered high-level healing kidou. He also makes liberal use of kidou in battle, due to his zanpakutou being a very specialist tool designed for executing his opponents rather than fighting them to the death.
Nanao gained her position as lieutenant on the basis of her exceptional kidou ability. Although kidou is made up of reishi, something quincies are experts at controlling, it still takes Haschwalth longer than he'd planned to break down the barrier she set up to protect Kyouraku from him.
Lelouch isn't really a good pilot either, and still relies on strategy on a personal scale, so in mecha combat he's more a case of Weak, but Skilled.
It probably helps that his mech is designed specifically for defensive/strategy purposes, and that he himself had piloting experience previous to the rebellion via the giant pizza-making attempts of years past (using his mother's old frame, the Ganymede). He seems to be a case of an average-to-decent pilot going up against aces on a regular basis, making his very survival rather impressive, considering how close to death he's come at times.
Once he gets Shinkiro, he also benefits from its non-standard control scheme, which seems to work far better for Lelouch than standard Knightmare Frame controls.
Dai from Dai no Daibouken is this, being The Hero of a Dragon Quest based series: first as a swordsman that learns some offensive magic, and then enchanting his sword with fire and lightning. Baran also counts: he's a Dragon Knight, a creature that has the willpower of humans, the magic of demons and the strenght of dragons and is tasked to keep the balance between the three.
Erza from Fairy Tail, big time. Her type of magic is actually called "the knight" and is specifically about summoning swords and armor with various magical effects (though she abuses it and also uses her powers to change into pajamas, construction uniforms, a few dresses, and a bunny suit). Although it's not clear if she actually owns any other clothes than the Exquip ones.
EVERYBODY in Fairy Tail is a fighter/mage, its just too hard to make a shonen action manga without heavy fighter element. Erza is more of a fighter than a mage. She's basically just a fighter who summons magical equipment; just about every fighter in fiction uses magical equipments anyways.
Almost all mages in Magical Girl Lyrical Nanoha are capable of some form of close combat or other. Fate and her weapon's Scythe form being a prominent early example. Later, the practitioners of the Belka style of magic are literal Magic Knights (and are even called such), focusing mostly on physical power boosted by magic.
The only exceptions (so far) are Hayate (the single, strongest Glass Cannon currently exist in universe) who followed Squishy Wizard rule for not having defensive and melee skills whatsoever (except in the game).
It's possible that if Hayate were to try to enhance her physical body, that she'd tear herself to pieces. Her magic has control issues such that her smallest spells require evacuation orders.
CLAMP's Magic Knight Rayearth is a possible Trope Namer. The three protagonists are all gifted with elemental magic and evolving swords and use both extensively in their mission. The video game adaptation refines their roles to balance the gameplay (Hikaru is a Glass Cannon, Umi is a Fragile Speedster, and Fuu is a combination of The Medic and Stone Wall, plus their elemental specialties). In Part II we also have Lantis, a powerful sorcerer/swordsman who has the title of "Cail" which, in Cephiran, means "magic knight but not the legendary Magic Knights."
In Mahou Sensei Negima! the magic knight is a magical brawler who makes use of quick melee attacks, or quick magic attacks. Negi becomes this after learning martial arts from Ku Fei, and learns better magic attacks from Evangeline, and Rakan. Nagi is the best Magic Knight around.
Kotarou despises mages because of their squishiness, so he encourages Negi to choose the Magic Knight path instead.
Kamo calls Setsuna by the trope name here after he sees her using spell tags to form a defense.
Ariadne Knight Yue is somewhere along the lines of Magic Cavalryman, since her training is based on broom riding for combat. Her sword and armor is also of more textbook appearance of this class compared to Mage Samurai Setsuna and Mage Brawler Negi.
Evangeline A.K. McDowell is an odd case. During her initial appearance, she is described as a typical western mage and requires Chachamaru to cover her while she prepares the big spells. Recent appearance however shows her to be a terrifyingmagic brawler, capable of executing deadly magically powered up melee skills to complement her bombardment ones. She did say early on that as you improved the differences between magic knights and mages grew insignificant, after all.
Yuusha of Maoyuu Maou Yuusha. He's quite the swordsman, and famed as such, but he has a handy-dandy teleport spell, is a good enough magical healer that their party didn't need a dedicated one, and is shown in one of the manga adaptations blasting through multiple squads of demons at once with lightning.
This seems to be the standard for the Magical Girls of Puella Magi Madoka Magica; the loadout seems to be the ability to materialize weapons, boosted physical attributes, a unique ability, and rarely-used energy blasts.
To be specific: None of the main five cast spells that are directly offensive. They all summon weapons from Hammerspace and either strafe with bows, rifles and guns, or fight melee. Homura is the most triumphant example, using a magical time machine and Hyperspace Arsenal to unleash an unholy payload of bullets and bombs she stole from the Yakuza and the military...
Sieg Hart, in Rave Master manages to take out 1000+ mages by taking advantage of their preference for long range fights and beating the crap out of them with a magic absorbing sword rather than waste his own magic abilities on them.
Despite being a senshi, Sailor Uranus is strong physically and often prefers to bash rather then magically attack, the enemies. Has a magical sword as add-on weapon.
The manga makes Venus one: with the others she's prone to physically attack the enemy with melee weapons (usually her chain, but has been shown summoning an energy sword and actually killed Beryl with a stone sword) or just kick it into oblivion, and as Sailor V she regularly bashed the Monster of the Week before finishing it with a magical attack, or, in one exception, just beheaded it with a katana.
Tuxedo Mask is one in the manga as well; he gains some powerful attacks to go alongside his swordsmanship, unlike his first anime counterpart.
Lina Inverse from Slayers is primarily a wizard, but also has prowess with a sword. Most of the time, though, she relies on her spells to attack. Zelgadis is an even straighter example, being a far better and stronger swordsman than her, and a highly powerful shaman in his own right. Even Amelia gets in on the act being able to cast some quite potent shamanistic spells and a mean hand to hand fighter. Lina's sister is also implied to be this, being both the vessel for the fragment of a god and said to be capable of defeating a plasma dragon with just a kitchen knife. Lina, Zelgadis and Amelia also all have spells that take advantage of their dual skills. Lina has Ragna Blade, a powerful spell that takes the form of a sword, Zel has Astral Vine that temporarily imbues his sword with powerful magic and Amelia has Vizfarank that has a similar effect to Astral Vine on her fists.
Kaori of To Aru Majutsu no Index was really the only person to beat Touma because she didn't actually rely on her powers as a Saint and instead just used a sword. Granted, it's not actually magic. It's implied to actually be better than magic.
Acqua of the Back and the Knight Leader are highly skilled warriors and supreme mages.
Tower of God has the fighters known as fishermen, originating from the practice of slaying gigantic aquatic beats. They mainly use Shinsoo in reinforcement techniques or give short blasts, as opposed the Wave Controllers, who only use combat magic and Spear Bearers, who specialize in close combat.
Later in the same series, the replacement Syaoran is a strong melee fighter, and then turns out to be a very powerful mage as well (the other Syaoran had no magic.) Turns out he was hiding his magical ability from Fai so as not to trigger Fai's hidden time-bomb curse.
CLAMP uses these characters in Fuuma and Kamui in X1999 also.
In Manga/Rain, the titular Rain vowed to become the World's Strongest Man after a gang of brigands murdered a childhood friend and her grandmother while he was powerless to stop it. To this end, he not only became a Master Swordsman, he even mastered magic. He also wields an Infinity+1 Sword and absorbed the lifeforce and power of a dragon, granting him an Anti-Magic shield as a bonus. He's one of the best (if not the best) warrior in the world and he's a lot better at magic than most dedicated mages. While he's not the only Magic Knight in the series, few if any of the others approach him in ability.
Grimjack is primarily a warrior, but he knows somethings about magic. He's better with guns and swords though. It's stated while he has a great deal of magical power, he doesn't have a great deal of control over the power.
Thor of The Mighty Thor Albeit that his only magic is storm (wind thunder and lightning) based.
The eponymous Spawn has a vast array of magical powers in addition to his superhuman strength and endurance. These include teleportation, necromancy, and firing blasts of necroplasmic energy.
In A Growing Affection, Naruto and to a lesser degree Hinata become this trope, balancing melee attacks with medium to long range jutsu.
The dwarven noble protagonist in Dragon Age The Crown Of Thornsharbors a tear in the Veil that enables him to become a Barrier Warrior and use Razor Wind sword attacks, plus augment his physical abilities (though it takes an active effort). Unfortunately, it also comes with a wild magic effect that makes healing spells mostly useless on him and can cause spells to have unpredictable effects. Friendly fire included.
Gandalf of The Lord of the Rings fame was never a Squishy Wizard, and the Peter Jackson films showcased this. When faced with a Balrog, a giant nightmarish demon about fifteen feet or more in height, Gandalf tries using his magic first, but when that fails, he engages it with his sword and defeats it. He's also seen fighting in many other scenes in the LOTR movies as well as the first part of Jackson's The Hobbit, the only part released as of early 2013. This is consistent with the books.
Believe it or not, Merlin, the Ur Example of the old wizard, once got up to this in the 1998 Merlin film, where he wielded Excalibur before Arthur did, and used it to great effect. After all, he wasn't always old and frail.
In Star Wars, Jedi use the Force to give them a number of magical powers as well as swordfight effectively with their lightsabers.
Count Dooku in Episode II may most exemplify this, as he first defeated two Jedi effortlessly (Anakin and Obi-Wan), then fought Yoda with the Force to a draw, then finally fought Yoda with a lightsaber before finally retreating. It is unclear whether he was losing or simply realizing that fighting Yoda to the death was counterproductive. The effect was much improved by Christopher Lee, Dooku's actor, being an expert fencer.
This is almost a requirement in The Sorcerer's Apprentice. It actually makes sense that every magic-user would also be adept in some sort of weapons or hand-to-hand training, as its specifically stated that The Masquerade is to be kept up when possible, so it would make sense to be able to defend oneself without magic (and in the ages where Balthazar, Horvath and Sun Lok rose from, one needed to be able to defend oneself and others against a variety of mundane threats). This also explains why Drake and Dave aren't this trope and more of the Squishy Wizard variety; one's a celebrity who undoubtedly has excellent security, and the other's a high-level student/researcher who has no need to learn self-defense.
In the Fighting Fantasy gamebook The Citadel of Chaos, the player is a master wizard with some additional swordsmanship skills. His (or her) spell selection doesn't include anything for destroying his enemies, though: Just stab your blade to their gut and be done with it. (The fire spell could, probably, be used to this purpose, but the book won't allow it.)
Pip from the GrailQuest series uses both magic (being somewhat Merlin's disciple) and a sword (Excalibur Junior).
Lone Wolf and the rest of the Kai are an order of divinely empowered Magic Knights, although most of their powers are psychic in nature.
The Vakeros of Dessi are also an example, being warriors who use Old Kingdom Magic.
In the Grand Master books, Lone Wolf can learn Old Kingdom Magic and Left-Handed Magic (called Kai Alchemy in the books) making him a true Magic Knight. At higher skill levels these two disciplines even provide spells that can actually be used in combat.
On the villains' side, Lone Wolf can duel against a Ziran in Book 10, a Drakkar in full armor and fighting with a Magic Wand.
While the Rangers' Guild employs a few non-combat mages, e.g. for interrogation, those on the front-line also fit this trope.
The Clan of the Lynx has few mages, but those combine their clan's undisputed martial skill with battle-honed magic.
Vlad takes his pupils through Training from Hell, as their primary magic is mostly siege-grade Ritual Magic, and later develops a style to use that school of magic for quick close combat spells.
Death mages fuel their magic with the very "power of death" spilled in the area where sentients die. They are necessarily skilled in providing said power by killing the first opponents by mundane means, although prefer to leave the dirty work to their companions.
Demons in Artemis Fowl: The Lost Colony are divided into two castes: ordinary demons develop no magical power, but metamorphose into monstrous forms when they come of age, while warlocks develop magical talent instead of muscle. Demon warlord Leon Abbott managed to steal some magical power from a warlock when he interrupted a spellcasting ritual and caused a freak accident, and uses the stolen magic to secretly bewitch the rest of demonkind into serving him.
Garion from the Belgariad series (by the same author as above) also qualifies, being both a skilled (eventually) sorcerer and wielder of a BFS with the MacGuffin stuck on its pommel.
This goes back to 12th century chansons de geste with Maugis, Charlemagne's Wizard in Shining Armor.
Pretty much all Citizens from Codex Alera, as half the elements greatly bolster ability at swordfighting. Depending on the individual, they'll depend on swords or manifested furies to varying extents.
It's also taken literally, in that the most powerful mages are usually recruited as royal knights. This is most obvious with the Knights Aeris.
Some could interpret various characters in the Darkover series this way, as many Comyn lords were both trained as warriors and also possessed psionics.
Basically the hat of the Patryns from The Death Gate Cycle- as their magic is primarily physical in nature, easy to activate because it stems from the runes tattooed onto their bodies, and absolutely necessary to survive in the Death World they're trapped in, they're the undisputed masters of combining it with more traditional combat skills. Even Lord Xar, leader of the Patryns, despite looking like the stereotypical "robed and beared old wizard" and relying primarily on magic alone, is explicitly noted to be a deadly swordsman and in incredible condition for a man his age.
Lots of these throughout the Deryni works, including:
The Orders of the Michaelines and the Anvillers are full of these types, specifically trained to be both warriors and mages.
Alaric Morgan, Duke of Corwyn is Lord General of the Armies, King's Champion, and a Deryni sorcerer. His magic has the usual limits of all Deryni powers (requiring concentration to use it, for starters), and his arcane education is limited thanks to the persecutions.
To a lesser extent, Duncan McLain, Bishop-Duke of Cassan has both military and magical training. In addition to the limitations of Deryni magic, Duncan is a cleric who spent many years at university and in The Church, but he is shown both practising sword fighting and engaging in actual combat.
Younger men coming into their own as warrior mages include King Kelson Haldane, Dhugal MacArdry McLain, and King Liam-Lajos II Furstán.
Mustrum Ridcully from Terry Pratchett's Discworld. Oh, all of the Wizards like to get the occasional whack in with their staff, but Ridcully is definitely the best at it (aside from the librarian, an orangutan), and is pretty good in a boxing match (not common amongst wizards), and also owns a pretty good crossbow (ie, can take out two people with a single shot, and still keep going).
Morrolan and Aliera from the Dragaera series. Canonically, Morrolan is a better swordsman and Aliera is a better sorcerer, but Vlad notes that this is usually irrelevant because they're both so good at either. Most Dragaeran warriors qualify, because they are naturally strong, sorcery is readily available, and they have extremely long lifespans to master both skills.
Lord Ariakas in Dragonlance. Bonus points for also being the most powerful man on Krynn until Raistlin's rise.
This is justified by the Laws of Magic, which, among other things, forbid wizards from killing humans, and only humans, with magic, including using a gust of wind to push someone off of a cliff. Thus, all killing blows must be done with a sword or by some other means. Unless they're in self defense. But when the swords are spelled to cut through enemy enchantments, why wouldn't you use them?
Pretty much all the Wardens in The Dresden Files qualify, and use both magic and melee to devastating effect. And, uh, revolvers, semiautomatics, the occasional shotgun, a grenade or two (Ramirez versus vampires) and even, on one remarkable occasion, a nuke.
A one-trick wizard who could call up hordes of mooks also carried a web of concussion grenades.
Harry himself qualifies, showing himself to be more than capable with a sword as well as his favoured 'Dirty Harry Special' revolver.
Both Lloyd Slate and Fix have shown to have excellent swordsmanship skills, in addition to the Winter and Summer magic they have at their command, making them literalMagic Knights. As of Changes, Harry is one as well.
Serroi, of Jo Clayton's Duel Of Sorcery and Dancer trilogies, develops a rather powerful innate magical ability over the course of the first series, but never seems to lose her formidable (especially considering she's tiny) martial skills. (In the hands of an author less skilled than Clayton, Serroi would probably have been a God-Mode Sue.)
The Elric Saga: Elric of Melnibone. An Albino Wizard whose sword is cursed, giving him part of the Life Energy of the people he kills. He's specifically too weak to use most of the magic he knows, but after killing dozens of men in combat and feeding on their souls that can change. BTW he's the hero.
It's easy to forget because Stormbringer is so iconic, but Elric is actually a competent (if not necessarily superhuman) swordsman and highly skilled wizard even without the runeblade so long as he stays properly medicated. It's only when he has access to neither his sword nor the right drugs that his condition becomes a problem.
Eyes of Silver, by Michael Stackpole, has two versions: the Church holds any use of magic on living things to be heresy, so there are battle-priests who enchant their weapons and armor and airship-borne aetherines with enchanted wings to let them fly. The Ataraxian heretics, on the other hand, believe that God forbids the use of magic on anything but the living, and consequently each have a distinct form of magical combat power ranging from increased strength to teleportation.
Jack Swift of The Heir Chronicles was born a wizard but, lacking a weirstone, was implanted with that of a warrior. As a result he has the physical prowess and other tricks of the warrior guild but can still manage certain low-level charms.
Almost all Heralds, and many of the Tayledras, in Mercedes Lackey's Heralds of Valdemar series are skilled in both magic (and/or Mind-Magic) and physical combat. While the more powerful mages tend to rely much more on their magic than they do on their physical skills, a good many of them still maintain and make use of those skills, and all Heralds up to and including the royal family are expected to develop as much combat ability as they can. In particular, every one of them is required to be a competent archer.
Similarly, in her Tales of the Five Hundred Kingdoms, Champions are physical fighters who have just enough magic to enhance their weapons and/or armor, making them capable of fighting magical foes.
Many of the Griffons were this, being already powerful physically, but also capable of magic.
For a woman who was mage or warrior, the Sword Need could provide this, making mages into deadly warriors, or providing immunity to magic for warriors.
Shades, Elves, and Dragon Riders tend to specialize this way in the Inheritance Cycle. Magic and swordplay are often listed as "the essential skills of a Dragon Rider."
In Nick Perumov's Keeper of the Swords series, there is an order of Battle Mages, who are strong magically, but also can fight with regular weapons, or with magically augmented weapons. One member of it, Klara Huemmel, "Preferred to rely on steel rather than magic. And she outlived many who had different preferences."
Also young Sylvia, who is not very strong, but quite skilled with weapons. She also gets a big magic sword for most of series.
Gandalf from The Lord of the Rings (the movies in particular) is skilled at swinging a sword (and carries a glowing Elvish longsword, Glamdring) along with his Magic Staff and actual magic abilities.
Finrod (Galadriel's brother from The Silmarillion) too. A warrior who died killing a venomous werewolf with his bare hands, he also fought Sauron in a magical singing duel. He was the most powerful known telepath among all elves, ever.
Anomander Rake from the Malazan Book of the Fallen series by Steven Erikson is not only the Archmage of his 10,000+ kin the Tiste Andii, but also the only living man with both the skill and resolve to wield the Elder-God-forged sword Dragnipur. He also holds the rank of seventh following an afternoon stroll, uninvited, down the main street of a nation where social status/rank is determined by martial proficiency (normally involving duels to the death). Did I mention he only magically left the nation to slow down his heart rate from all the fighting, and in the first book of the series fends off four+ High Mages singlehandedly?
The Aurënfaie from the Nightrunner series, being the resident flavor of elves, produce a fair number of these due to the ease with which their race can develop magical ability. However, most such Fighter/Sorcerers or Ranger/Sorcerers do not have the range or scope of power possessed by those who devote themselves more exclusively to magical pursuits. Orëska wizards and the Rhui'auros attain greater magical powers, but are usually pretty squishy.
The Abhorsens in the Old Kingdom series, also the Royal Guard, and possibly the Clayr Librarians. Pretty much any magic user in fact: even the Ancelstierran's NPRD hedge-mages scrape together some basic enchanted weapons to complement their even more basic spellcasting.
Lyra from Passing Through is both a skilled swordswoman and a powerful spellcaster. At first glance she is usually taken for some minor Lordling's elite guard or messenger, as her beauty and refinement set her apart from most mere footsoldiers. In battle, she's more than willing to take on most single opponents with her blade, reserving her magic for diversions, last-minute saves, and for when she is confronted with multiple foes at once. Her offensive spells are mainly limited to various forms of lightning discharges (which works great against foes with metal armor).
Crow is capable of low-level combat-related sunstone magic (Red Rays of Destruction) and is deadly with the throwing knife.
The Warrior Druids from Shannara, as exemplified by Risca in First King of Shannara. Unlike the rest of the Druids, they channel their magic through their weapons for exceptionally destructive results.
The Stormlight Archive, has the Knights Radiant in the backstory, as well as Szeth son son Vallano, although he's more of a magic ninja. Also Kaladin is a Magic Knight in training as of the end of the first book.
Brandon Sanderson's magic systems in general lend themselves to Magic Knights, as most of them can be used to enhance the wielder's body in some way (no Squishy Wizards here!). The only real exceptions are Awakeners from Warbreaker (powerful Awakeners, though they live a long time and don't get sick, aren't neccessarily any tougher than ordinary people; Vasher could still fit the definition, being very good at Awakening and handy with a sword) and Soulcasters from Way of Kings (since their power is focused on changing things on a elemental level, and things removed from the base elements are harder and harder to create).
Richard of the Sword of Truth series qualifies in later books; though he never quite gets a handle on just how to use his magic, he's still able to use it to devastating effect, and he's an almost unbeatable swordsman, partially thanks to magic.
D'Hara tries to avert this with the Lord Rahl. He's the magic against magic, they're the steel against steel. Some Lords Rahl don't like rules.
Mord-Sith. They're anti-magic knights. With a magic torture stick.
A Confessor in the Con Dar is this. And creepy as all getup.
Nathan Rahl wears a sword through much of the series. Many of his friends ask him why he needs a sword when he's a hilariously-powerful wizard. Then the Pristinely Ungifted show up. The Pristinely Ungifted aren't even immune to magic, they have no connection to it whatsoever. To them, magic might as well not exist except when it does something like hold someone off the ground (where they see the person in the air even if they don't understand) and some poorly-defined subset of Subtractive Magic, which they have some connection to because they're mortal.
In Jennifer Roberson's Tiger and Del series, Delilah begins as this (though her frost-based magical abilities, as channeled through her sword, are limited in the Southron heat) and Tiger becomes this (after having begun the series as an expert and widely-feared sword-dancer).
The Tortall Universe has multiple Gifted knights who are trained in magic alongside the usual knight skills. Some notable examples are Alanna, who has both healing and destructive magic, Jonathan, and Duke Gareth. A few of Kel's yearmates from Protector of the Small also grow up to be this.
In Valentin Ivashchenko's Warrior and Mage and Dancing Flame (Воин и маг, Танцующее Пламя, Валентин Иващенко):
Male mages born into noble families learn magic by the imperial decree, and aquire decent melee skills due to common requirements for boys in noble families, e.g. Yan and Valle. Depending on species, family, country and culture, this may also include noble girls.
Mages born from commoners may choose a military career as an effective but appropriately risky way to fame, fortune and possibly nobility. Those willing to become front-line mages receive excessive soldier training to yield valuable combat specialists for the army.
Those willing to trade their future and their very possibility to bear children for revenge can become "night huntresses", gaining both magic and combat skill from a possible Deal with the Devil. As a part of his quest to prove that Dark Is Not Evil, Valle makes a habit to find, hire or pardon and redeem them.
Oleg aquires decent melee skills as part of his apprentice studies under Ayrung, who also strives to fit this trope.
Urgh (goblin) shamans are well-versed in combat and use various amulets and enchanted items in battle. With training, they can use lesser Ritual Magic or SummoningRituals on the battlefield to devastating effect.
Necromancers of Nekrond are proficient with their signature sickles in melee, partially due to pure necromancy being Ritual Magic. They might open combat with lesser Black Magic spells or trigger summoning artifacts to compensate.
Rand al'Thor in The Wheel of Time qualifies. Not only is he an accomplished swordsman (being able to hold his own, and later completely on his own, against people who are considered swordmasters), but also extremely powerful magically. Later on, all of the Asha'man go down the same route.
Heck, Rand goes even further, creating a magic sword made of fire in many instances, bringing new meaning to the word "Spellsword"
This particular bit of work was openly mocked by one of the Forsaken who pointed out that conjuring a sword from the air was possibly the weakest and most inconvenient way in which Rand could use his enormous power to inflict damage.
By Series 3, Merlin seems to use sword and sorcery equally well together to take down his enemies. It's likely he picked up fighting techniques purely in self-defense from a combination of always being attacked and Arthur's insistence upon using Merlin as a sparring partner (or practice dummy).
Morgana knew how to use a sword effectively before she ever discovered that she had magic.
Morgause is a witch and also a very skilled swordswoman.
Mystic Force has Koragg the Knight Wolf (Wolzard's counterpart) and the Sixth Ranger, Solaris Knight. (The Rangers themselves fit the trope, but these two have the name to go with it.) It goes into what a Knight is (in this universe), treating it as a rank above Ranger. Chip/Yellow aspires to reach it, though we don't know if he ever does (blame Nick/Red being a Spotlight-Stealing Squad of one.) Later series go on to refer to all the Sixth Ranger types who are more heavily armored than a Ranger as "Knights," such as the Sentinel Knight from Power Rangers Operation Overdrive, who has apparently been combining Zordon-level magic with hands-on asskicking for over 250 million years. Baddies break out evil robots or Make My Monster Grow? No problem, he'll turn himself giant at will.
Not a class as such, but the spell "Tenser's transformation", which has occurred in several forms over several editions, allows a prepared wizard to simply swap out his caster levels for martial training for a few hours or minutes. Various other systems have magical effects that allow rewriting one's personal history temporarily to the same effect.
Both the original and second edition AD&D games took things so far as to allow for triple-class options, notably for half-elves who could take take Cleric/Fighter/Magic-User(!), albeit with level limits.
The Eldritch Knight was the original Magic Knight Prestige Class, but later editions introduced base classes such as the Hexblade and Duskblade, other Prestige Classes such as the elven Bladesinger and even base class variants such as the Battle Sorcerer. The fighter-mage archetype has come to be nicknamed "Gish" in the Dungeons and Dragons community, after the Githyanki term for multiclass fighter-mages, and is now a popular colloquial term for any character build that incorporates both magical and melee prowess.
The Swordsage from D&D 3.5 supplement Tome of Battle is a somewhat less classic example in that they don't use the game's standard magic system but in lieu of their martial skills they have two schools worth of magical abilities giving a very seamless mix of sword and sorcery.
The Duskblade bears special mention for being the most "nearly-perfect" of any of the examples given, (coming in at the end of the edition after the writers had more practice helped). They have full BAB like a Fighter, while still being able to cast a number of blasting spells. They can even channel their spells through a weapon strike to do both in one turn.
On the divine magic side of the spectrum, we have the Paladin, and even the Cleric itself, which can keep up with (and surpass, in some cases) dedicated fighters in close combat if built correctly.
Elven Clerics, with their proficiency in Composite Long Bows and a splatbook elf-only domain, surpass nearly every other class in (physical) ranged combat.
Complete Arcana introduced the War Mage, who is allowed to cast spells and wear up to medium armor without the percent chance that spells would fail.
Complete Arcana also introduces the Spellsword prestige class. By sacrificing one level to fighter (or another martial based class), you could get all the nuke spells as well as a -30% to your spellcasting failure chance while wearing any armor. With the right enchantments on your armor, you could wear full plate armor and holding a heavy steel shield and have a 0% chance of spellcasting failure.
The Psionics Handbook (a 3.0 supplement) introduced us to the psychic warrior. Part psion (wielding magic of the mind) and part fighter, the psychic warrior's list of available psionic powers is full of things that boost one's combat prowess.
Races of Stone had Dwarf Runemages who used a form of runic magic allowing them to cast magic in full plate-armor with no penalty.
In the Basic/Expert/Companion/Master non-AD&D branch of D&D, Elves were treated as a fighter-mage class.
In AD&D2, Bards could also qualify, though they were more of a Jack class. Of course, Complete-s added not only Bard variants, but Bladesinger, War Wizard, Amazon Sorceress, Militant Wizard...
Dragonlance gives us an interesting situation. There's a semi-religious organization of Wizards of High Sorcery that actually try to avert this trope. They've made all sorts of laws and social stigma against a wizard wearing armor or carrying martial weapons. Wizards who do so anyway are looked down upon, such as...
Forgotten Realms got mentions of elven spell-archers and bladesingers from early on, and of course in elf-related sourcebooks such references are mandatory.
Maztica has two magical traditions — feathermagic and talonmagic. Accordingly, there are two magic-using, shapeshifting military orders: Eagle Knights and Jaguar Knights, with respective kits note effectively proto- Prestige Classes, since up to 5-6 level apprentices are only "proving themselves" without extra-special training.
Al Qadim has Mystics of Nog — hermit battle-monk wizards.
Pathfinder introduced the Magus, which is probably the purest example of a Magic Knight base class. It focuses on Full-Contact Magic, Dual Wielding spell and weapon, and channeling spells through their weapon, allowing them to both invoke certain magical traits in their weapon and to cast "touch range" spells through their weapon. Arguably its only flaw is that its spellcasting ability maxes out at 6th level spells.
Before that, the Wizard Of The Spiral Tower paragon path let Wizards use swords and could (with some multiclassing) make an effective "gish" class.
The divine healer Magic Knights in 4th Edition are Clerics (who specialize more in healing) and the Paladins (who specialize more in tanking). Additionally the Runepriest, a Magic Knight focused on buffs, was introduced in the third Player's Handbook as another option for divine characters.
And now with the Hybrid classes, it's possible to make a combination of Fighter/Wizard, Paladin/Sorcerer or even a Swordmage/Wizard.
In yet another expansion on available classes, we're introduced to the Hexblades, Warlocks whose pacts carry decidedly front-line ability sets, but who still retain the class' significant damage potential and continual damage buildup over the course of each battle.
The mother franchise Warhammer Fantasy Battles can proudly boast a few as well. It gives us Warrior Priests, many Vampires, Chaos Lords of Tzeench, regular Chaos Sorcerors (especially those of Tzeentch) in .
The Elves have Loremasters who are Elf mages, who are so Badass, they can wield both a sword, and cast spells in battle.
In Exalted, all Exalted player characters are like this to some degree. It's one of the many benefits of playing demigods (often mightier than a lot of actual gods) in a world that runs on Rule of Cool. All Exalted have charms and can use sorcery, while each kind specializes in specific types of magic and ass-kicking: Sidereals are the best martial artists (in a world where martial arts are themselves magical and can, for example, detrimentally rearrange the fate of an opponent), Lunars can shapeshift into bestial killing machines, Dragon-Blooded were designed to be the ultimate soldiers, and Solars and Abyssals are generally the pinnacle of good old weaponized ass-kicking. Exalted have classes called castes or aspects, but all castes include both fighting and magic.
Many Solar charms are actually a matter of enhancing weapons and archery with magic. Solars are also the best sorcerers, while Abyssals have equally powerful Necromancy.
Even heroic mortals and god-blooded can learn minor magic called Thaumaturgy, and can be initiated into the most basic supernatural martial arts. Mortals have no caste restrictions at all.
Meanwhile Dragon King characters, on top of being dinosaurs with opposable thumbs, can use both martial arts and Thaumaturgy, and get their own magic Paths as well.
Infernal Exalts tend to be the most blatant about it. The Malfeas charmset, for example, includes both "create a spear and use that to stab people" and "use that spear to shoot radiation lasers" powers. Averted with SWLIHN Charms, however, which tend to rely heavily on grabbing reality by the neck with your mind and shaking until it does what you want.
Fantasy Craft features the Rune Knight expert class that is exactly this. However, even a base Mage in Fantasy Craft is fully capable of wearing plate armor, wielding a two-handed sword, and being proficient in it.
GURPS, being a classless, skills-based system, allows for a character to very easily fit this mold from character creation, and in higher magic worlds this WILL be much more common.
In addition the Holy Warrior template from Dungeon Fantasy fits a Paladin type. Latter supplements explain how to mix and match any of the various professions, inevitably resulting in multiple kinds of Magic Knight, as well as many other character.
The Mystic Knight template, introduced in Pyramid, is a dedicated Magic Knight template using Imbuements (magic channeled through weapons and armor). It excels as either a heavy armor wearing tank with magically-empowered attacks, or as a lightly armored highly mobile artillery monster (fire one arrow, watch it multiply into 20heat-seekingexplodinglightningarrows). In both cases, the Mystic Knight's magical abilities are limited to attack and defense, with no utility functions at all.
The new version of the Iron Kingdoms RPG features a dual-career system - meaning you take two classes when you make the character instead of the industry tradition of just one. And since armour does nothing to spellcasting in the setting (as the numerous warcaster, warlocks and other spellcasting units in the wargames show) this means that you can combine Arcanist with Knight and have a sword-wielding spellslinger in full-plate.
In Legend of the Five Rings, the system explicitly forbids this to a degree-while a shugenja (caster) can learn martial skills and be quite effective in combat, they can't gain the School Techniques that make actual bushi much more powerful fighters, and shugenja are explictly forbidden from learning bushi techniques. The only exception is the Kuni Witch Hunters, an offshoot of the Kuni Shugenja school which uses quasi-magical powers to detect and destroy evil.
You're forgetting the Dragon Clan's Tamori Shugenja School. Tamori shugenja are fully trained in kenjutsu, carry katana as well as wakizashi, and their special school technique gives them some bonuses in standard skirmish combat. They're no match for a proper bushi, still, but they're no pushovers.
Both Mage: The Ascension and its Spiritual SuccessorMage: The Awakening have variants; as the more flashy, combat-intensive magic tends to ping the Weirdness Censor, it's usual that most mages will learn how to work a knife, sword, or gun, or at least take a kung-fu class at the Y. But there are mages dedicated mainly to the balance. Mage: The Ascension has the Akashic Brotherhood, an order that balances mental magic with martial arts, whereas Mage: The Awakening has the Adamantine Arrow, an order of soldiers dedicated to mastering both martial and mystical combat.
Generally speaking, the requirement that spells be more or less subtle and the unofficial theme of mage being "be prepared", plus their ability to beg, borrow, steal, craft, or conjure basically whatever they want without interference from the mundane law, a mage stepping into a potential conflict with merely a full suit of ceramic armor and an automatic weapon behind his magical defenses is almost unheard of. They tend to keep their shield spells up and some kevlar under their shirt even when they're going out for coffee, paranoia comes naturally when the entire universe is trying to kill or corrupt you.
In Rifts there are a number of classes of this type, most notably Mystic Knights and Psi-Warriors.
Notwithstanding the earlier SNES adaptation, Shadowrun's blend of cyberpunk and magic meant that it's entirely feasible for the mage of the party to carry around a machinegun while wearing heavy armour. Granted, trying anything 'cyber-' with a mage tended to make him less mage-like in a game mechanics sense.
Mystic Adepts in the latest edition combines more traditional spellcasting of the Mage and the more Ki-like magic-boost of the (traditionally more physical combat focused) Adept.
You could theoretically build a thoroughly cybered-up character who was still a fully effective mage through the use of geasa, creating a character that is simultaneously bulletproof, possesses superhuman strength and speed, and can blow up a car with a thought.
But you don't even need cybers to make a good Magic Knight; many shaman builds can match front-line street samurai with a combination of buffs and a good gun, then exceed them with street spirit summons and direct damage magic.
Mage heroes in Warhammer Fantasy tend towards this due to their relatively good statline and magic item budget. Special mention, however, must go to the plate-armored Sorcerers of Chaos, the Dragon Mages of the three elven armies, and the Vampire Counts of Sylvania.
Dark Magician Knight is another example, basically a Warrior-type effect monster of the Dark Magician that requires tributing the Dark Magician through Knight's Title before it can be summoned to the field.
It should be noted that in any series that allows multi-classing (such as the later editions of Dungeons & Dragons), it is possible to create characters of this type, though their effectiveness may vary. (A common complaint about the multiclassing rules of D&D's third edition was how they "hosed" multiclassed primary casters if you didn't also take a suitable prestige class to fix things — a result of Linear Warriors, Quadratic Wizards and spellcasters' power depending solely on their class level.)
This is probably why Prestige Classes were created in the first place. Considering that many in the core books are just zero frills combinations and all.
Ponies and Parasprites has non-canon, Exalted-style Celestial Templates. Characters have to already be pretty beefy to qualify for one of the eight available Templates to begin with. When they actually acquire a template, they gain access to summoned armor or pieces of armor based on their Alicorn patron as well as a variety of useful spells and abilities.
Arcanum: Of Steamworks & Magick Obscura allows the player to develop such a character; it's a pretty good build, as no penalties come from wearing heavy armor if you don't get encumbered by it (and your strength should be high anyways in this build).
Allanak's templars in Armageddon Mud are both trained to fight and receive magic from their Highlord. It elevates them far beyond the power of any normal man.
The very popular and very broken Kensai/Mage class combo in Baldur's Gate, utilizing the unmatched raw damage of the Kensai and the broken protection magic and haste buff of the Mage. There are other Magic Knight class combos, but this is by far the most popular one.
In the original Bard's Tale series, the third game's midway point would let you sacrifice a physical character's special abilities (some of the warrior's extra attacks, the paladin's saving throws, the rogue's special abilities, the bard's songs, the monk's unarmed/unarmored bonuses) to make that character a geomancer, a fighter with a repertoire of earth-themed spells and the ability to equip anything a warrior or an archmage could equip.
The player has shades of this in both BioShock games. In addition to your standard array of FPS guns, you also have access to magic-like powers known as Plasmids. There's also the Drill Specialist ability in BioShock 2, which greatly reduces Plasmid cost but limits you to the drill. Lastly, the Big Sister NPCs use Plasmid powers as well as quick melee attacks to rip you apart.
Final Fantasy spin-off Bravely Default uses a job system based on Final Fantasy V with every character having access to the command of one other class besides the one they're using, so they can effectively make a paladin by giving the White Magic command to the Knight or similar, though some combinations might not have the stats to use one of the commands effectively. There's also equipment that can be used as items with no cost to cast magic spells that any class can use, so even without a magic Command they'd be able to cast the spells their equipment is imbued with. In addition, several classes fit the description on their own:
Spell Fencer is a sword favoring Physical Attacker that can imbue their weapon, preferably a sword, with magic, either an element or a Standard Status Effect. Since this job's Sword Magic Command is based on Physical attack, it's the one that works best when trying to make Magic Knights out of other classes.
Ciggma Khint, the Spell Fencer you have to defeat to get the job from, even has a name which is an anagram of "Magic Knight".
The Red Mage can use Black AND White magic as their command. But their weapon proficiency is higher with swords and they're generally a Jack of All Stats.
The Templar is a tankier Knight class with the same proficiency for swords, shields and heavy armor as well as a basic command of a stronger attack (though it works differently). As it levels up, it learns Light Magic attacks and very useful support spells like Rampart.
The Dark Knight ups the Knight/Templar's armor proficiency by adding a preference for helmets over hats, and can use Katanas just as well as they use Swords. But they immediately have access to Dark Magic attacks that Cast from Hit Points making them a Glass Cannon depending on how you use them.
Finally, the Vampire class, which has Power Copying abilities like the classic Blue Mage. Though their magic stats are higher, they can use Swords, and you can choose whether you prefer them as physical attackers or spell-casters. This is important as a lot of the magic gained from enemies runs off the physical stat that the Vampire is naturally weaker in. They also have more classic vampire abilities letting them drain their opponents of blood to restore HP, or Mana to restore MP.
The Freelancer class starts off as a Jack of All Stats and ends up a Lightning Bruiser through Magikarp power, and eventually has a the perfect stats to be a Magic Knight.
Theres a few people from the Breath of Fire series that could count, such as Momo and Ryu (As something of a paladin) from 3.
The main knight characters from Castle Crashers also qualify, being able to use elemental attacks in addition to their arsenal of weapons. Especially true if you upgrade your magic and melee attacks at an equal pace.
Older RPG-style adventure games can take elements from this, too. Castle of the Winds, for example, lets you clank around in heavy plate armour, swing a two-handed sword... and when you meet a dragon, chuck a ball of lightning at it.
Though he mainly uses melee weapons, Alucard from Symphony of the Night also has a number of moderately powerful spells at his disposal. All you need is sufficient Mana to cast it if you know the combo/sequence.
Chrono Cross characters have to make physical attacks before they can use their spells, and they can all cast spells, making everyone a Magic Knight.
Crono from Chrono Trigger can both slice enemies with his katana and zap them with powerful lightning magic, which includes the almighty Luminaire spell. Frog is more of the 'paladin' type with healing spells, but (being an amphibian) also learns a few water-elemental attack spells.
From the same game, Magus, despite being an awesome magician, is a hell of a physical beefcake as well, dealing out a lot of damage with his scythes and generally having some of the highest stats in the game, be it physical OR magical. He IS an optional character, however. The only field he's lacking in when it comes to combining techs, as he's only capable of being part of two unlockable Triple Techs.
Dark Messiah actively encourages builds like these, since pure fighters and pure mages both have weaknesses early on which can be cheaply addressed by putting a few points into magic (to keep a fighter healed up) or combat (for when a mage is out of mana).
This is extremely common in Dark Souls because of classes being nothing more than starting status. Some weapon upgrade paths even allow you to base weapon damage off intelligence or faith instead of strength and dexterity. Pyromancy in particular is practically made for this. It doesn't have any stat requirements, and damage increases simply by upgrading the Pyromancy Catalyst. There isn't a single build in the game that doesn't benefit from having some pyromancy available because it doesn't have a downside like increasing your soul level.
Much of the same applies to the sequel Dark Souls II. Pyromancy was slightly nerfed since this time its effectiveness relies on stats as well as the catalyst. On the enemy side of things, Velstadt the Royal Aegis and his former comrade Raime the Fume Knight are both armored behemoths armed with huge weapons who use magic when the tide of battle turns against them. Velstadt, a noble knight tainted by Dark, will buff himself with Dark power and blast you with hexes after losing half of his health. Raime became enamored with what was left of a Child of Dark, Nadalia the Bride of Ash, and infused his greatsword with a fragment of her soul. When he loses half of his health, he buffs his sword with dark flames and starts launching fireballs.
Diablo 2 has a few classes of this type. The Paladin (who can use both defensive and offensive magical auras) and the Assassin (with her magical martial arts) are the closest fits. The Druid can specialize in either magic or physical combat (with his shapeshifting tree), but doesn't really count since it's hard for him to do both at once.
The Monk class from Hellfire, the unofficial expansion for the original Diablo. In the original game, the starting class mostly just affected the starting stats and character art, so it was possible to build any class into at least a partial spell caster by spending your level-ups right.
Not really, since every class had a limit on certain stats.
The Necromancer's skills allow for a 'Meleemancer' build, which relies on primarily on curses to allow the Necro to cherrytap monsters to death without much risk.
Do not forget the sorceress herself, being fully capable of holding two handed weapons and heavy armor given enough strength◊, and with the enchantment spell and some specialisation talentpoints can surpass any other class in single hit melee damage.
The Magic Knight class in the Disgaea series. They were actually the best spellcasters in Disgaea 2, capable of both outdamaging and outlasting the others.
Mao from Disgaea 3 has equal base stats and aptitudes in strength and intellect, and is also proficient with a variety of melee weapons and learns ice magic normally.
In Dragon Age: Origins, there is a specialization of the basic Mage class called "Arcane Warrior" that fits this trope perfectly. It allows the character to both cast spells and melee people to death, all while wearing heavy armor. A proper Arcane Warrior build is actually more durable than anyone else in the game, being able to solo dragons. They win simply by outlasting their enemies. Though, thanks to the game's skill system not being adapted for true cross-class characters, they are powerful, but somewhat less effective than the usual examples of this trope.
Two of the Warrior specializations, Templars (Anti Magic Knights) and Reavers (Warriors empowered by Dragon's blood) also fit the bill. The Awakening expansion introduces the "Spirit Warrior" (Warrior that taps into the Fade itself) specialization of the Warrior class. Needless to say, all three specializations can be stacked with each other.
In Dragon Age II, Templars and Reavers return, but Arcane Warriors do not. This is because all Mages have improved melee abilities: all staves are blades on a stick, which greatly improves close combat, and Rock Armor is stronger and an entry-level spell, meaning there's no reason not to take it regardless of build. In-universe, the Arcane Warrior style was completely forgotten until the first game's hero found an ancient Soul Jar, so the average Kirkwall mage doesn't know it even exists.
In Dragon Age II Hawke's father, Malcolm taught himself how to use a sword to better hide his magic. He passed these skills on Carver and non-mage Hawke.
For starters, the hero in most games. They could use a balance of healing and offensive magic, usually being fire-based, although heroes are usually the only characters in the game that can use the stronger lightning-based magic. Heroes are also capable of using the strongest weapons and armor in the game. This originates from the very first game, where the Hero was the only playable character, and as such needed to be able to do everything.
Dragon Quest II featured an exception: the prince of Cannock was a magic knight, while the hero was more of a Lightning Bruiser and was the only party member who had no magic at all.
The sage class in Dragon Quest III. Also to a lesser extent, the pilgrim/cleric class.
Kiryl/Cristo and Meena/Nara from Dragon Quest IV are modeled after the third game's cleric class, and could use both healing magic and had access to a handful of strong equipment. Kiryl was focused more on healing magic, while Meena had more offensive magic.
Dragon Quest VI had a Magic Knight class which could be accessed after gaining levels in the Soldier and Wizard classes. The Hero class from that game also qualified as both this and Jack-of-All-Trades.
The ranger and paladin in Dragon Quest VII. This game was also an interesting case as equipment choices were based on the character, rather than their class.
The Mystic Knight hybrid class of Dragon's Dogma is capable of using Magick Shields, granting him/her the ability to cast performance enhancing buffs, static combat spells, and elementally based counter-attacks. Magick Archers present another hybrid option suited towards those who want a mix of combat finesse and magical attacks.
Dungeon Siege uses a classless system; as a result fighter-mage builds are very easy to develop.
The expansion to the sequel lets you mix melee and nature magic to become a Fist of Stone, or ranged and combat magic to become a Blood Assassin.
Ness from EarthBound. As his party specializes in PSI powers or items, Ness qualifies as its definitive tank. To say nothing of the fact that after Magicant and the destruction of Ness' Nightmare, he gets a significant boost in power anyway, making his stats much higher than anyone else in your party.
Ninten in the prequel. Of course, his tank status is not as pronounced because of Teddy and a leveled up Pippi, but considering that Pippi never fights directly alongside your party again after you talk to the Podunk mayor and Teddy can be lost permanently to heavy injuries fighting off a powerful robot, and has to be if you haven't reactivated EVE before getting him to join you, so he's not around for long, he can take the most punishment for most of the game.
Lucas in Mother 3 is basically this. He is The Medic, and has lots of defensive stuff and is the only character who can buff parties, but at the end of the day, he generally has the highest damage output by just attacking. He is quite slow, which makes it so that you can't rely on him to save your characters from getting KO'ed.
The Elder Scrolls series has a few of these classes available as standard, such as the Battlemage. The nature of the custom skill system means that the player can create their own classes fitting this basic template.
Healers, Sorcerers, and Pilgrims also have elements of this.
Rather confusingly, the series has three separate sorts of Battlemages - the Battlemage class (seen, for example, in the Imperial Legion Battlemages in Oblivion), which is this trope, the Imperial Legion Battlemages organisation who are the official corps of magic-users in the Legion, and the Imperial Battlemage position, who can be, but more often isn't, a Magic Knight, and is more like the Chancellor to the Emperor.
There is also a archetype that is more sword, less spell: the "Spellsword". The more mundane martial prowess is their mainstay, supplemented by magic.
The Dragonborn in Skyrim is another example of this, as even a starting character has some basic magic skills, and mixing magic and melee/archery is a good combination regardless. The Dragonborn also has access to the Thu'um, which are reality warping shouts in the dragon language and one of the more potent tools at the Dragonborn's command, so even a Dragonborn who isn't using any traditional spells will likely still be using magic in some form.
All of the Thalmor forces seen in the game (with the exception of their archers) use magic in combat. Even their basic soldiers summon bound swords and use flame magic. They aren't exactly squishy either since they wear full suits of elven armor.
Skyrim doesn't just make this possible — it very actively encourages it, to the point it's extremely impractical to play as a pure mage with no weapon use at all.
Etrian Odyssey II: Heroes of Lagaard has the War Magus, described in-game as a hybrid of The Medic and the Landsknecht. Their War Lore gives them access to healing spells and buffs, while their War Edge lets them learn specialized sword slashes which have extra effects on enemies under certain status effects... including Cursecut, which can be combined with their unique Transfer skill to become a bit of a Game Breaker when used properly.
In Fable you can become this, and be named a "Spellwarrior", which, according to Yahtzee, "felt like the game was calling me an indecisive prick"
Depending on how you play it, this can be a very effective build. Good spells to use with this build include Multi Strike, Slow Time, and Assassin Rush.
Most of the Servants in Fate/stay night have such capability, between their physical combat prowess, magical weaponry, and varying ranges of actual sorcerous ability. Notable exceptions are melee-only Berserker, magic-only Caster, and Badass Normal Assassin.
Fate Nuovo Guerra features Celestina Barbieri, who uses her wind magecraft to boost her sword's effectiveness, along with reinforcing her body. There's also Kosviel von Einzbern, who uses her family's alchemic expertise to craft superior bladed weapons for her personal use.
Though Servents uses mana to strengthen themselves (though mana is more like an energy source than the traditional "magic points" required to cast spells) and uses magical equipments, they would still generally be classified as fighters. Their equipments are capable of releasing magical bursts of energy but they do not cast it in the way mages do; these attacks are probably more analogous to Ki Attacks. There are exceptions, like Lancer, who knew some magic when he was alive but prefers fighting head on; being summoned as the "Lancer" class limits his magic even more.
A more straightforward example would probably be Shirou and Archer. While technically mages as well, they rely almost solely fighting head on. They don't know any magic except for one particular type, which basically stresses specialization in head on combat. In a sense, they're fighters rather mages and only use magic to bring out their weapons.
Many characters and classes from the Final Fantasy series qualify, starting with the Red Mage from the original game (and future iterations of the class in the sequels).
Final Fantasy Tactics Advance is notable for letting your characters learn abilities from any "job" they can switch to- thus giving you the ability to have a character that has both high-level physical skills and magical skills.
The Gladiator class has 'Spellblade Tech' for giving physical attacks magical properties.
The Ultima attacks could also come under this trope, as they use magic to super-charge weapon attacks.
The Red Mage class. Seriously, just read their description.
Final Fantasy Tactics A2 has a class explicitly designed for this trope; Scholars have an ability that combines mid-level magic with physical attacks. Of course, Scholar is a Nu Mou-exclusive class, and that's the physically weakest race. Also Spellblades, who enchant their swords to cause status effects.
Vikings are front-line fighters who wield powerful axes or hammers and wear the heaviest armor; they can also cast spells from the "Thunder" family as well as the unique Tsunami spell. However, their Magick stat scores tend to be pretty low.
The Knight and Ninja class changes from Final Fantasy I qualify as well, since they gain minor white and Black Magic abilities, respectively. They still focus primarily on physical attacks, though.
Future Knight and Paladin classes, such as Cecil from Final Fantasy IV, also had minor ability in magic.
Also, Edge the Ninja from Final Fantasy IV had access to a special form of black magic called Ninjutsu.
Final Fantasy V had a Mystic Knight/Sorcerer (the name depends on the translation you're using) class which had the ability to infuse his sword with magic.
Also, using the job system, it is possible to give any physical class a secondary job as a black orwhite mage. However most jobs have sufficiently low magic stats, rendering the use of magic all but useless.
Or so it seems, until you realize that your magic is boosted up to a certain level (if below) when equipping those abilities. A fully-maxed Black Magic command will make the bearer's magic stat equal to what it would be if he was a Black Mage, even in a non-magical class. But lower levels of Black Magic will not boost the character's magic as much...
And each class you "MASTER" grants its stat bonuses to your "BARE" or "FREELANCE" class
Although once magicite started showing up you could make anyone into a Magic Knight.
Final Fantasy VII had a very modular (read: Materia) system of setting up abilities. Anyone can use magic. Thus, there was nothing stopping you from loading The Big Guy down with enough magic-things to stop a truck by their sheer mass, while trying to groom the White Magician Girl to do more with the staff than focus healing through it.
The brief flashback where Sephiroth and the player are working together shows that Sephiroth, an unquestionable Master Swordsman, also totes some serious offensive magic.
Red Mages often try to be a Jack version of this, but the trope gets subverted: their physical capabilities tend to fall behind quickly. (In some games so does their magic, but that's another trope...)
Red Mages don't actually fall behind when properly equipped. They have access to the best one handed weapons in the game, better armor than most melee, and spells that augment their offenses and defenses. Their only real weak point is the below average skill levels with weapons and defense, but can negate everything except their below average accuracy with debuffs. Realistically, if you know what you are doing, a level 50+ Red Mage (without Ninja and Utsusemi spam) is effectively invincible against anything that isn't Incredibly Tough (8+ levels higher than you) designated. The reason they don't melee in most situations is because many high level enemies spam Area of Effect attacks and debuffs and it is far easier to play a full mage in parties that doesn't need to be constantly healed like melee who have no choice.
Can't forget Orlandu, Agrias, Meliadoul, and a slew of other characters that you hire/fight against. Unlike Beowulf, their powers differ a bit from regular magic...but that's a good thing because it means they don't consume MP. You can have Orlandu and Agrias use either Lightning Stab or Holy Explosion (or Night Sword in Orlandu's case) every turn, and there's little reason not to.
The generic Geomancer class fits the trope very well. They have above average across the board stats, but don't excel in any one in particular. They can equip swords but not heavy armor, and their ability Geomancy is the only skill in the game that uses both physical and magical attack power to calculate damage.
Tidus and Wakka are physical fighters capable of buffing their allies or debuffing their enemies, respectively. And if you grind enough, you can customize them into having any sort of magic you want.
It's a cinch to create a party of Magic Knights in Final Fantasy XII thanks to the License Board system. Vaan and Ashe are the ones with the stats for it, with Vaan leaning more towards the knight aspect while Ashe favors magic.
Everyone in Final Fantasy VIII is a Magic Knight, although the game takes a certain level of introspection in Seifer's case. All of his Special Attacks involve burning you with fire magic and then using his gunblade to throw some other non-descript magic at you, and he specifically hooks up with the Big Bad to enhance his magical abilities to kill his rival and protect his mother.
The Onion Knight is probably the purest example of this trope in the game, since his moveset is split perfectly between physical and magic attacks (in order to cater to his Job Class-based EX-Mode, with which he changes class to Ninja with physical attacks, and to Sage with magic attacks.).
Final Fantasy Dimensions uses a job system strongly based on the fifth game. In addition, a modified version of the spellblade ability is available to Red Mages.
Fire Emblem has a few classes fitting this trope, though comparatively they're rather rare. Although they disappeared completely after the jump to the GBA, necessitated by its handling of the Strength and Magic stats, a couple of Magic Knight classes cropped up in post-GBA games.
Gaiden: Celica (Priest -> Princess) can wield both swords and magic.
The Jugdral duology sports far more instances of this than the rest of the franchise. The Mage Knight is a mounted class appearing in both games which wields swords and the three types of nature magic. The Mage Fighter is much the same aside from being a footsoldier class, but it only appears in Genealogy (Thracia does however reuses its sprites for the dismounted Mage Knight). Being that both of these classes promote from straight Mages, they're certainly not built equal in this respect and are much more proficient at magic use. Additionally, Troubadours are capable of wielding swords and healing staves; they promote to a female-exclusive Paladin variation which can use staves in addition to swords and lances, whereas male Paladins cannot use staves. Falcon Knights, promoted Pegasus Knights, also gain the use of staves. The Master Knight class, an impossibly broken class exclusive to Leif and Raquesis, wields everything except Dark magic; before promotion, Rackesis wields both swords and staves. There are also a handful of boss-exclusive classes which can use varying combinations of magic and physical weapons, including the Baron and Emperor (everything except Light and Dark magic).
The Tellius duology reintroduced the concept on a much smaller scale, exclusive to two characters. Mist, a Cleric who promotes to Valkyrie, wields both swords and staves (whether she does so before promotion depnds on the game); unlike in past games, these classes are exclusive to her. Princess/Queen Elincia has a Falcon Knight/Seraph Knight variant class which also wields swords and staves.
Fire Emblem Awakening brings the concept back in full force: it features the Tactician class, which can be promoted to Grandmaster and is exclusive to the player-created Avatarand his/her children; the Dark Knight, a possible Mage promotion which wield both swords and magic tomes; the Dark Flier pegasus knights, who use spears and tomes; and the DLC-only Dread Fighters, capable of using swords, tomes, and axes. Also, the Thief promotion Trickster uses swords and staves, and the also-DLC-only Bride uses spears, bows, and staves.
The Geneforge has the Servile and Agent classes, capable of both high-end magic and melee combat at the expense of Shaping skills. The servile is inclined more towards physical combat and enhancement magic, while Agents tend towards battle magic.
The heroes of the Golden Sun series qualify, since everyone is capable of using offensive magicpsynergy, even 'fighter-types' like Isaac, Garret or Felix. However, Venus adepts like Isaac, Felix and Matthew are much more balanced between psynergy and physical power, while characters like Garet and Piers have very little Psynergy Points to use in battle forcing them to focus more of physical strength.
Guild Wars, with it's primary/secondary class setup, allows for countless varieties of Magic Knights, who can choose to focus on any type of spellcasting or melee fighting they choose. Essentially pick one of Warrior/Ranger/Assassin/Dervish/Paragon, and one of Monk/Elementalist/Mesmer/Necromancer/Ritualist/Paragon, and you have yourself a Magic Knight.
Hell, the Dervish and Paragon do a pretty good job being Magic Knights regardless of their secondary.
Assassins aren't exactly bad at it either. Though, it should be noted that it's generally a good idea not to try to be a Magic Knight unless you're one of those three classes anyway. Warrior/Monks are an excellent example. Sure, you could put points into healing as well as your physical attack abilities, but really you're just tearing up a perfectly good build; indeed, this specific example gets ruined so badly that there's even a specific derogatory word for them: Wammo.
Note that "Wammo" took on its derogatory tone later. In pre-release and shortly after retail, Wammos were extremely overpowered.
In Guild Wars 2, the Guardian fills this role, using holy magic, being able to use both magical and melee weapons, and having heavy armor. Thieves also have a few abilities along these lines as well, though not nearly as much as original Guild Wars assassins did.
Heroes of Might and Magic, as the name implies, allows the Heroes to specialize in either form or a mix between the two. The only exception being the Orc Warlords in V, which can't learn any spells at all.
Might and Magic has a few classes like this (exactly which depend on what game it is). Most had Paladins (Priestly-Fighters, some had Archers (Wizardly Fighters who also are Exactly What It Says on the Tin), but VIII had Dark Elves (replacing Archers) and Vampires (replacing Paladins) instead.
Sora in Kingdom Hearts is a Magic Knight, Jack of All Stats, and the most powerful playable character. In fact, most keyblade wielders are some form of Magic Knight with varying levels of knight and mage, with characters like Riku, Terra, and Eraqus specializing in swordfighting, Xehanort and Aqua prefer magic, while Sora, Roxas, Xion, Vanitas, and Ventus are somewhere in between.
Most of Organization XIII count as well, since each one has their one Weapon of Choice and Elemental Powers, though some specialize in one or the other to various degrees.
In Kingdoms of Amalur: Reckoning, a player who chooses not to focus on any of the three main skill trees of Might, Sorcery and Finesse and instead spread their skill points between two of those disciplines will develop into a hybrid class. Might/Sorcery is a tank built to withstand both physical and elemental damage, and convert a portion of it into mana. Finesse/Sorcery is more of a Fragile Speedster who's dodge maneuver is replaced with a short-range teleport that also poisons nearby enemies. Spreading skill points equally between all three disciplines unlocks the Universalist who lacks any class-specific techniques and takes longer to get access to mid- and top-tier skills, but makes up for it by being better than other classes at what they do have access to.
Want to be one of these in Kingdom of Loathing? Go ahead; just keep a different spell every time you ascend and you can use it as a non-mysticality class. Hell, everyone keeps Entangling Noodles since it's so useful (2-3 free turns of whiacking your foe).
A successful basement dive requires this, as the road to level 500 is paved with tests of endurance and magical energy, and populated with opponents immune to physical or spell damage. The post-ascension stat gains make it feasible to employ a wider range of magical knightliness.
Meta Knight has no problem summoning huge tornadoes and shooting Sword Beams in between slashing at Kirby with Galaxia. And Galacta Knight is an even more powerful Magic Knight, summoning a Storm of Blades, shooting a laser from his lance, and causing several bolts of lightning to appear. The standout example, however, is Queen Sectonia, whose fighting style includes both devastating magic and some really impressive physical attacks.
Jedi Consulars from Knights of the Old Republic are basically this. They have frikkin laser swords and magic (read: Force) powers. Consulars took a hit to feat & skill progression, but could still hold their own with the lightsaber and throw AoE force powers and buff allies. Really, all three Jedi Classes (Consular, Guardian, and Sentinel) are basically Magic Knight variants, as all Jedi have some access to the Force. Same could be said for the Sith classes, though those might fall under a Blood Magic Knight type...is there a Blood Magic Knight trope? There is now!
Langrisser II for the Sega Genesis takes this one a bit too far. ALL playable classes except Fighter and Pirate (which we can only assume is Lester's starting class) get magic, and most kind of knights end up having a good mix of buffing magic and offensive spells. However, the difference with mages is that their MP and magic power/range stay rather low and there's not much they can do about it (they can equip wands, which are not worth giving up a real weapon for, and they can't equip orbs). In fact, out of the 10 playable characters, 9 can potentially choose the actual "Magic Knight" class after their second class change.
Link from The Legend of Zelda also qualifies in certain games where he's given spells, which includes all of the Zelda games produced by Nintendo except the original and The Legend of Zelda: Twilight Princess. Though even those two Links could still use Magic Wands at least. Particularly in Zelda II: The Adventure of Link. Though a lot of the time, he's more of a gadget user, channeling raw magic into canes, medallions, and other types of magic-powered tools.
The Twilight Princess incarnation of Zelda would also qualify, to a degree. She's shown wielding a sword in a cutscene, and also has quite considerable magical power.
Also, Ganondorf is exceptional at both physical combat and magic, and actually being better than most dedicated fighters or mages. Being a giant demon pig capable of casting spells that rip open dimensions can do that. He's also skilled in two handed weapons, dual wielding, and strong enough to ruin entire islands...while having most of his power still sealed.
The main hero of Light Crusader uses a sword but can also use spells when an element is equipped on him.
The Lord of the Rings Online MMORG allows Lore-masters (otherwise you classical stuff-and-spell wizards) to wield a sword on higher levels, making them much closer to that trope. Ministrels from the same game, who use songs with magical effects along with shields, medium armor and variety of weapons, are even closer to this trope.
The highest level Lore-Masters can dual wield a sword and a staff at the same time, when using the proper optional, unlockable "legendary trait". Since a staff is supposed to be a two handed weapon, this is a bit of a Game Breaker.
More recent updates have made this an innate ability of the class, upon reaching a certain level, rather than spending a Legendary trait slot. The former trait was modified to instead buff the Lore-master's survivability and melee damage. Of course, the class is still extremely squishy — only capable of wearing Light Armour and unable to use shields — so trying to play them as a Magic Knight is high-risk, high-reward compared to playing as a more traditional mezzer/Nuker.
Luminous Arc 2 have the protagonist, Roland, becoming a Rune Knight to use one of six elemental magic in battle if the Witch he's Engaged to was deployed as well. The effects of Engagement gives Roland use of magic, give a nice boost to one of his stats and an elemental Flash Drive. The game also have Master Mattias, Bharva and late in the game, the Stinger Squad via vastly improved Runic Engines.
Luminous Arc 3 basically have an academy for Magi Knights, which Refi attends.
Alex, the protagonist of Lunar: The Silver Star, fit this bill, particularly in the Sega CD version of the game. In every version, he gains access to the extremely powerful Dragon spells, in addition to being the strongest fighter in the game (eventually outstripping even Kyle, the team's main tank). In the Sega CD version of the game, he had access to a wide variety of Fire spells, as well as Healing magic and the occasional "Kill Every Enemy on Screen" spell.
The player character, Roy Temperance, can be built this way in Mars: War Logs. He's a Technomancer, and as such has the power to control and generate electricity with the proper equipment. With points in both the Combatant and Technomancer trees, you can easily be a mostly-melee fighter who charges his weapon with electricity, protects himself with an electric shield, and attacks enemies outside melee range with lightning strikes.
In Mass Effect, biotic users are the equivalent of magic users. The Soldier class is a warrior, the Adept is a mage, and the Vanguard is a mix of the two therefore it's a Magic Knight. Also by unlocking certain achievements, the player can choose a single skill as a "bonus talent" on any class. So a soldier or infiltrator can pick up a biotic skill, or an adept might learn to wield sniper rifles or shotguns.
Shepard enjoys many magic knights among their allies. Urdnot Wrex, Jacob Taylor, Thane Krios, and Aria T'Loak are all modified Vanguards. There is also Samara, Morinth, and Javik; Adepts with the ability to use assault rifles. Jack occupies an odd middle-ground between the Vanguard and Adept classes. Among the Sentinel party members, Kaidan Alenko grew into a magic knight between games while Nyreen Kandros is one from the moment she appears.
Any asari that joins their military is required to be a magic knight.
Archers and Paladins do this for Elemental and Self magic respectively in Might and Magic 6.
7 carries over the classes, and also Rangers, who do it for both spell categories (Archers are set up as a hybrid of Knights and Sorcerors, Paladins are set up as a hybrid of Knights and Clerics, and Rangers are set up as a hybrid of Knights and Druids).
In Mitsumete Knight R: Daibouken Hen, all six main characters are basically this, with some of them more skilled at magic than physical weapons, and vice-versa. The sliding scale of the characters, from more skilled at magic, to more skilled at weapons, is the following: Sophia - Linda - MacLeod - Raizze - Lesley - Hanna.
In NetHack, the Knight class starts out as a heavily armored but weaker combat character, but has the ability to become an effective spellcaster as well, once some spells have been learned and magic-friendly armor acquired. OTOH, even the Wizard can be fairly effective at bashing things with a staff or stabbing them with a magic dagger.
Every single character in the Persona series, but specifically in Persona 3 and Persona 4 where every character specializes in a specific type of spell. The only person who can't use spells in either game is a temp character, and even then, he has magic-like skills.
The protagonists of each primary Phantasy Star game — Alis, Rolf, Chaz, and the third-generation characters of PSIII (especially Sean) — are all Magic Knights.
The games generally avert this in-universe; true Magic is something that can only be used by members of a race of psychics called Espers, with "techniques" being usable by almost anyone and generally treated as something of a martial arts trick. Kyra, being the only known Esper who can equip heavy-type armors and use a weapon that isn't a staff, fits the Magic Knight trope best.
Phantasy Star Online provides some leeway as to what character classes can equip what weapons and magic techniques (except for Androids, who can't use magic at all), but two classes stand out: the HUnewearl (a female newman Hunter) can develop better proficiency for magic than other hunter classes while maintaining full use of melee weapons, while the FOmar (a male human Force) is better apt at using melee weapons than other Force classes.
Phantasy Star Online 2 makes it easier to build Magic Knight classes: thanks to the subclass system, players can play as a Hunter or Fighter while having access to the Force and Techer's suite of magic abilities, or vice versa. However, this kind of playstyle is hard to master since only a fraction of your subclass's stats are added to your main class, leaving you with weakened magic or melee combat abilities (unless you can get your hands on a melee weapon with magic attack stats, or a magic weapon with melee attack stats). Episode 3 introduces a dedicated Magic Knight class called the Bouncer, which uses Dual Blades for melee combat and JetBoots for magic.
The Nameless One can inadvertently become one of these due to his unique leveling system and equipment selection. If you level him as a fighter, then switch to mage later, you keep all the physical stats you earned from a fighter, but you are functionally still a full mage in terms of casting.
A good number of Pokémon fall under this category. Their defensive stats and speed vary, but they can all deal decent physical and special damage and often have a large enough move pool to take advantage of both. They find their place on the team in the form of "mixed sweepers" (unless their user raises them to specialize in one offensive type or the other.) Examples of these Pokemon include Infernape, Azelf, Deoxys (particularly Deoxys-A,) Giratina in both forms, Lucario, Jirachi, and Celebi.
Generation VI brings us Aegislash, the Steel/Ghost possessed sword with stats of 150 in attack AND special attack in its attack forme.
Lagnus from Puyo Puyo is depicted as one in his attack animations. In Madou Monogatari Saturn he's a swordsman backed with a couple of light-based magic spells, one of which being a potent healing rain. In contrast, the dark wizard Schezo learned his magic first before he obtained his sword.
The Paladin from the Quest for Glory series qualifies: In Quest for Glory III earning the Heal ability automatically adds the Magic skill, enabling the Paladin to learn almost all of the spells in the game (except for the handful that being the Wizard class in mandatory for, such as Summon Staff). More mundanely, it's possible to start as a Fighter and add the Magic Skill at character creation as early as Quest for Glory I.
The Sage and the Professor/Scholar of Ragnarok Online is capable of being a Magic Knight. Unfortunately, he/she suffers from being a melee type now... (shift from attack speed to faster casting times), a Glass Cannon for his magical roots, slower casting time and luck (Auto Spell has a 25% chance of automatically casting while attacking physically).
In the Rune Factory game series, if you choose to train your combat skills and your magic skills, you can definitely become one of these, slinging deadly fireballs as easily as you beat foes into submission with your sword.
Sacred and its sequel had several characters (i.e. classes) with this sort of potential, most notably the Wood Elf in the first game, the Inquisitor in the second, and the Seraphim in both. Oddly enough, though there is a character called a Battlemage in the first game, and who claims at creation to be good at combat too, he's very squishy and is best played as a pure magic user.
The SNES version of Shadowrun had an odd variant of this. You could run around, and cast magic, and even throw a little cyberware into your flesh. Sounds fine... but the Tabletop RPG it's based on tends to have a rather strict separation between magic and cyberware — namely, the more you slap metal into you, the less able you are to toss magic missiles. This also happens in the Genesis version, where spellcasters are better off not installing any cyberware.
The xBox 360 shooter version is the same way, allowing deportation and cybercrap in the same character.
Arthur from the original Shining Force definitely fits this trope. Even though at first he's really weak, he becomes significantly stronger than almost any other knight, magic or not. At this point his magic pretty much sucks, but he's still the only useful fighter that can use magic besides the Bare-Fisted Monk.
Max, the main character, who, on top of being a good fighter, has some use in magic. Mainly it's for the "he who fights and runs away..." spell Egress, though he can cast the spell called Supernova.
Also, from Shining Force II onwards, most the main characters in the series could learn Bolt magic. The heroes in Shining Force III take it up a notch in their final promotion forms by learning the super powerful Inferno spell.
Faize Sheifa Beleth from Star Ocean The Last Hope. He casts attack symbology from the get-go, he can wear the same armor as Edge, and his weapon is a rapier. His replacement, Arumat is on the other side of the spectrum as a scythe wielding warrior with access to Earth and Fire symbols. Edge himself supplements his sword skills with low-level healing and mid-level Light symbols.
Some characters in the Suikoden series wielded swords in the front row, and were still very proficient in using rune spells.
The main character of each game is almost always an example, starting out as an excellent physical fighter and later gaining access to one of the incredibly powerful True Runes. The sole exception is Chris Lightfellow from the third game, whose magic stats are so low that she can't even use her Rune's fourth-level spell without excessive power-leveling (or farming lots of stat-increase items for her).
This isn't much of an issue if she gets the True Water Rune, since that Rune's most useful spell is first-level, and as a healing spell, isn't much affected by a low magic stat. She is therefore a very useful paladin-type Magic Knight. She makes an awful Flame Champion, though.
While it is true that Chris is a poor rune caster, giving her the True Fire rune has the side effect of granting Hugo the True Water rune. Hugo, mounted on Fubar, with access to almost unlimited healing, can solo (well, duo) the final boss. Not bad for an RPG with six (6) party slots.
The main character of Summoner, Joseph, plays this fairly straight. He's a competent swordsman and can wear decent armor, he buffs and heals very well (and slings damage magic not-quite-so-well, especially if you're playing him as a front-liner), and as the titular Summoner he can conjure spirits, golems, and other monsters of great power.
The (now defunct) online game Tabula Rasa all-but based the game on the concept, with general logos that everyone could use, and other ones related to job specialty.
Tactics Ogre: The Knight of Lodis has the Warlock. It can be unlocked by having a character gain the medal: Pen and the Sword. Valkyrie, female counterpart, can also count.
Most magic users in Tales Series have decent capacity for physical combat, though the exact degree varies.
Kratos and Zelos in Tales of Symphonia. Though they had significant stats for both, they have less techs for magic and fighting.
In the sequel, Marta starts out more of a 'white mage,' but is competent in physical combat, and later learns damaging spells as well. Possibly just because Tales' real-time combat makes a pure mage irritating to keep around, and a pure healer that can only heal one person at a time has mixed usefulness in a game where using an item doesn't cost you a 'turn.'
Everyone in Tales of Destiny 2 has physical and magical skill sets, although it was clear who was meant to be frontliners (Kyle and Loni), nukers (Reala and Harold), or do a little bit of both (Judas and Nanaly).
Raven from Tales of Vesperia qualifies, but he also has many unique abilities to compensate for his averageness.
Flynn from the PS3 port of Vesperia also applies, if possibly only slightly. He's the only character apart from Estelle who can use Light-element spells (on purpose, anyways. Patty can cast them as well but it's a random chance in her case), plus he's a very capable swordsman. He's more of the "Knight first, Mage second" type considering his physical skills outnumber his spells.
Virtually everyone in Tales of Graces qualifies to an extent. Aside from Asbel, who is a physical attacker only, every other character is capable of both casting spells and being used as a melee attacker. However, it's obvious some characters have more prowess at one or the other and Lightning Bruiser Sophie's magic is limited to healing and support artes making her more Combat Medic than magic knight. Among the party, Richard is the most textbook example of a magic knight, with his skills evenly divided between short-range melee attacks and long-range spells.
Technically, everyone in Graces is a magic knight from a meta perspective, as Assualt Arte damage is calculated using the physical attack stat, and Burst Arte damage is calculated using the magic attack stat.
Tales of the Abyss has Anise, a Squishy Wizard who rides around on a giant stuffed puppet with impressive physical skills as well as being the go-to party member for dark-elemental magic, and Jade "the Necromancer" Curtiss, who specialises in fonic artes, yet has impressive skills with a spear as well (including using a fonic arte to store his spear in the skin of his arm when he's not using it).
Abyss also has Asch who, in addition to having all of Luke's sword skills, also possesses a number of high level spells long before anyone else in your party will have access to anything that powerful. Unfortunately, his stats more closely resemble those of a pure swordsman, rendering his spells fairly useless since he lacks the magical attack power to back them up and cannot modify any of them with fields of fonons.
Tales of Xillia has Milla, Rowen, and Elise. The first leans more towards the "knight" side of the equation, her unique ability allowing her to transform her magic artes into physical artes, and having more physical artes overall. The second leans more towards the magic, his ability instead increasing its potency using button inputs, though you can alternatively forgo it in favor of much faster casting speed using a skill. The third strikes something of a balance, her unique ability allowing her to switch between enhanced magic and enhanced physical artes, and having skills that let you specialize in either regard. Her frailness tends to make the latter approach a practical option only in the hands of a player, though.
Tales of Xillia 2 adds a fourth into the equation in the form of Musee, who has an equal split between physical and magical artes, though her abilities favor the use of the latter. It also introduces a new skill for all four characters to use that increases their casting speed proportionate to how many hits they've dealt in their current combo, which can allow you to seamlessly incorporate magic artes into them once you've dealt enough hits, making for some very stylish and flashy combos.
Tales of Maj'Eyal has a ton of these. You start out with the Arcane Blade and Shadowblade, and can unlock around six others, eventually getting one Magic Knight class for every meta-class except "Mage." Temporal Wardens add Bow and Sword, in Accord to the mix for ultimate versatility.
Touhou's Youmu Konpaku. Explicitly stated to be quite good at both using her swords and magic. Things get especially hairy when she starts using both at the same time (Asura Sword, Hell God Sword, Hungry King Sword, and her Last Word...heck, all of her spellcards to some degree, even if some are supposed to be her using her swords to fling danmaku or cut bullets). Using her in the fighting games demands this of the player as well.
While certainly not knights in behavior or weapon choice, it is heavily implied that if not for the spell card rules, Hong Meiling, Ibuki Suika, Hoshiguma Yuugi, and Kazami Yuuka are just as if not more dangerous with physical attacks than magic ones.
The Druid and Paladin classes from the Ultima series - with the Druid leaning more toward magic and the Paladin more toward physical combat. (And in the later games, the "Avatar" class that only the protagonist gets.)
Actually, let's break this down by game a little. In Ultima IV, there are 8 classes, and 3 of them are entirely one or the other- Mage, Warrior, and Shepherd. The other three are all hybrids. Ultima V'' is where this trope really comes into its own, though- there are only three classes for NPCs now- Mage, Warrior, and Bard, where the Bard is a Magic Knight. Then the protagonist is of class "The Avatar", which can get as good at magic or fighting as anyone else and is The Hero.
Vagrant Story's protagonist Ashley Riot is proficient in a wide variety of weapons and fighting styles, and can teach himself spells from the Grimoires he finds over the course of the game.
Most Hero characters in Warcraft III fit into this role as their abilities usually can be used both for magical and non-magical attack.
The Shake King in Wario Land Shake It. He's physically imposing, has the same brute force based attacks as Wario, mainly for the first half of the battle... and can shoot both massive laser beams and lightning bolts all over the arena.
The main character of Warriors of Might and Magic, Alleron, is probably one, since he can use any kind of weapons, armors and shields and can still cast spells.
Wild ARMs 3 lets any of the 4 characters learn magic through equipping Guardians. However only two characters can get close to Magic Knight, Clive and Gallows. The other two,Virgina and Jet, have poor physical stats and poor magic stats respectively.
Geralt (and all witchers) from The Witcher is a lightly armored swordsman with a small array of magical abilities. He's also a bit of an engineer and an alchemist, able to make things like bombs, traps, and healing potions.
World of Warcraft is full of such hybrids. The Shaman is a Nuker / Healer who can wield hefty weapons and upgrade to mail armor, and on top of that he's a Device-type Mezzer with his Totems. The Paladin is a Healer/Tank with the most impressive and complex Mezzing ability in the game, and one of only two classes able to equip shields and plate armor. Before the expansions blurred the lines, the Shaman and the Paladin were the game's original Magic Knight classes and were nicely balanced against each other: Shamans were exclusive to the Horde and Paladins to the Alliance and both played the role of Church Militant. However, Shamans place more emphasis on spellcasting (though melee is a viable option) while Paladins are more melee-oriented.
There are also several NPCs that casts damaging spells while wearing heavy armour, or can both melee and cast spells quite well.
Druids also muck around in Magic Knight territory to a degree-they normally have to change forms in order to cast spells or tank, but a talent in their offensive spellcasting tree nets them a substantial armor boost-potentially allowing them to have warrior-level armor. That this talent also results in them turning into a giant owl-chicken-demon thing is regarded as a bonus by druids.
The Wrath of the Lich King expansion adds Death Knights, fallen warriors who augment their martial abilities with necromancy.
Thrall, Warchief of the Horde, started out as a gladiatorial warrior, but later learned shamanistic magic, which he uses in combination with his full plate armor and warhammer.
The dragon species and probably most other "higher beings." Kalecgos, a blue dragonflight, is describe as having "the powers of a sorcerer and the strength of a warrior."
Despite being considered the greatest warrior among the Titans, the current ultimate Big Bad of the Warcraft Universe is more than capable of casting extremely powerful magic.
In the novels, the mage Rhonin is also a decent enough fighter. The later novels show his hand-to-hand combat skills increasing, but his magic powers increase more rapidly, so he is not entirely 50/50.
Notable subversion: the main character of the old ZX Spectrum Magic Knight series (actually named Magic Knight) suffers greatly in the actual knight department, although she can cast lightning bolts strong enough to weld golden sundials back together in Knight Tyme.
Effectively every character after Ellia in Eternal Darkness, although how useful their spellcasting will be depends on when they appear in the storyline and how large their Mana Meter is. Main character Alex fits the mold the best, though, given she acquires every spell and her magick replenishes twice as fast as anyone else's.
In Crimson Flag most Gray Reyn can use magic, so naturally their soldiers and nobles fall under this trope. Red Reyn appear to specialize, though the queen's bodyguard Sir Bryce uses a lot of enchanted weapons.
In El Goonish Shive, Raven and Abraham are this which means their battle consisted of swordfighting and spellcasting. Halfway through the battle Abraham forgets that Raven is this and suffers for it.
Some noteworthy examples: Black Mage has taken down an entire city guard with his knives, slain an entire doomsday cult of Mindflayers after losing the element of surprise, and even blown up an iceberg by hacking at it with his knife because he'd run out of daily destruction spells.
He also solo killed all four Fiends, at once, when they'd been summoned from Hell using nothing but his knives. Then he stole their souls and gained almost as much power as he'd had when he took over Hell. The best part is that the other Light Warriors were just planning to fight without bothering to include BM.
Well, maybe not justRule of Funny. Black Mage is the Glass Cannon, yes - but that's in only in comparison to the other Light Warriors. Fighter is able to survive almost any kind of attack even before getting his class change (which allows him to block every kind of attack imaginable, even fatal falling damage), the Fiend of Fire couldn't even seriously injure him, and he can survive underwater, without air, for 20 minutes or more. Red Mage was eaten by the Fiend of Water, his last choked words that his skeleton was being pushed out through his mouth... and then cut his way out of the beast about a minute later. A similar situation occured when he was eaten by a fire dragon who refused to help the party across a river of lava, because riding on his back would prove fatal to humans. And Thief is expert enough at escaping or avoiding attacks that we rarely see his durability.
As Drowtales tend to have a more realistic approach to how magic would work, most Drow/elfkind soldiers and fighters have some degree of magic power and fighting prowess - anyone who specializes solely in either tend not to do well (exceptions exist). True "magic knights" however tend to be more experienced overall and most ranking members of an army will be a force to be reckoned with either way. As a specific example, Sarv'wati, one of the Imperial daughters of the Queen, leads the bulk of the Sharen army, is one of the most potent spellcasters in the underworld and is the only one to have defeated Quain'tana in martial combat. In an early page, a duel between the leaders of 2 different military branches quickly degenerates into a magic-heavy battle.
Rinoa in Dead Fantasy is shown to be rather handy with her melee weapons, as well as capable of summoning tornadoes and freezing lava solid.
The Black Lion, a mystic villain from the ''Global Guardians PBEM Universe, is a literal Magic Knight. Once an armored medieval knight, he is now been kept alive for nine hundred years through dark and sinister magic. In addition to his skills with a sword, he is also a powerful sorcerer in his own right.
In Mother of Learning, Zorian's friend Taiven was trained in nonmagical fighting since she was a small girl before going on to learn combat magic at the academy.
Many fighters in Nocte Yin are adept at both magic and weaponry.
In Avatar: The Last Airbender, Prince Zuko demonstrates proficiency in both Firebending and swordsmanship, allowing him to beat Jet in a swordfight where he cannot reveal his Firebending, as well as beating his own father Ozai on the Day of Black Sun. Additionally, he effortlessly wipes the floor with Sokka when the latter demanded they find out who the better swordsman was.
From Gargoyles both Demona and Macbeth count, though Macbeth is more solidly a fighter who uses magic when he has too, while Demona is a more even split between the two abilities.
The Visionaries were an entire collection of these. They all had the power to transform into their totem forms, and they also had their own individual power staffs and magical abilities, when they didn't have the power to charge and control Magitek vehicles.