No, Kaepora Gaebora does not appear in Skyward Sword. However, Gaepora, Zelda's father, bears a striking resemblance to Kaepora Gaebora. He's also quick to offer information and advice if Link finds himself in a tough spot.