It depends on the mod you want to use. I personally think it is a bad idea to start mods up mid-playthrough in any game, but if the mod developer says on their page that it is safe to do, then it should be fine.