Lakes are considered one of the most important components of the land cover which is exposed to environmental changes threatening their sustainability. Idku is one of the most radical coastal lakes in Egypt. Thus, the current study focused its aim on setting a  database for LULC spatiotemporal changes of Idku Lake that can be relied on for the management and the comprehensive study of its productivity and related economics. Satellite images of CORONA, Landsat TM, ETM, and OLI-TIRS and Sentinel-2A were used throughout the period from 1967 to 2021. Different processing techniques were applied to extract different features in the study area such as hydrophytes, water bodies, islands and urban. Results indicate that there is a great diminution in Idku Lake's total area of about 58% from 136.5 km² in 1967 to 56 km² in 2021, with vegetation covering of about twice the open water area and a depth range between 0.18-3.03m. These phenomena are attributed to anthropogenic unregulated activities of land use in which aquaculture represented 80.5% of the reduced area. The problem can be defined in terms of sustainability in general and productivity in particular. Based on the results and according to CAPMAS, fish production of Idku Lake and its related economy have witnessed a change over the past two decades. The period from 1994 to 2004 reflected an increasing trend and the period from 2004 to 2019 reflected a dramatically decreasing production trend. Idku Lake recorded a 30% of fish production loss from 2004 to 2019 and a 46% of economic return loss of about 8.2 million$ yearly. Lake change and pollution are key factors in production detraction and quality alteration rather than health and economic effect, and thus there should be monitoring and control mechanisms for those changes.