Has anyone here generated RAM using sky130pdk. If so how to do it

Support for sky130 technology in OpenRAM isn't published yet

Is it possible to create the support myself

Sure ... if you have a few months of free time, go ahead.