Below are all the spells And what dice they use and any effects if any organized in Damage, Debuff, and Buff categories.
Damage:
Fire: Roll a D-8 deal 200% damage to Ice Type Keyblade wielders. 5 MP
Fira: Roll a D-12 apply the previous effect of thunder 10 Mp
Firaga: Roll a D-20 or a D-100 if your Sorcery is higher than 300 apply the previous effects of Fire and Fira. 15 Mp
Thunder: Roll a D-8 Deal 200% damage to Water Type Keyblade Wielders 5 Mp
Thundara: Roll a D-12 Apply the previous effect of Thunder 10 Mp
Thundaga: Roll a D-20 or D-100 if your Sorcery is higher than 300 deal the previous effects of thunder and thundara. 15 Mp
Blizzard: Roll a D-8 deal 200% damage to Thunder type Key Blade wielders 5 Mp
Blizzara: Roll a D-12 apply the previous effects of Blizzard 10 Mp
Blizzaga: Roll a D-20 or D-100 if your magic is higher than 300, apply the previous effects of Blizzard and Blizzaga 15 Mp
Water: Roll a D-8 deal 200% damage to Fire Type Key Blade wielders 5 Mp
Watera: Roll a D-12 apply the effects of Water 10 Mp
Waterga: Roll a D-20 or D-100 if your Sorcery is higher than 300 apply the previous effects of Water and Watera. 15 Mp
Gravity: Roll a D-10 cast 1 turn of slow 10 Mp
Gravira: Roll a D-12 Cast 2 turns of Slow 20 Mp
Graviga: Roll a D-20 or D-100 if your Sorcery is higher than 300 cast 3 turns of slow. 30 Mp
Ultima: Roll a D-50 deal 1.25x Damage to Faster Characters 50 Mp
Omega: Roll a D-50 Deal 1.25x Damage to Slower Characters 50 Mp
Dark Firaga: Apply the same rules of Firaga, deal 1.25x Damage to all attributes. 25 Mp
Void: Roll a D-12 inflict 1 turn of Silence on enemies 35 Mp
Light Flare: Roll a D-20 blind 1 enemy for 1 turn 60 Mp
Debuff
Poison: Poison the enemy, dealing 5% damage every turn for 3 turns 10 Mp
Poisonga: Poison the Enemy, Dealing 10% damage every turn for 2 20 Mp
Slow: Slow the enemy for 2 turns 15 Mp
Slowa: Slow the Enemy for 4 turns 30 Mp
Slowga: Slow the Enemy for 6 turns 45 Mp
Stop: Your opponent skips his next turn 20 Mp
Stopza: Your opponent Skips his next 3 turns 100 Mp Overpowered
Silence: Your opponent is Silenced and can't use Magic for 2 turns 25 Mp
Blindness: Your opponent is Blinded and can't attack for 2 turns 50 Mp
Buffs
Aero: Attacks deal 10% less damage 10 Mp
Aerora: Attacks Deal 25% less Damage 20 Mp
Aeroga: Attacks deal 50% less damage 30 Mp
Shell: Magic attacks do not affect you for 1 turn 50 Mp
Reflect: Physical attacks do not affect you for 1 turn 50 Mp
Esuna: Heal all status ailments of the target 45 Mp
Life: Fully revive a fallen ally 150 Mp
Cure: Heal 25% of the targets HP 10 Mp
Cura: Heal 50% of the Targets HP 30 Mp
Curaga: Heal 75% of the Targets HP 50 Mp