Supabase

Remove all objects from a storage bucket. Args: - bucketId: The bucket ID/name Returns: Confirmation of operation.

List auth users from Supabase (requires service role key). Args: - limit: Number of users to return (default: 20) - offset: Number of users to skip Returns: Paginated list of users with their metadata.

Get a single auth user by ID (requires service role key). Args: - userId: The user's UUID Returns: The user record with all metadata.

Create a new auth user (requires service role key). Args: - email: User's email address - password: User's password (optional for passwordless) - phone: User's phone number - emailConfirm: Auto-confirm email (default: false) - phoneConfirm: Auto-confirm phone (default: false) - userMetadata: Custom user metadata - appMetadata: App-specific metadata Returns: The created user record.

Update an existing auth user (requires service role key). Args: - userId: The user's UUID - email: New email address - password: New password - phone: New phone number - emailConfirm: Confirm email - phoneConfirm: Confirm phone - userMetadata: Updated user metadata - appMetadata: Updated app metadata - banDuration: Ban duration (e.g., "24h", "7d", "none" to unban) Returns: The updated user record.

Delete an auth user (requires service role key). Args: - userId: The user's UUID Returns: Confirmation of deletion.

Select data from a Supabase table using PostgREST. Args: - table: The table name to query - select: Columns to select (e.g., "id,name,email" or "*") - filter: PostgREST filter string (e.g., "id=eq.1,status=eq.active") - order: Order by clause (e.g., "created_at.desc") - limit: Maximum number of rows to return - offset: Number of rows to skip Filter operators: - eq: Equal (e.g., "status=eq.active") - neq: Not equal - gt, gte, lt, lte: Greater/less than - like, ilike: Pattern matching (e.g., "name=like.*john*") - in: In list (e.g., "id=in.(1,2,3)") - is: Is null/not null (e.g., "deleted_at=is.null") Returns: Array of matching rows with optional count.

Insert data into a Supabase table. Args: - table: The table name - data: Object or array of objects to insert Returns: The inserted row(s).

Update data in a Supabase table. Args: - table: The table name - data: Object with fields to update - filter: PostgREST filter to identify rows (e.g., "id=eq.1") Returns: The updated row(s).

Delete data from a Supabase table. Args: - table: The table name - filter: PostgREST filter to identify rows (e.g., "id=eq.1") Returns: The deleted row(s).

Upsert (insert or update) data in a Supabase table. Args: - table: The table name - data: Object or array of objects to upsert - onConflict: Column(s) to check for conflicts (e.g., "id" or "email,org_id") Returns: The upserted row(s).

Call a Postgres function (RPC) in Supabase. Args: - functionName: Name of the function to call - params: Object with function parameters Returns: The function result.

Invoke a Supabase Edge Function. Args: - functionName: Name of the edge function to invoke - body: Request body (will be JSON stringified) - method: HTTP method (default: POST) - headers: Additional headers to send Returns: The function response.

List all storage buckets. Returns: Array of bucket objects with their configuration.

Get details of a specific storage bucket. Args: - bucketId: The bucket ID/name Returns: Bucket configuration details.

Create a new storage bucket. Args: - id: Unique bucket ID/name - public: Whether the bucket is publicly accessible (default: false) - fileSizeLimit: Maximum file size in bytes - allowedMimeTypes: Array of allowed MIME types Returns: The created bucket.

Update a storage bucket's configuration. Args: - bucketId: The bucket ID/name - public: Whether the bucket is publicly accessible - fileSizeLimit: Maximum file size in bytes - allowedMimeTypes: Array of allowed MIME types Returns: The updated bucket.

Delete a storage bucket (must be empty). Args: - bucketId: The bucket ID/name Returns: Confirmation of deletion.

List objects in a storage bucket. Args: - bucket: The bucket ID/name - path: Folder path prefix (default: root) - limit: Maximum number of objects - offset: Objects to skip - search: Search string Returns: Array of storage objects.

Upload a file to storage (base64 encoded content). Args: - bucket: The bucket ID/name - path: File path within the bucket - content: Base64 encoded file content - contentType: MIME type of the file - upsert: Overwrite if exists (default: false) Returns: The upload path.

Move an object within storage. Args: - bucket: The bucket ID/name - fromPath: Current file path - toPath: New file path Returns: Confirmation of move.

Copy an object within storage. Args: - bucket: The bucket ID/name - fromPath: Source file path - toPath: Destination file path Returns: The new file path.

Delete one or more objects from storage. Args: - bucket: The bucket ID/name - paths: Array of file paths to delete Returns: List of deleted files.

Create a signed URL for temporary access to a private file. Args: - bucket: The bucket ID/name - path: File path - expiresIn: Expiration time in seconds (e.g., 3600 for 1 hour) Returns: The signed URL.

Create a signed URL for uploading a file. Args: - bucket: The bucket ID/name - path: File path where the file will be uploaded Returns: The signed upload URL and token.

Get the public URL for a file in a public bucket. Args: - bucket: The bucket ID/name (must be public) - path: File path Returns: The public URL.