In order to study the circumgalactic medium (CGM) of galaxies we develop an automated pipeline to estimate the optical continuum of quasars and detect intervening metal absorption line systems with a matched kernel convolution technique and adaptive S/N criteria. We process $\sim$ one million quasars in the latest Data Release 16 (DR16) of the Sloan Digital Sky Survey (SDSS) and compile a large sample of $\sim$ 160,000 MgII absorbers, together with $\sim$ 70,000 FeII systems, in the redshift range $0.35Comment: 23 pages, 20 Figures, 3 Appendices, MNRAS accepted. The MgII absorber catalogue is publicly available at https://wwwmpa.mpa-garching.mpg.de/SDSS/MgII/