The invention discloses a chromium-free self-lubricating passivation solution and a preparation method thereof. The chromium-free self-lubricating passivation solution is formed by compounding the following compositions in percentage by weight: 8%-12% of water-borne epoxy resin, 0.5%-1% of curing agent, 10%-15% of silane coupling agent, 0.5%-1% of inorganic component, 2%-4% of solid lubricant, 1%-2% of friction modifier, 0.5%-1% of anti-wear agent, 0.5%-1% of anti-sinking agent, and 60%-75% of diluting agent. The inorganic component is one or a combination of Ce(NO3)3 and sodium molybdate, the solid lubricant is one or a combination of two or more of polytetrafluoroethylene, polyethylene wax, polyethylene, molybdenum disulfide and graphite, the friction modifier is self-synthesized molybdenum dialkyldithiophosphate, the anti-wear agent is one or a combination of nanosilicon dioxide and nano aluminum oxide, the anti-sinking agent is attapulgite, and the diluting agent is a mixture of water and ethanol. A plate product coated with passivation solution has the advantages of being pollution-free, low-friction, anti-oxidized, anti-wear and extreme pressure-resistant, corrosion-resistant, finger-resistant, having good mechanical performance and the like, and the passivation solution can be directly coated on the surfaces of a zinc-plated plate and parts of certain mechanical equipment for use.