Water contamination is a serious issue that has an impact on the whole globe. In the current work, adsorption technique was used to remove synthetic Reactive Blue MEBF 222 textile dye utilizing Cd-doped Co (Co1-xCd1.5xFeO3), Zn-doped Co (Co1-xZn1.5xFeO3), Cr-doped Co (Co1-xCr1.5xFeO3), Zn-doped Ni (Ni1-xZn1.5xFeO3), and Cr-doped Ni (Ni1-xCr1.5xFeO3) perovskites, synthesized by sol-gel auto-combustion approach. According to the findings of batch adsorption studies, maximum adsorption was observed at pH 3 (45.62mg/g), 0.01g/50ml dosage (36.67mg/g), 60min (14.31mg/g), 100ppm dye concentration (47.41mg/g), and 308K (35.96mg/g) for Co1-xCd1.5xFeO3; at 3 pH (42.94mg/g), 0.01g/50ml dosage (35.33mg/g), 60min (12.88mg/g), 100ppm dye concentration (40.52mg/g), and 308K (31.31mg/g) for Co1-xZn1.5xFeO3; at 2 pH (38.82mg/g), 0.01g/50ml dosage (32.20mg/g), 60min (11.98mg/g), 100ppm dye concentration (33.54mg/g), and 308K (29.34mg/g) for Co1-xCr1.5xFeO3; at 2 pH (34.97mg/g), 0.01g/50ml dosage (30.41mg/g), 60min (10.46mg/g), 100ppm dye concentration (27.19mg/g), and 308K (26.12mg/g) for Ni1-xZn1.5xFeO3; and at 2 pH (31.22mg/g), 0.01g/50ml dosage (25.04mg/g), 60min (9.48mg/g), 100ppm dye concentration (21.73mg/g), and 308K (23.61mg/g) for Ni1-xCr1.5xFeO3. The pseudo-second-order model showed good fitness for adsorption kinetic data. Electrolytes, detergents/surfactants, and heavy metal ions had a substantial impact on the adsorption potential. The column adsorption experiments demonstrated optimal bed height, flow rate, and intake dye concentration to be 3cm, 1.8ml/min, and 70mg/l, respectively, in the column experiment. With an adsorption capacity of 44.1mg/g, reactive blue (RB) 222 dye was able to achieve its maximum adsorption. Detailed desorption of RB 222 dye was also achieved. The novelty of this adsorption method lies in its eco-friendliness, ease of handling, and cost-effectiveness.