Supabase

Supabase MCP Server for Cloudflare Workers

Available Tools

26 tools available in the Supabase MCP server. Each tool can be called by AI assistants to perform specific actions.

supabase_empty_bucket

Remove all objects from a storage bucket.

Args:

bucketId: The bucket ID/name

Returns: Confirmation of operation.

{
  "type": "object",
  "required": [
    "bucketId"
  ],
  "properties": {
    "bucketId": {
      "type": "string",
      "description": "Bucket ID"
    }
  }
}

supabase_list_users

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.

{
  "type": "object",
  "properties": {
    "limit": {
      "type": "integer",
      "default": 20,
      "maximum": 100,
      "minimum": 1,
      "description": "Number of users to return"
    },
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    },
    "offset": {
      "type": "integer",
      "minimum": 0,
      "description": "Users to skip"
    }
  }
}

supabase_get_user

Get a single auth user by ID (requires service role key).

Args:

userId: The user's UUID

Returns: The user record with all metadata.

{
  "type": "object",
  "required": [
    "userId"
  ],
  "properties": {
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    },
    "userId": {
      "type": "string",
      "description": "User UUID"
    }
  }
}

supabase_create_user

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.

{
  "type": "object",
  "properties": {
    "email": {
      "type": "string",
      "description": "Email address"
    },
    "phone": {
      "type": "string",
      "description": "Phone number"
    },
    "password": {
      "type": "string",
      "description": "Password (min 6 chars)"
    },
    "appMetadata": {
      "type": "object",
      "description": "App metadata"
    },
    "emailConfirm": {
      "type": "boolean",
      "default": false,
      "description": "Auto-confirm email"
    },
    "phoneConfirm": {
      "type": "boolean",
      "default": false,
      "description": "Auto-confirm phone"
    },
    "userMetadata": {
      "type": "object",
      "description": "User metadata"
    }
  }
}

supabase_update_user

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.

{
  "type": "object",
  "required": [
    "userId"
  ],
  "properties": {
    "email": {
      "type": "string"
    },
    "phone": {
      "type": "string"
    },
    "userId": {
      "type": "string",
      "description": "User UUID"
    },
    "password": {
      "type": "string"
    },
    "appMetadata": {
      "type": "object"
    },
    "banDuration": {
      "type": "string",
      "description": "Ban duration (e.g., \"24h"
    },
    "emailConfirm": {
      "type": "boolean"
    },
    "phoneConfirm": {
      "type": "boolean"
    },
    "userMetadata": {
      "type": "object"
    }
  }
}

supabase_delete_user

Delete an auth user (requires service role key).

Args:

userId: The user's UUID

Returns: Confirmation of deletion.

{
  "type": "object",
  "required": [
    "userId"
  ],
  "properties": {
    "userId": {
      "type": "string",
      "description": "User UUID"
    }
  }
}

supabase_select

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.

{
  "type": "object",
  "required": [
    "table"
  ],
  "properties": {
    "limit": {
      "type": "integer",
      "maximum": 1000,
      "minimum": 1,
      "description": "Max rows to return"
    },
    "order": {
      "type": "string",
      "description": "Order by clause"
    },
    "table": {
      "type": "string",
      "description": "Table name to query"
    },
    "filter": {
      "type": "string",
      "description": "PostgREST filter string"
    },
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string",
      "default": "json",
      "description": "Response format"
    },
    "offset": {
      "type": "integer",
      "minimum": 0,
      "description": "Rows to skip"
    },
    "select": {
      "type": "string",
      "default": "*",
      "description": "Columns to select"
    }
  }
}

supabase_insert

Insert data into a Supabase table.

Args:

table: The table name
data: Object or array of objects to insert

Returns: The inserted row(s).

{
  "type": "object",
  "required": [
    "table",
    "data"
  ],
  "properties": {
    "data": {
      "type": "string",
      "description": "Data to insert"
    },
    "table": {
      "type": "string",
      "description": "Table name"
    },
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    }
  }
}

supabase_update

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

{
  "type": "object",
  "required": [
    "table",
    "data",
    "filter"
  ],
  "properties": {
    "data": {
      "type": "object",
      "description": "Fields to update"
    },
    "table": {
      "type": "string",
      "description": "Table name"
    },
    "filter": {
      "type": "string",
      "description": "PostgREST filter string"
    },
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    }
  }
}

supabase_delete

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

{
  "type": "object",
  "required": [
    "table",
    "filter"
  ],
  "properties": {
    "table": {
      "type": "string",
      "description": "Table name"
    },
    "filter": {
      "type": "string",
      "description": "PostgREST filter string"
    },
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    }
  }
}

supabase_upsert

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

{
  "type": "object",
  "required": [
    "table",
    "data"
  ],
  "properties": {
    "data": {
      "type": "string",
      "description": "Data to upsert"
    },
    "table": {
      "type": "string",
      "description": "Table name"
    },
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    },
    "onConflict": {
      "type": "string",
      "description": "Conflict column(s)"
    }
  }
}

supabase_rpc

Call a Postgres function (RPC) in Supabase.

Args:

functionName: Name of the function to call
params: Object with function parameters

Returns: The function result.

{
  "type": "object",
  "required": [
    "functionName"
  ],
  "properties": {
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    },
    "params": {
      "type": "object",
      "description": "Function parameters"
    },
    "functionName": {
      "type": "string",
      "description": "Function name"
    }
  }
}

supabase_invoke_function

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.

{
  "type": "object",
  "required": [
    "functionName"
  ],
  "properties": {
    "body": {
      "description": "Request body"
    },
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    },
    "method": {
      "enum": [
        "GET",
        "POST",
        "PUT",
        "PATCH",
        "DELETE"
      ],
      "type": "string",
      "default": "POST",
      "description": "HTTP method"
    },
    "headers": {
      "type": "object",
      "description": "Additional headers"
    },
    "functionName": {
      "type": "string",
      "description": "Function name"
    }
  }
}

supabase_list_buckets

List all storage buckets.

Returns: Array of bucket objects with their configuration.

{
  "type": "object",
  "properties": {
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    }
  }
}

supabase_get_bucket

Get details of a specific storage bucket.

Args:

bucketId: The bucket ID/name

Returns: Bucket configuration details.

{
  "type": "object",
  "required": [
    "bucketId"
  ],
  "properties": {
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    },
    "bucketId": {
      "type": "string",
      "description": "Bucket ID/name"
    }
  }
}

supabase_create_bucket

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.

{
  "type": "object",
  "required": [
    "id"
  ],
  "properties": {
    "id": {
      "type": "string",
      "description": "Unique bucket ID"
    },
    "public": {
      "type": "boolean",
      "default": false,
      "description": "Publicly accessible"
    },
    "fileSizeLimit": {
      "type": "integer",
      "description": "Max file size in bytes"
    },
    "allowedMimeTypes": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "Allowed MIME types"
    }
  }
}

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

{
  "type": "object",
  "required": [
    "bucketId"
  ],
  "properties": {
    "public": {
      "type": "boolean",
      "description": "Publicly accessible"
    },
    "bucketId": {
      "type": "string",
      "description": "Bucket ID"
    },
    "fileSizeLimit": {
      "type": "integer",
      "description": "Max file size"
    },
    "allowedMimeTypes": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "Allowed MIME types"
    }
  }
}

supabase_delete_bucket

Delete a storage bucket (must be empty).

Args:

bucketId: The bucket ID/name

Returns: Confirmation of deletion.

{
  "type": "object",
  "required": [
    "bucketId"
  ],
  "properties": {
    "bucketId": {
      "type": "string",
      "description": "Bucket ID"
    }
  }
}

supabase_list_objects

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.

{
  "type": "object",
  "required": [
    "bucket"
  ],
  "properties": {
    "path": {
      "type": "string",
      "default": "",
      "description": "Folder path"
    },
    "limit": {
      "type": "integer",
      "maximum": 1000,
      "minimum": 1,
      "description": "Max objects"
    },
    "bucket": {
      "type": "string",
      "description": "Bucket ID"
    },
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    },
    "offset": {
      "type": "integer",
      "minimum": 0,
      "description": "Objects to skip"
    },
    "search": {
      "type": "string",
      "description": "Search string"
    }
  }
}

supabase_upload_object

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.

{
  "type": "object",
  "required": [
    "bucket",
    "path",
    "content"
  ],
  "properties": {
    "path": {
      "type": "string",
      "description": "File path"
    },
    "bucket": {
      "type": "string",
      "description": "Bucket ID"
    },
    "upsert": {
      "type": "boolean",
      "default": false,
      "description": "Overwrite if exists"
    },
    "content": {
      "type": "string",
      "description": "Base64 encoded content"
    },
    "contentType": {
      "type": "string",
      "default": "application/octet-stream",
      "description": "MIME type"
    }
  }
}

supabase_move_object

Move an object within storage.

Args:

bucket: The bucket ID/name
fromPath: Current file path
toPath: New file path

Returns: Confirmation of move.

{
  "type": "object",
  "required": [
    "bucket",
    "fromPath",
    "toPath"
  ],
  "properties": {
    "bucket": {
      "type": "string",
      "description": "Bucket ID"
    },
    "toPath": {
      "type": "string",
      "description": "New path"
    },
    "fromPath": {
      "type": "string",
      "description": "Current path"
    }
  }
}

supabase_copy_object

Copy an object within storage.

Args:

bucket: The bucket ID/name
fromPath: Source file path
toPath: Destination file path

Returns: The new file path.

{
  "type": "object",
  "required": [
    "bucket",
    "fromPath",
    "toPath"
  ],
  "properties": {
    "bucket": {
      "type": "string",
      "description": "Bucket ID"
    },
    "toPath": {
      "type": "string",
      "description": "Destination path"
    },
    "fromPath": {
      "type": "string",
      "description": "Source path"
    }
  }
}

supabase_delete_objects

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.

{
  "type": "object",
  "required": [
    "bucket",
    "paths"
  ],
  "properties": {
    "paths": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "File paths to delete"
    },
    "bucket": {
      "type": "string",
      "description": "Bucket ID"
    }
  }
}

supabase_create_signed_url

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.

{
  "type": "object",
  "required": [
    "bucket",
    "path",
    "expiresIn"
  ],
  "properties": {
    "path": {
      "type": "string",
      "description": "File path"
    },
    "bucket": {
      "type": "string",
      "description": "Bucket ID"
    },
    "expiresIn": {
      "type": "integer",
      "minimum": 1,
      "description": "Expiration in seconds"
    }
  }
}

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

{
  "type": "object",
  "required": [
    "bucket",
    "path"
  ],
  "properties": {
    "path": {
      "type": "string",
      "description": "File path"
    },
    "bucket": {
      "type": "string",
      "description": "Bucket ID"
    }
  }
}

supabase_get_public_url

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.

{
  "type": "object",
  "required": [
    "bucket",
    "path"
  ],
  "properties": {
    "path": {
      "type": "string",
      "description": "File path"
    },
    "bucket": {
      "type": "string",
      "description": "Bucket ID"
    }
  }
}