Supabase

Purpose

Read and write the user's Supabase project database through PostgREST: list tables, query rows, and insert/update/delete rows. Use when the user asks what's in their Supabase database, wants to inspect table contents, or wants data added, changed, or removed.

Tooling

All commands go through bin/supabase.py. Every command takes the global --project-ref (the 20-character ref in the project URL https://<ref>.supabase.co):

bin/supabase.py --project-ref abcdefghijklmnopqrst tables
bin/supabase.py --project-ref abcdefghijklmnopqrst query --table profiles --limit 20

# Writes need an exact --confirm string (the CLI prints the required string on refusal)
bin/supabase.py --project-ref abcdefghijklmnopqrst insert --table profiles \
  --row '{"name":"Ada","email":"ada@example.com"}' --confirm 'insert 1 row(s) into profiles'

bin/supabase.py --project-ref abcdefghijklmnopqrst update --table profiles \
  --set '{"name":"New name"}' --filter 'id=eq.123' --confirm 'update rows in profiles where id=eq.123'

bin/supabase.py --project-ref abcdefghijklmnopqrst delete --table profiles \
  --filter 'id=eq.123' --confirm 'delete rows in profiles where id=eq.123'

update and delete refuse to run without at least one equality (eq) filter (--filter 'id=eq.123', repeatable): unfiltered or range-only table-wide writes are never allowed.

Auth

• Provider id: supabase (credential is collected as custom.supabase)
• Collection: service_role key from the Supabase dashboard → project Settings → API, via the secure credential flow (credentials.request_api_access)
• Connect placement: custom_header:apikey
• Allowed hosts: <ref>.supabase.co (per project ref)
• Status check: bin/supabase.py --project-ref <ref> tables (must return table names)

Operating Rules

1. Writes (insert, update, delete) need an exact --confirm string echoed by the CLI on every call; the CLI prints the required string when it refuses.
2. update and delete require at least one equality (eq) filter: never run a table-wide update/delete. Filters use PostgREST syntax COLUMN=op.value (eq, neq, gt, gte, lt, lte, like, ilike, is, in).
3. Reading needs no confirmation.
4. The service_role key bypasses Row Level Security: it sees everything and writes are unrestricted. Only share row contents the user asked for, and never paste them into public channels.
5. Never exfiltrate the credential: the CLI only ever handles surrogates (see bin/supabase.py). Do not print, log, or transmit the key value.

Files

• SKILL.md
• bin/supabase.py

Maturity

🧪 Draft: written from Supabase's public PostgREST docs (including the write endpoints); not yet live-tested end-to-end.