跳到正文
TakoAPI
返回技能列表

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. 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

输出

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 或你在用的任意编程智能体里。

链接