i showed an contractor and he diy-ed for me.

material required;

roof tiles (but clear transparent plastic)
metal since
glass
some wood

he climbed up and decided the best place to put. replaced the tile with the transparent tiles. bent the metal zinc into circle. rivet it. created a wooden frames (top and bottom) to keep the shape. cut a hole at the ceiling board below. put a glass.

all done. i did at two location. most expensive item is the transparent plastic tile. two workers one day. not the most beautiful but works.