supabase
bởi stopmoclay
Data & AnalyticsTóm tắt
Connect to Supabase for database operations, vector search, and storage.
Mô tả
Kỹ năng này làm gì
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.
Khi nào nên dùng
- 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
Quy trình ví dụ
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
Yêu cầu
- SUPABASE_URL environment variable
- SUPABASE_SERVICE_KEY environment variable
- Supabase account and project
- OPENAI_API_KEY environment variable (required for vector search embeddings)
Cài đặt
clawhub install stopmoclay/supabaseChạy lệnh CLI, hoặc dán prompt vào Claude Code, Cursor, Codex hay coding agent bạn đang dùng.