No. You may be thinking of citric acid, which I find people often confuse with sodium citrate due to the similarity in name. Sodium citrate is not sour at all - tasted on its own, it’s just a bit salty and a little bitter. When I cook with it, I am just careful to adjust the salt level as necessary. The slight bitterness is generally masked by the other flavors in the food.
