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/supabaseВыполните команду CLI или вставьте промпт в Claude Code, Cursor, Codex — любой кодинг-агент, которым пользуетесь.