Good question. I happen to have studied and applied motivation theory in my doctoral work at Virginia Tech.
First, a related topic - procrastination. Mastering procrastination is all about understanding where you lack confidence on the task(s) at hand. You repeatedly ask “what part of this is ‘scaring’ me?” and work through the details of the task(s). Eventually, you find one or more parts make you hesitant, and you can address them.
As an engineer (my first career), I’m also a heavy analyst though, too. So, I’ve been through analysis paralysis more times than I can count. But, in recent years, I’ve learned to apply the procrastination tactics in these cases and it seems to work well. I still think there’s one or two unique elements to paralysis vs procrastination, and I’ll figure it out, but for now it’s working super well.