veyepar: When Your SME Ghosts You: Using GenAI to Build a Database Documentation Agent

Author(s):	Denise Williams
Location	Ballroom A
Date	jul Sun 27	Days Raw Files
Start	13:15	First Raw Start	12:50
Duration	00:30:00	Offset	0:24:54
End	13:45	Last Raw End	13:50
Chapters	00:00 0:13:11 0:20:41
Total cuts_time	27 min.

https://www.pyohio.org/2025/program/talks/when-your-sme-ghosts-you
raw-playlist raw-mp4-playlist encoded-files-playlist host mp4 svg png

assets release.pdf When_Your_SME_Ghosts_You_Using_GenAI_to_Build_a_Database_Documentation_Agent.json
logs
Admin: episode episode list cut list raw files day marks day marks day image_files

State:
Locked:	clear this to unlock
Locked by:	user/process that locked.
Start:	initially scheduled time from master, adjusted to match reality
Duration:	length in hh:mm:ss
Name:	Video Title (shows in video search results)
Emails:	email(s) of the presenter(s)
Released:	has someone authorised pubication
Normalise:
Channelcopy:	m=mono, 01=copy left to right, 10=right to left, 00=ignore.
Thumbnail:	filename.png
Description:	Have you ever been handed a mystery database and told, “You’ll figure it out”... with no documentation, no SME, and no time? In this session, I’ll share how I turned a frustrating (and very relatable) real-world problem into a capstone project for Kaggle's Gen AI 5 Day Intensive Course with Google: building a GenAI-powered Database Documentation Agent using Python, SQLite, and the Gemini API — aka what I like to call my SME Ghost Protocol. I’ll walk through how I used GenAI to automatically generate natural language summaries, answer ad-hoc schema questions, and create entity relationship diagrams — even when human help wasn't available. We'll dive into the challenges of working with GenAI as a "coding partner," designing prompts like communication plans, and lessons learned the hard way about iteration, hallucination, and debugging when you're flying solo. Expect live demos, practical takeaways, a little workplace sarcasm, and ideas for how you can launch your own SME Ghost Protocol — because sometimes, GenAI is the only teammate who shows up.👻 markdown
Comment:	production notes

2025-07-27/12_50_06.ts Apply: 12:53:39 - 13:06:32 ( 00:12:53 ) S: 12:50:06 - E: 13:20:05 D: 00:29:59 (Start: 213.0) (End: 986.0) show more...

vlc ~/Videos/veyepar/pyohio/pyohio_2025/dv/orchid_west/2025-07-27/12_50_06.ts :start-time=0213.0 --audio-desync=0

	Raw File	Cut List
	12:50:06		seconds: 213.0 Wall: 12:53:39
Duration	00:29:59
	13:20:05		seconds: 986.0 Wall: 13:06:32
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2025-07-27/12_50_06.ts Apply: 13:06:32 - 13:06:54 ( 00:00:22 ) S: 12:50:06 - E: 13:20:05 D: 00:29:59 (Start: 986.0) (End: 1008.0) show more...

vlc ~/Videos/veyepar/pyohio/pyohio_2025/dv/orchid_west/2025-07-27/12_50_06.ts :start-time=0986.0 --audio-desync=0

	Raw File	Cut List
	12:50:06		seconds: 986.0 Wall: 13:06:32
Duration	00:29:59
	13:20:05		seconds: 1008.0 Wall: 13:06:54
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2025-07-27/12_50_06.ts Apply: 13:06:54 - 13:20:05 ( 00:13:11 ) S: 12:50:06 - E: 13:20:05 D: 00:29:59 (Start: 1008.0) show more...

vlc ~/Videos/veyepar/pyohio/pyohio_2025/dv/orchid_west/2025-07-27/12_50_06.ts :start-time=01008.0 --audio-desync=0

	Raw File	Cut List
	12:50:06		seconds: 1008.0 Wall: 13:06:54
Duration	00:29:59
	13:20:05		seconds: 0.0 Wall: 12:50:06
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2025-07-27/13_20_06.ts Apply: 13:20:06 - 13:27:36 ( 00:07:30 ) S: 13:20:06 - E: 13:50:06 D: 00:30:00 (End: 450.942186) show more...

vlc ~/Videos/veyepar/pyohio/pyohio_2025/dv/orchid_west/2025-07-27/13_20_06.ts :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	13:20:06		seconds: 0.0 Wall: 13:20:06
Duration	00:30:00
	13:50:06		seconds: 450.942186 Wall: 13:27:36
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2025-07-27/13_20_06.ts Apply: 13:27:36 - 13:34:16 ( 00:06:39 ) S: 13:20:06 - E: 13:50:06 D: 00:30:00 (Start: 450.942186) (End: 850.21527) show more... channelcopy=10

vlc ~/Videos/veyepar/pyohio/pyohio_2025/dv/orchid_west/2025-07-27/13_20_06.ts :start-time=0450.942186 --audio-desync=0

	Raw File	Cut List
	13:20:06		seconds: 450.942186 Wall: 13:27:36
Duration	00:30:00
	13:50:06		seconds: 850.21527 Wall: 13:34:16
Comments:		channelcopy=10
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2025-07-27/13_20_06.ts Apply: 13:34:08 - 13:34:15 ( 00:00:07 ) S: 13:20:06 - E: 13:50:06 D: 00:30:00 (Start: 842.0) (End: 849.0) show more...

vlc ~/Videos/veyepar/pyohio/pyohio_2025/dv/orchid_west/2025-07-27/13_20_06.ts :start-time=0842.0 --audio-desync=0

	Raw File	Cut List
	13:20:06		seconds: 842.0 Wall: 13:34:08
Duration	00:30:00
	13:50:06		seconds: 849.0 Wall: 13:34:15
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

Rf filename:	root is .../show/dv/location/, example: 2013-03-13/13:13:30.dv
Sequence:
get this:	check and save to add this