"Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?"

Play your stuff on a staging server first, and if possible on a container or vm in the test pipeline of your infra code.

And well, start with a backup and be careful when you're working in production but that's common sense right ?

Staging works well in my experience. How can you benefit from a test pipeline and a staging system with tools that bypass it and ssh right into the production systems?

what kind of human error

Keep a menacing hammer in the corner of the room. Walk in once a week and fondle it with a viscous grin just waiting and daring someone to make you use it.