CCN family protein 2 (CCN2), also widely known as connective tissue growth factor (CTGF), is one of the founding members of the CCN family of matricellular proteins. Extensive investigation on CCN2 over decades has revealed the novel molecular action and functional properties of this unique signalling modulator. By its interaction with multiple molecular counterparts, CCN2 yields highly diverse and context-dependent biological outcomes in a variety of microenvironments. Nowadays, CCN2 is recognized to conduct the harmonized development of relevant tissues, such as cartilage and bone, in the skeletal system, by manipulating extracellular signalling molecules involved therein by acting as a hub through a web. However, on the other hand, CCN2 occasionally plays profound roles in major human biological disorders, including fibrosis and malignancies in major organs and tissues, by modulating the actions of key molecules involved in these clinical entities. In this review, the physiological and pathological roles of this unique protein are comprehensively summarized from a molecular network-based viewpoint of CCN2 functionalities.