The Planck Catalogue of Compact Sources (PCCS2) is an unbiased census of the millimetre sky at sub-Jansky levels, and thus a valuable resource for studies of galaxy evolution. Nevertheless, its application to extra-galactic studies is hindered by its limited angular resolution of few arcminutes. In order to open the PCCS2 for an in-depth exploitation, understanding their nature is paramount: are they active galactic nuclei, dusty star forming galaxies, proto-clusters, chance alignments? Improving the positional information and angular resolution will also be beneficial in this quest. Here we aim to unveil the PCCS2 sources in the northern hemisphere. We observed the bright end of the 143 and 217GHz PCCS2 at Dec>=-41.2 degrees with the New IRAM KID Arrays 2 camera (NIKA2) at 1.2mm (260GHz) and 2.0mm (150GHz). The sample includes 487 targets. Map making and source extraction have been carried out with the latest version of the NIKA2 data reduction software. NIKA2 detected 54% and 77% of the targets at 1.2 and 2.0mm. More than 95% are point-like sources, five are resolved in two components, and only 4% are extended at the resolution of NIKA2. By cross-matching the NIKA2 catalogue to the NASA Extragalactic Database, the redshift of ~86% of the sources was found, covering the range from z~0 to 3.4, with a median z=0.77. The number density of the 143 GHz PCCS2 is 0.029deg^-2^, in good agreement with model predictions. Roughly 80% of these sources are QSOs or AGN, with a median NIKA2 spectral index alpha=-1.15, typical of non-thermal synchrotron emission. With a positional accuracy smaller than 3.0-arcsec, and an angular resolution of 11.6 and 18.0-arcsec at 1.2 and 2.0mm, respectively, the NIKA2 PCCS2 catalogue is hereby released to the community.