Sex God

A character (male or female) possesses In-Universe extraordinary prowess in giving physical sexual pleasure to his/her partner(s). A soft caress on the cheek from such a person can leave the subject a flustered bundle of sexual excitement, a body massage under their hands would be a heavenly experience, while the luckier ones who get to bed this character would most probably be in for the most intensely multi-orgasmic night they've ever had in their lives.

The reasons behind said prowess varies. Sometimes it's simply due to knowing "how to touch them right", sometimes it's through special sex techniques, sometimes it's by knowing how to make the best out of a larger than average tool, and sometimes it might be actual Magic. The Power Perversion Potential for this ability should be very obvious, assuming that it isn't itself a result of Power Perversion Potential. This an almost mandatory part of a Horny Devil's inventory of abilities. Many pornographic works tend to depict their male characters as this; for live-action ones, this would be an Informed Ability, given that they don't actually do anything "special" on-screen.

Note: This trope is neither tied to a specific gender nor tied to a specific sexual orientation. Also, being able to do one or two "tricks" to get one's partner hit the O-zone does not qualify for this trope. The character is supposed to be (hailed as) a veritable expert in carnal delights, not a "one-trick pony".

Memetic Sex God is the Memetic Mutation counterpart of this trope, where the fandom perceives the character as being this, regardless of evidence for or against - if said evidence even exists. May serve as a justification for the attractiveness behind the Chick Magnet/Hello, Nurse!, the Pornomancer, or the Kavorka Man.

Not to be confused with an actual deity of sexual activity, though due to their particular domain, they often are Sex Gods by necessity.

Compare with the Casanova, who has high prowess/skill in seduction rather than sexual pleasure; of course, being a consistently successful Casanova would usually require being a Sex God, too.

Anime and Manga
"Woman: I can see the Gates of Heaven! Sebastian: (unamused) Oh I highly doubt that."
 * Black Butler - Because he's a demon disguised in the form his master ordered him to (a polite butler), Sebastian interrogates a cult member... very convincingly.

Fan Works
""Think of us as your own ego-busting squad," Hermione smiled. "I didn't think I needed it," Harry pointed out. "You don't," Pansy agreed. "But it's always good to be prepared. And to remind you that you are only human. Out there, you will always be Harry Potter, Boy Who Lived, Saviour, Hero, and Sex God. With us, you'll just be Harry, our friend and love." "And Sex God," Daphne added with a grin."
 * Many, if not all, Ethical Sluts, Chivalrous Perverts and Good Bad Girls are likely to have this trope applied to them, often despite Canon evidence to the contrary; even Ms. Fanservice-type and Ladette-type who exhibit none of the aforementioned tropes are still vulnerable to this via Flanderization. And for Dracos in Leather Pants and Mary Sues (especially Marty Stus) that have their sexual skills mentioned In-Universe, it's seen as a nigh-mandatory requirement.
 * Invoked for humor in chapter 8 of the Harry Potter fic White Knight, Grey Queen by Jeconais:

Film

 * In Star Trek: The Motion Picture Commander Ilia is a Deltan, who must register an Oath of Celibacy upon coming aboard the Enterprise.
 * Chevy Chase's character in Modern Problems was able to give his girlfriend sexual pleasure via telekinesis.
 * Jim Carrey's character in Bruce Almighty has all of God's powers, and telekinetically gave his girlfriend intense sexual pleasure without touching her (at first).
 * Spoofed, along with Biggus Dickus and Sex Face Turn, in Blazing Saddles.
 * In The 40-Year-Old Virgin, Steve Carell's character finally breaks his duck with an as-expected three-thrust wonder. The action then cuts to some time later after his second performance and it's clear he's astonished his more experienced new wife with "natural talent".
 * Bond. James Bond.
 * Dr. Frank N. Furter of The Rocky Horror Picture Show.
 * In What Women Want the protagonist uses his mind-reading powers while having sex to find out what she finds most pleasurable, giving her the best sex of her life.

Literature

 * In the Earth's Children series, Jondalar is portrayed like this, due in no small part to his hardware and how well it and Ayla's own fit together.
 * The Destroyer series. In one of the books it's noted that Remo can use his knowledge of Sinanju to bring any woman to orgasm by touching her pressure points in a specific order.
 * A Running Gag was that Remo never managed to complete the sequence; every woman was overwhelmed by sexual craving and leaped on him before he'd got more than about halfway through the list of points. Evidently he was doing something wrong, though it certainly didn't seem that way to the ladies.
 * Played with in the Film and TV series pilot. In the film Chiun claims to know the pressure points to bring a woman to Nirvana. When Remo asks him what they are, he shows Remo how to tap his wrist with a regular beat. Remo asks if that's the first point, Chiun says "No, that is how you know when the rice is done." and removes the rice that had been cooking off the burner. In the TV pilot, Remo tries the wrist-tapping on a woman and asks her if it does anything for her. It doesn't.
 * The female protagonist of the Jennifer Weiner novel titled, er, Good In Bed.
 * Any courtesan in Kushiel's Legacy, where the nation of Terre D'Ange reveres prostitution as a sacred act, but especially the protagonist, Phedre.
 * As a Canon Sue, Lazarus Long is one
 * The main character and his mistress in Trevanian's Shibumi are level 4 sexual adepts. The main character's favorite variant is where they sit/kneel at opposite walls of an empty room and try to make the other person orgasm first through sheer concentration. He later abandons it because of the lack of affection involved.
 * Anansi Boys - "He was part animal, part god, part unstoppable sex machine," referring to Spider who likes to party with the mortals.
 * In The Wise Man's Fear, the Fae Felurian is considered a sex goddess, leaving men as empty husks who soon die after she leaves them because they will never experience anything like it again.
 * In Dune probably every Bene Geserit would be this by default given that they can control their bodies at the cellular level, manipulate emotions, etc.
 * Daemon Sadi in the Black Jewels series, who was kept as a sex slave for several centuries despite his magical power and his incredibly lethal temper. He learned to weaponize his sexual allure and skills (e.g., pleasuring to the point of pain) so well that people began calling him "the Sadist", but that didn't prevent people from trying to bed him.

Live-Action TV

 * An episode of Seinfeld has a plot revolving around George and Puddy employing one of Jerry's "moves" for their girlfriends because it works so well.
 * Joey from Friends is sometimes portrayed as an extremely satisfying lover; so is Chandler after some coaching from Monica and Rachel when he dates one of Joey's exes.
 * At least twice in Season 4, it's suggested that Buffy's superhuman physical abilities translate to bedroom prowess; both her one-night stand Parker and Faith, who steals her body in a Grand Theft Me plot, comment explicitly on the matter.
 * The inventor of the "Venus butterfly" on L.A. Law.
 * In the final episode of Weird Science, Gary shows up with an alien girlfriend. Considering she looks the same as the rest of the weird-looking humanoid aliens of the species, nothing like a Green-Skinned Space Babe or Cute Monster Girl, Wyatt wonders what exactly he sees in her—until he finds out just touching her hand feels so good that it causes him to do an ecstatic Jim Carrey / Jerry Lewis imitation. Apparently it's a feature of the species.
 * Captain Jack Harkness.

Mythology

 * Most, if not all, Love Goddesses (or Love Gods) have been portrayed as this in at least one interpretation of their myths.

Tabletop RPG

 * In the Conan the Roleplaying Game there is the temptress class. At high levels the tempress gains the ability to have such energetic and exhausting sex with a willing partner that afterward the partner will fall into a deep slumber where they can only be awakened by attacking them (or dumping a bucket of water on them). She is also so skilled at seduction that she can easily manipulate men into doing her bidding.

Video Games

 * In Dragon Age II, Isabela claims to be so good in bed, she can turn even the straightest woman lesbian/bisexual.
 * Fallout 2 has the "Kama Sutra Master" perk. Given that there is one occasion where your "score" for sex has an effect, and only if Dump Stated physical attributes and charisma (an extremely unorthodox method of play), which prevent you from qualifying for it anyways, its a Useless Item.

Webcomics

 * El Chupacabra in Girly possesses legendary skills to please any woman (and practically every woman) he ever faces. The action itself is never shown, but the immediate aftermath, quite a lot. Generally the ladies are barely able to walk from all the fun their nerves had.

Western Animation

 * The Simpsons has Ned Flanders. He has sex once with a movie star who is in town to shoot a film. He tells her that the first one's free, but if she wants any more she'll have to marry him. She almost does.
 * Skwisgaar Skwigelf of Metalocalypse.