Self sufficiency is not really achievable in an urban setting. Hydroponics can definitely increase the yield per square foot but it uses a lot of electricity if done indoors. Also things like cereal grains that require a ton of space can’t really be grown in a hydroponic system.

Hydroponics is good for growing herbs and with grow lights can grow microtomatoes and leafy greens but there’s a lot of limitations to it