ABSTRACT In science education, scientific inquiry is crucial for developing inquiry skills and constructing scientific knowledge. However, the impact of scientific inquiry activities on student achievement continues to be debated. A number of counterintuitive findings highlight the need to explore the underlying factors influencing the effectiveness of inquiry-based learning. This study employed hierarchical linear models (HLM) to investigate the role of students’ perceived school teacher support in moderating the relationship between inquiry-based science activities and science achievement. The sample used in this study was drawn from Beijing, Shanghai, Jiangsu, and Guangdong in mainland China (B-S-J-G-China). These four provinces participated in the 2015 Programme for International Student Assessment (PISA) as a collective group. The dataset comprised 9,592 students (4,543 females and 5,049 males) from 261 schools. Results revealed a negative correlation between inquiry-based activities and science achievement, indicating that a higher frequency of inquiry-based activities was associated with lower science achievement. However, this association was positively and significantly moderated by the extent of school teacher support. These findings highlight the pivotal role of students’ perceived school teacher support in enhancing the effectiveness of inquiry-based practices and shed light on optimising inquiry-based educational strategies. This suggests that the effective implementation of inquiry-based activities requires the backing of supportive teachers, with broader implications for curriculum design and teacher development in science education.