supabase
stopmoclay 제작
Data & Analytics요약
Connect to Supabase for database operations, vector search, and storage.
설명
이 스킬이 하는 일
Connects to a Supabase project to run SQL queries, perform CRUD operations on tables, and execute vector similarity search using pgvector. The service role key grants full database access; an anon key can be used for restricted access.
Handles raw SQL, CRUD, and vector similarity search through one CLI without needing separate database clients or a custom embedding pipeline.
사용 시점
- Query user records filtered by status or date range
- Insert rows collected from a form or API response
- Find semantically similar documents using pgvector embeddings
- Inspect table schemas before writing migration SQL
- Delete expired session rows matching a condition
예시 워크플로
User asks: Find the top 5 documents related to 'setting up authentication'
- 1
Calls vector-search on the documents table with the query string
- 2
Generates an embedding for the query using OpenAI text-embedding-ada-002
- 3
Passes the embedding to the match_documents RPC function in Supabase
- 4
Retrieves rows ranked by cosine similarity above the configured threshold
- 5
Returns the top 5 matching records with content and similarity scores
A ranked list of 5 document records with content fields and similarity scores
요구 사항
- SUPABASE_URL environment variable
- SUPABASE_SERVICE_KEY environment variable
- Supabase account and project
- OPENAI_API_KEY environment variable (required for vector search embeddings)
설치
clawhub install stopmoclay/supabaseCLI 명령을 실행하거나, 프롬프트를 Claude Code, Cursor, Codex 등 사용하는 코딩 에이전트에 붙여넣으세요.