Licensed Clinical Social Worker in Mexico?

In general, a professional needs to obtain a cedula professional in Mexico. There is a process for certifying studies outside of Mexico. Not all foreign universities are recognized here. Cedulas are typically issued through the SEP (education) in Mexico City (rather, than, say, the Health Ministery). See the relevant section of the Mexican Constitution, as amended:
http://www.sep.gob.mx/...t5_ejerc_prof_df.htm . The reciprocity clause for foreigners probably is no help as the U.S. is damn stingy when it is a matter of recognizing foreign professionals, usually requiring almost starting from scratch. You can search the Internet for other relevant items. There are Mexicn law firms that can assist with the process, though one can do it unaided. You might also want to check with the relevant authorities is the state in which you intend to reside.

Compensation is poor. Finding a job in the governmental sector without well placed contacts, quite difficult. Compensation by insurance companies for a private practicioner, depends on the terms of coverage, but most of those covered are likely to be directed to affiliated clinics, etc. Try to find a Mexican social worker over the social networks, and ask, and/or talk with the relevant Mexican private insurance companies as well as IMSS and ISSSTE person to person.

Which is not to say that you will not find a path that works for you. Best of luck.

Edited to add, and I forgot to touch on the immigration issue. If you qualify for Mexican citizenship, okay, but if not and you are applying to enter Mexico to work, you will need the appropriate immigration status, which typically requires that you have a job offer in hand prior to entry.