@e9n/pi-supabase

Supabase integration for pi — query tables, describe schemas, call RPC functions, and stream realtime change notifications.

Features

• supabase tool — query, describe, count, rpc, and status actions with filter support
• Realtime subscriptions — subscribe to table change events, forwarded as pi-channels notifications
• Dual key support — anon key or service role key, switchable per project
• Optional query audit log — persistent log via pi-kysely

Settings

Add to ~/.pi/agent/settings.json or .pi/settings.json:

{
  "pi-supabase": {
    "url": "https://xxx.supabase.co",
    "anonKey": "eyJ...",
    "serviceRoleKey": "eyJ...",
    "useServiceRole": false,
    "useKysely": false,
    "notifications": {
      "enabled": false,
      "route": "ops",
      "tables": ["users", "orders"]
    },
    "rpc": {
      "allowList": ["get_dashboard_stats"]
    }
  }
}

| Setting | Type | Default | Description | |---------|------|---------|-------------| | url | string | — | Supabase project URL (required) | | anonKey | string | — | Supabase anon/public key | | serviceRoleKey | string | — | Service role key for elevated access | | useServiceRole | boolean | false | Use service role key instead of anon key | | useKysely | boolean | false | Log queries via pi-kysely | | notifications.enabled | boolean | false | Enable realtime table change notifications | | notifications.route | string | "ops" | pi-channels route for notifications | | notifications.tables | string[] | [] | Tables to subscribe to | | rpc.allowList | string[] | [] | Allowed RPC function names (empty = all blocked) |

Tool: supabase

| Action | Description | |--------|-------------| | query | Select rows with filters, ordering, and pagination | | describe | Show column names and types for a table | | tables | List all tables in the public schema | | count | Count rows matching optional filters | | rpc | Call a Postgres function (must be on allow-list) | | status | Show connection status and current config |

Filter operators: eq, neq, gt, gte, lt, lte, like, ilike, is, in

Install

pi install npm:@e9n/pi-supabase

License

MIT