We went at the end June and had a great time, more Puffins than you can shake a stick at.
I think they may have all gone now, so probably best to plan a visit for next year.
If you google "skomer time line" you should find a PDF document that show when the various species are around on the island.