本文へスキップ
TakoAPI
スキル一覧に戻る
—まだ評価がありません
あなたの評価

概要

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などお使いのコーディングエージェントにプロンプトを貼り付けてください。

リンク