Saltar al contenido
TakoAPI
Volver a skills

supabase

por stopmoclay

Data & Analytics
—Aún sin valoraciones
Tu valoración

Resumen

Connect to Supabase for database operations, vector search, and storage.

Descripción

Qué hace esta skill

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.

Cuándo usarla

  • 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

Flujo de trabajo de ejemplo

ENTRADA

User asks: Find the top 5 documents related to 'setting up authentication'

AGENTE
  1. 1

    Calls vector-search on the documents table with the query string

  2. 2

    Generates an embedding for the query using OpenAI text-embedding-ada-002

  3. 3

    Passes the embedding to the match_documents RPC function in Supabase

  4. 4

    Retrieves rows ranked by cosine similarity above the configured threshold

  5. 5

    Returns the top 5 matching records with content and similarity scores

SALIDA

A ranked list of 5 document records with content fields and similarity scores

Requisitos

  • SUPABASE_URL environment variable
  • SUPABASE_SERVICE_KEY environment variable
  • Supabase account and project
  • OPENAI_API_KEY environment variable (required for vector search embeddings)

Instalación

clawhub install stopmoclay/supabase

Ejecuta el comando de la CLI o pega el prompt en Claude Code, Cursor, Codex o el agente de programación que uses.

Enlaces