I wrote a perl script for the terminal that permitted searching all of these items for requested episode patterns/Titles/numbers/cast. The search results include info from every episode where a case insensitive match is found. I also enabled running the episode's video in QuickLook or QuickTime. The search results were color coded to differentiate search/cast/synopsys info. (no color shown below.)
Simplest example searching for a director:
sg1.pl 'William Waring' -terse ( just episode numbers ) Search for "William Waring" was found in 13 episodes: 109, 131, 147, 156, 164, 177, 178, 185, 194, 196, 198, 202, 212.
sg1.pl 109 SG1 Episode=[#109] S5 E21, => 'SG 2001 Stargate SG1 S5 D5_5.m4v', "Meridian", 05/10/02, Director: William Waring, Writer(s): Robert C. Cooper, cast: [Amanda Tapping (Major Samantha Carter), Christopher Judge (Teal'c), Michael Shanks (Dr. Daniel Jackson), Richard Dean Anderson (Colonel Jack O'Neill), Don S. Davis (Major General George Hammond), Gary Jones (Sgt. Walter Harriman), Teryl Rothery (Dr. Janet Fraiser), Corin Nemec (Jonas Quinn), Carmen Argenziano, Jacob Carter / Selmak), Mel Harris (Oma Desala), David Hurtubise (Tomis)], Daniel incurs lethal radiation exposure when he prevents a potentially cataclysmic accident in a weapons laboratory on the planet Langara (P9Y-4C3) but the mysterious Oma Desala shows him that death can simply be another beginning. While the alien government responsible for the lab accuses him of attempting to sabotage their research the Kelownan Jonas Quinn tries to negotiate with SG-1.