Resources on caring for planets that keep dying?

All my planets die after they start growing a western civilization and I don't know why. I've tried controlling every factor that I can although without theory, praxis, overthrowing the bourgeousie etc. I even have a shitty UBI that I try to stimulate the poor parts, but I can't find any reliable resources on how to actually interpret what I'm seeing. I want to know how to use this kind of data so that I can raise my planets right.

Where can I learn about this? I mean diagnosing problems, monitoring variables, finding solutions to each situation etc. google obviously sucks and gives nothing of substance

I will say that I recently got a new President, maybe the old one was the problem. But then there's China, who raises beautiful public transit systems and all that using the exact same resources I'm getting shitty results with. I'm literally not doing anything different to China, so maybe it's the water? I really don't know.

Edit: in fact, the lush microchips 🪻 China is currently flexing is a piece of the one my President bought. Same chips, different soil.

Edit 2: also, the democracies always look alright when I dig their cadavers to analyze. No people's party, mass line, classlessness etc in any part of any planet so far.