ClippyGPT - How I Built Supabase’s OpenAI Doc Search (Embeddings)

Supabase hired me to build ClippyGPT - their next generation doc search. We can ask our old friend Clippy anything you want about Supabase, and it will answer it using natural language. Powered by OpenAI + prompt engineering. In this video I will be showing you exactly how I did this, and how you can do the same in your projects. We'll be covering: Prompt engineering and best practices Working with a custom knowledge base via context injection + OpenAI embeddings How to store embeddings in Postgres using pgvector Supabase blog post: https://supabase.com/blog/chatgpt-sup... pgvector extension: https://github.com/pgvector/pgvector Generate embeddings implementation: https://github.com/supabase/supabase/... Clippy edge function implementation: https://github.com/supabase/supabase/... Clippy frontend implementation: https://github.com/supabase/supabase/... Prompt engineering: https://prmpts.ai/blog/what-is-prompt... 00:00 Why? 01:40 Let's get started 03:15 Custom knowledge base 04:49 Context injection 06:13 Pre-process MDX files 13:40 Embeddings 15:40 Storing in Postgres + pgvector 22:21 API endpoint (edge function) 23:44 Calculating similarity in pgvector 27:55 Prompt engineering 33:15 Prompt best practices 38:37 Demo time! 41:32 Thanks for watching!