Best way to store a large ammount of spells ?

Haha sorry, i'm a french developer, i forgot to rewrite this comment :D

You fully understood the idea for the implementation of spells.

- For the different animations, you have to add in DataSpell an "AnimationName" property that you will fill like the rest in the "Database" class. This name must be the name of the prefab that contains your animation. Then, create a DataSpell.Instantiate () method which will have the role of creating the instance of this animation.

 using System.Collections.Generic;
 using UnityEngine;
 using UnityEditor;
 using System;
 
 [System.Serializable]
 public class DataSpells
 {
     public string Name = string.Empty;
     public string Description = string.Empty;
     public string ParticleEffect = string.Empty;
     public string SoundEffect = string.Empty;
     public string tag = string.Empty;
 
     public DataSpells(){}
 
     public DataSpells(string name, string tag)
     {
         this.Name = name;
         this.tag = tag;
     }
 
     public GameObject Instantiate(float PlayerXPosition, float PlayerYPosition)
     {
         // Création de l'effet dans la scène
         GameObject go = GameObject.Instantiate(
             ((GameObject)AssetDatabase.LoadAssetAtPath(LinkEffect(this.Name), typeof(GameObject)))
             , new Vector3(PlayerXPosition, PlayerYPosition, 0), Quaternion.identity) as GameObject;
         return go;
     }
 
     public string LinkEffect(string name)
     {
         return "YourPath"+name+".prefab";
     }
 }
 

- For the different effects, if it's turn-based combat, you can create a unique script to associate with each spell concerned according to their effects. But if it is in real time in the environment with multiple gameobjects, I would advise you rather to associate a script similar to all the gameobjects which will make the object react according to the spell which strikes it, thanks to OnCollideEnter (), OnTriggerEnter () or OnParticleCollide () for example.