Demon's Souls Remake - All Spells and Miracles Guide

To get them all you will need multiple playthroughs (3 if you do it the regular way) as you need to exchange boss souls for spells/miracles.

You also need to rescue few NPC's so that they appear in Nexus: Saint Urbain, Sage Freke and Yuria. You can learn spells/miracles from them, they are all at the ground floor of Nexus.

Saint Urbain

You will come across Saint Urbain in world 4-2. From that checkpoint, go straight, down the stairs and back inside again. Fall down next to the reaper enemy, kill it. Descend the stairs and turn back, you will see a path inside of the room that is just above where the reaper was. Talk to Patches here, get close to the pit and he will push you inside. Talk to Saint here and try to leave via the opposite door. Beat the Black Phantom and talk to Saint again. He will now move to Nexus when you teleport out of this dungeon.

Sage Freke

When you reach a bih statue that shoots arrows in world 3-1 (Prison of Hope), you need to get behind it.

Get the Special Key (at the far end in the tower, which is east when your back is facing big statue with shooting arrows). With this key you can open cell doors to save Freke and unlock A Dash of Sage Trophy. From starting point he is on the right side of the halway which connects from the middle of the stairs when you start descending down. If you reach the hallway that has 2 doors on the right and stairs to go up again you've gone too far.

Yuria

First, you will need to defeat 3 bosses on each world to unlock path towards 1-4 (world 1 - Boletarian Palace, teleport 4). By progressing from 1-3 towards 1-4 you will encounter Fat Official enemies. First one will give you the Iron Key Ring. Now teleport back to 1-3 and turn around. On your right through the building are locked doors. Open them using the key, kill another Fat Official there, grab his key - Bloody Iron Key.

Now teleport to 1-3 again, but this time go straight and enter the small alley just right of the first car you see (the bouncing one with the caged dogs inside). In the alley you can now unlock the door with the Bloody Iron Key. Follow this path until you reach the top of the stairs.

Equip the full Fat Official set:

Official's Cap (second Fat Official when goind from 1-3 towards 1-4, which is behing the bars. You will reach him via alternative route, just don't go in boss direction, go opposite when you get to that area)
Official's Clothes (World 2-2 - The Tunnel City - Kill one of the Fat Official's there. He is just at the end of the left tunnel straight from the starting point)
Official Gloves (World 2-1 - Smithing Grounds - Kill another Fat Official's there; the 3rd one on the bridge will give you Gloves)
Official's Leggings (World 2-1 - Smithing Grounds - Kill yet another Fat Official's there; the 4th one before the fog door will give you Leggings)

Fat Official will lower the stairs. Backstab him and finish him off. Equip something else and talk to Yuria (otherwise she will think you are the enemy) for a few times. Trophy unlocked, Yuria will now move to Nexus next time you teleport there.

0:01 - Find Iron Key Ring starting from 1-3
1:35 - From Iron Key Ring, continue and kill another Fat Official for Official's Hat
3:03 - Use Iron Key Ring to enter Biorr cell area (from 1-3 again) and kill another Fat Official for Bloody Iron Key
3:52 - Collect Official Gloves and Official's Legging from Officials in 2-1 (kill all 3 and loot them, the last one on the bridge will give you Gloves)
***NOTE*** 4th Fat Official before the fog gates later will drop Clothes (path of story progression)
5:42 - Official's Clothes - From 2-2 just go straigh and left. Kill Fat Official behind the corner
6:23 - Equip full Official Set
6:30 - Make your way towards Yuria from 1-3 again. You can use Bloody Iron Key to open the doors on your way there
7:57 - Make sure you remove Official Set and talk to Yuria so she can move to Nexus

All Miracles

Miracle Teacher:
Antidote: 3000 Souls
Evacuate: 20000 Souls
Heal: 5000 Souls
Hidden Soul: 3000 Souls

Saint Urbain:
Anti-Magic Field - Storm Demon’s Soul (Storm King)
Banish - Yellow Demon’s Soul (Old Monk)
Cure - Wriggling Demon’s Soul (Leechmonger)
God’s Wrath - Dragon Demon’s Soul (Dragon God)
Recovery - 3 Colorless Demon’s Souls (Primeval Demons - 1 per each world (5 in sum) when you shift world tendency to pure black)
Regeneration - Swollen Demon’s Soul (Adjudicator)
Resurrection - Pureblood Demon’s Soul (Maiden Astraea)
Second Chance - Hero Demon’s Soul (Old Hero)

0:01 - World 1-3
1:25 - World 2-1
2:13 - World 3-2
5:53 - World 4-2
7:24 - World 5-3

All Spells

Spell Teacher:
Cloak: 500 Souls
Familiar’s Prank: 500 Souls
Flame Toss: 1000 Souls
Enchant Weapon: 5000 Souls
Protection: 5000 Souls
Soul Arrow: 1000 Souls
Water Veil: 500 Souls

Sage Freke:
Acid Cloud - Eroded Demon’s Soul (Dirty Colossus)
Death Cloud - Pureblood Demon’s Soul (Maiden Astraea)
Fireball - Dragon Demon’s Soul (Dragon God)
Fire Spray - Hard Demon’s Soul (Armor Spider)
Homing Soul Arrow - Yellow Demon’s Soul (Old Monk)
Light Weapon - Silver Demon’s Soul (Penetrator)
Poison Cloud - Wriggling Demon’s Soul (Leechmonger)
Soul Ray - Doll Demon’s Soul (Fool’s Idol)
Warding - Iron Demon’s Soul (Tower Knight)

Yuria:
Curse Weapon - Silver Demon’s Soul (Penetrator)
Firestorm - Dragon Demon’s Soul (Dragon God)
Ignite - Hard Demon’s Soul (Armor Spider)
Relief - Pureblood Demon’s Soul (Maiden Astraea)
Soulsucker - Maiden In Black Demon’s Soul (make sure that you don’t kill Maiden in Black at the end of the game)
Soul Thirst - Yellow Demon’s Soul (Old Monk)