Davos

From SGCommand

Davos was a Human native to the Pegasus galaxy. He had one daughter named Linara, and a gift; he could envision events from the future. At one point, he had a vision that Wraith Hive Ships arrive over Vedeena. He warned his people and they all evacuated from their villages into the caves. When the Wraith arrived, everyone hid and no-one was culled. Since then he became the leader of his people.

Unfortunately, he was diagnosed with a lymphatic cancer. He envisioned Atlantis 1 arriving on his homeworld, in the hopes that he would be cured. However there was nothing the Atlantis expedition could do, and he died. (ATL: "The Seer")