Aquaponics, the water-reusing production of fish and crops, is taken as an example to investigate the consequences of upscaling a nature-based solution in a circular city. We developed an upscaled-aquaponic scenario for the German metropolis of Berlin, analysed the impacts, and studied the system dynamics. To meet the annual fish, tomato, and lettuce demand of Berlin’s 3.77 million residents would require approximately 370 aquaponic facilities covering a total area of 224 hectares and the use of different combinations of fish and crops: catfish/tomato (56%), catfish/lettuce (13%), and tilapia/tomato (31%). As a predominant effect, in terms of water, aquaponic production would save about 2.0 million m3 of water compared to the baseline. On the supply-side, we identified significant causal link chains concerning the Food-Water-Energy nexus at the aquaponic facility level as well as causal relations of a production relocation to Berlin. On the demand-side, a ‘freshwater pescatarian diet’ is discussed. The new and comprehensive findings at different system levels require further investigations on this topic. Upscaled aquaponics can produce a relevant contribution to Berlin’s sustainability and to implement it, research is needed to find suitable sites for local aquaponics in Berlin, possibly inside buildings, on urban roofscape, or in peri-urban areas.