Sand production is a troublesome problem in the petroleum industry, especially in relation to weakly consolidated formations. In this work, a visual experimental apparatus, which allows sand particles to be observed, has been constructed to simulate sand production in weakly consolidated sandstone core. The experimental apparatus can accommodate sandstone core flakes as a reactor. The experiment aims to investigate the microscopic sand production mechanism of the weakly consolidated sandstone reservoir under the influence of high water cut, high clay content and polymer aging blockage. Core flakes were produced using simulated formation sands with median particle sizes of 160 μm and uniformity coefficients of 2.5, 4.6, 7.3 and 12.6, as well as clay (content 5%, 10%, 20%, 30%, respectively) and aged polymers in the wells. A total of 17 sets of experimental tests were carried out with water injection. The visual experimental results show that sand morphology presents complex wormhole. Morphology is particularly affected by core strength and heterogeneity. Based on dynamic differential pressure of experimental results, most sand production process is divided into two obvious stages, that is, the cavities formation stage of sharp sand production and the stable sand production stage. Analysis of sensitive factors revealed that the sand production rate is strongly influenced by the core strength and related to clay content, formation heterogeneity and production program. The volumetric sand production ratio decreases with the increase of core strength, with the volumetric sand production ratio (VSPR) reaching up to 0.24%. It is found that about 38% clay (1–3.91 μm) was produced in the initial stage of low flow, which is particularly evident in cores with high clay content. Moreover, for weakly consolidated reservoir, the particle competition peeling mechanism of wormhole front is proposed, and the strengthening bonding effect of aging polymer and the pore blockage effect of fine clay are clarified. The findings could contribute to better understanding of the mechanisms underlying sand production in weakly consolidated sandstone reservoirs, which also provide a solid evidence base for accurate sand production prediction and more targeted sand control.