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-supabase-docs

pgvector extension:https://github.com/pgvector/pgvector

Generate embeddings implementation:https://github.com/supabase/supabase/blob/54d39d4958575e5b58aa1d5d2a02db863ab4673c/apps/docs/scripts/generate-embeddings.ts

Clippy edge function implementation:https://github.com/supabase/supabase/blob/54d39d4958575e5b58aa1d5d2a02db863ab4673c/supabase/functions/clippy-search/index.ts

Clippy frontend implementation:https://github.com/supabase/supabase/blob/54d39d4958575e5b58aa1d5d2a02db863ab4673c/packages/ui/src/components/Command/AiCommand.tsx

Prompt engineering:https://prmpts.ai/blog/what-is-prompt-engineering

00:00 Why?01:40 Let’s get started03:15 Custom knowledge base04:49 Context injection06:13 Pre-process MDX files13:40 Embeddings15:40 Storing in Postgres + pgvector22:21 API endpoint (edge function)23:44 Calculating similarity in pgvector27:55 Prompt engineering33:15 Prompt best practices38:37 Demo time!41:32 Thanks for watching!

The post ClippyGPT – How I Built Supabase’s OpenAI Doc Search (Embeddings) appeared first on AIPressRoom.