Green water stress can negatively affect agricultural production and is often mitigated through irrigation. In this global modelling study, we investigate where and to what extent the implementation of irrigation helps to compensate for green water stress but at the same time leads to an increase in blue water scarcity. Our findings highlight the need to consider both water stresses together, along with their dynamic interactions, for sustainable water management.