Supabase

Learn how to use Supabase with Composio

Overview

Enum

SUPABASE

Description

Supabase is an open-source backend-as-a-service providing a Postgres database, authentication, storage, and real-time subscription APIs for building modern applications

Authentication Details

client_id
stringRequired
client_secret
stringRequired
oauth_redirect_uri
stringDefaults to https://backend.composio.dev/api/v1/auth-apps/add
scopes
stringDefaults to all
supabase_personal_token
stringRequired

Actions

Creates a 'publishable' or 'secret' api key for an existing supabase project, optionally with a description; 'secret' keys can have customized jwt templates.

Action Parameters

description
string
ref
stringRequired
type
stringRequired

Action Response

data
object
error
successful
boolean
Permanently deletes a specific api key (identified by `id`) from a supabase project (identified by `ref`), revoking its access.

Action Parameters

id
stringRequired
ref
stringRequired

Action Response

data
object
error
successful
boolean
Retrieves the detailed configuration for a specific third-party authentication (tpa) provider, identified by `tpa id`, within an existing supabase project specified by `ref`.

Action Parameters

ref
stringRequired
tpa_id
stringRequired

Action Response

data
object
error
successful
boolean
Lists all configured third-party authentication provider integrations for an existing supabase project (using its `ref`), suitable for read-only auditing or verifying current authentication settings.

Action Parameters

ref
stringRequired

Action Response

data
array
error
successful
boolean
Removes a third-party authentication provider (e.g., google, github) from a supabase project's configuration; this immediately prevents users from logging in via that method.

Action Parameters

ref
stringRequired
tpa_id
stringRequired

Action Response

data
object
error
successful
boolean
Updates an existing supabase project api key's `description` and/or `secret jwt template` (which defines its `role`); does not regenerate the key string.

Action Parameters

description
string
id
stringRequired
ref
stringRequired

Action Response

data
object
error
successful
boolean
Activates a previously configured custom hostname for a supabase project, assuming dns settings are verified externally.

Action Parameters

ref
stringRequired

Action Response

data
object
error
successful
boolean
Activates a vanity subdomain for the specified supabase project, requiring subsequent dns configuration for the subdomain to become operational.

Action Parameters

ref
stringRequired
vanity_subdomain
stringRequired

Action Response

data
object
error
successful
boolean
Generates a supabase oauth 2.0 authorization url for user redirection, requiring a pre-registered `client id` and a `redirect uri` that matches one of its pre-registered uris.

Action Parameters

client_id
stringRequired
code_challenge
string
code_challenge_method
string
redirect_uri
stringRequired
response_mode
string
response_type
stringRequired
scope
string
state
string

Action Response

data
object
error
successful
boolean
Checks if a specific vanity subdomain is available for a supabase project; this action does not reserve or assign the subdomain.

Action Parameters

ref
stringRequired
vanity_subdomain
stringRequired

Action Response

data
object
error
successful
boolean
Enables database webhooks for the supabase project `ref`, triggering real-time notifications for insert, update, or delete events.

Action Parameters

ref
stringRequired

Action Response

data
object
error
successful
boolean
Fetches the current vanity subdomain configuration, including its status and custom domain name, for a supabase project identified by its reference id.

Action Parameters

ref
stringRequired

Action Response

data
object
error
successful
boolean
Retrieves a supabase project's custom hostname configuration, including its status, ssl certificate, and ownership verification, noting that availability may depend on the project's plan.

Action Parameters

ref
stringRequired

Action Response

data
object
error
successful
boolean
Retrieves the list of banned ipv4 addresses for a supabase project using its unique project reference string; this is a read-only operation.

Action Parameters

ref
stringRequired

Action Response

data
object
error
successful
boolean
Retrieves the current network restriction settings (e.g., ip whitelists) for a supabase project using its reference id; this is a read-only operation for auditing or verifying network security.

Action Parameters

ref
stringRequired

Action Response

data
object
error
successful
boolean
Retrieves the pgsodium configuration, including the root encryption key, for an existing supabase project identified by its `ref`.

Action Parameters

ref
stringRequired

Action Response

data
object
error
successful
boolean
Retrieves the ssl enforcement configuration for a specified supabase project, indicating if ssl connections are mandated for its database.

Action Parameters

ref
stringRequired

Action Response

data
object
error
successful
boolean
Irreversibly initiates the removal of a specified read replica from an existing supabase project, confirming only the start of the process, not its completion.

Action Parameters

database_identifier
stringRequired
ref
stringRequired

Action Response

data
object
error
successful
boolean
Removes specified ipv4 addresses from a supabase project's network ban list, granting immediate access; ips not currently banned are ignored.

Action Parameters

ipv4_addresses
arrayRequired
ref
stringRequired

Action Response

data
object
error
successful
boolean
Executes a given sql query against the project's database; use for advanced data operations or when standard api endpoints are insufficient, ensuring queries are valid postgresql and sanitized.

Action Parameters

query
stringRequired
ref
stringRequired

Action Response

data
object
error
successful
boolean
Provisions a read-only replica for a supabase project in a specified, supabase-supported aws region to enhance read performance and reduce latency.

Action Parameters

read_replica_region
stringRequired
ref
stringRequired

Action Response

data
object
error
successful
boolean
Updates and applies network access restrictions (ipv4/ipv6 cidr lists) for a supabase project, which may terminate existing connections not matching the new rules.

Action Parameters

dbAllowedCidrs
array
dbAllowedCidrsV6
array
ref
stringRequired

Action Response

data
object
error
successful
boolean
Initiates an asynchronous upgrade of a supabase project's postgresql database to a specified `target version` from a selected `release channel`, returning a `tracking id` to monitor status; the `target version` must be available in the chosen channel.

Action Parameters

ref
stringRequired
release_channel
stringRequired
target_version
stringRequired

Action Response

data
object
error
successful
boolean
Critically updates or initializes a supabase project's pgsodium root encryption key for security setup or key rotation, requiring secure backup of the new key to prevent irreversible data loss.

Action Parameters

ref
stringRequired
root_key
stringRequired

Action Response

data
object
error
successful
boolean
Creates a new saml 2.0 single sign-on (sso) provider for a supabase project, requiring either `metadata xml` or `metadata url` for saml idp configuration.

Action Parameters

attribute__mapping__keys
object
domains
array
metadata_url
string
metadata_xml
string
ref
stringRequired
type
stringRequired

Action Response

data
object
error
successful
boolean
Call this to add a new third-party authentication method (oidc or jwks) to a supabase project for integrating external identity providers (e.g., for sso); the api may also support `custom jwks` if sent directly.

Action Parameters

jwks_url
string
oidc_issuer_url
string
ref
stringRequired

Action Response

data
object
error
successful
boolean
Creates a new supabase organization, which serves as a top-level container for projects, billing, and team access.

Action Parameters

name
stringRequired

Action Response

data
object
error
successful
boolean
Creates a new, isolated database branch from an existing supabase project (identified by `ref`), useful for setting up separate environments like development or testing, which can optionally be linked to a git branch.

Action Parameters

branch_name
stringRequired
desired_instance_size
string
git_branch
string
persistent
boolean
postgres_engine
string
ref
stringRequired
region
string
release_channel
string

Action Response

data
object
error
successful
boolean
Creates a new serverless edge function for a supabase project (identified by `ref`), requiring valid javascript/typescript in `body` and a project-unique `slug 1` identifier.

Action Parameters

body
stringRequired
entrypoint_path
string
import_map
boolean
import_map_path
string
name
stringRequired
ref
stringRequired
slug
stringRequired
verify_jwt
boolean

Action Response

data
object
error
successful
boolean
Creates a new supabase project, requiring a unique name (no dots) within the organization; project creation is asynchronous.

Action Parameters

db_pass
stringRequired
desired_instance_size
string
kps_enabled
boolean
name
stringRequired
organization_id
stringRequired
plan
string
postgres_engine
string
region
stringRequired
release_channel
string
template_url
string

Action Response

data
object
error
successful
boolean
Re-verifies dns and ssl configurations for an existing custom hostname associated with a supabase project.

Action Parameters

ref
stringRequired

Action Response

data
object
error
successful
boolean
Permanently and irreversibly deletes a supabase project, identified by its unique `ref` id, resulting in complete data loss.

Action Parameters

ref
stringRequired

Action Response

data
object
error
successful
boolean
Permanently and irreversibly deletes a specific, non-default database branch by its `branch id`, without affecting other branches.

Action Parameters

branch_id
stringRequired

Action Response

data
object
error
successful
boolean
Permanently deletes a specific edge function (by `function slug`) from a supabase project (by `ref`); this action is irreversible and requires prior existence of both project and function.

Action Parameters

function_slug
stringRequired
ref
stringRequired

Action Response

data
object
error
successful
boolean
Deletes an active custom hostname configuration for the project identified by `ref`, reverting to the default supabase-provided hostname; this action immediately makes the project inaccessible via the custom domain and requires subsequent updates to client, oauth, and dns settings.

Action Parameters

ref
stringRequired

Action Response

data
object
error
successful
boolean
Permanently and irreversibly deletes an active vanity subdomain configuration for the specified supabase project, reverting it to its default supabase url.

Action Parameters

ref
stringRequired

Action Response

data
object
error
successful
boolean
Disables the preview branching feature for an existing supabase project, identified by its unique reference id (`ref`).

Action Parameters

ref
stringRequired

Action Response

data
object
error
successful
boolean
Temporarily disables a supabase project's read-only mode for 15 minutes to allow write operations (e.g., for maintenance or critical updates), after which it automatically reverts to read-only.

Action Parameters

ref
stringRequired

Action Response

data
object
error
successful
boolean
(beta) implements the oauth 2.0 token endpoint to exchange an authorization code or refresh token for access/refresh tokens, based on `grant type`.

Action Parameters

client_id
stringRequired
client_secret
stringRequired
code
string
code_verifier
string
grant_type
stringRequired
redirect_uri
string
refresh_token
string

Action Response

data
object
error
successful
boolean
Generates and retrieves typescript types from a supabase project's database; any schemas specified in `included schemas` must exist in the project.

Action Parameters

included_schemas
stringDefaults to public
ref
stringRequired

Action Response

data
object
error
successful
boolean
Retrieves a specific sql snippet by its unique identifier.

Action Parameters

id
stringRequired

Action Response

data
object
error
successful
boolean
Retrieves the configuration details for a specific single sign-on (sso) provider (e.g., saml, google, github, azure ad), identified by its uuid, within a supabase project.

Action Parameters

provider_id
stringRequired
ref
stringRequired

Action Response

data
object
error
successful
boolean
Fetches comprehensive details for a specific supabase organization using its unique slug.

Action Parameters

slug
stringRequired

Action Response

data
object
error
successful
boolean
Retrieves the project's complete read-only authentication configuration, detailing all settings (e.g., providers, mfa, email/sms, jwt, security policies) but excluding sensitive secrets.

Action Parameters

ref
stringRequired

Action Response

data
object
error
successful
boolean
Retrieves the postgrest configuration for a specific supabase project.

Action Parameters

ref
stringRequired

Action Response

data
object
error
successful
boolean
Retrieves the current read-only postgresql database configuration for a specified supabase project's `ref`, noting that some advanced or security-sensitive details might be omitted from the response.

Action Parameters

ref
stringRequired

Action Response

data
object
error
successful
boolean
Retrieves the current health status for a supabase project, for specified services or all services if the 'services' list is omitted.

Action Parameters

ref
stringRequired
services
arrayRequired
timeout_ms
integer

Action Response

data
array
error
successful
boolean
Retrieves the supavisor (connection pooler) configuration for a specified supabase project, identified by its reference id.

Action Parameters

ref
stringRequired

Action Response

data
array
error
successful
boolean
Retrieves the read-only configuration and status for a supabase database branch, typically for monitoring or verifying its settings.

Action Parameters

branch_id
stringRequired

Action Response

data
object
error
successful
boolean
Retrieves all api keys for an existing supabase project, specified by its unique reference id (`ref`); this is a read-only operation.

Action Parameters

ref
stringRequired

Action Response

data
array
error
successful
boolean
Retrieves the active pgbouncer configuration (postgresql connection pooler) for a supabase project, used for performance tuning, auditing, or getting the connection string.

Action Parameters

ref
stringRequired

Action Response

data
object
error
successful
boolean
Checks a supabase project's eligibility for an upgrade, verifying compatibility and identifying potential issues; this action does not perform the actual upgrade.

Action Parameters

ref
stringRequired

Action Response

data
object
error
successful
boolean
Retrieves the latest status of a supabase project's database upgrade for monitoring purposes; does not initiate or modify upgrades.

Action Parameters

ref
stringRequired

Action Response

data
object
error
successful
boolean
Lists all database backups for a supabase project, providing details on existing backups but not creating new ones or performing restores; availability may depend on plan and configuration.

Action Parameters

ref
stringRequired

Action Response

data
object
error
successful
boolean
Retrieves a list of all storage buckets for a supabase project, without returning bucket contents or access policies.

Action Parameters

ref
stringRequired

Action Response

data
array
error
successful
boolean
Lists all configured single sign-on (sso) providers for a supabase project, requiring the project reference id (`ref`) of an existing project.

Action Parameters

ref
stringRequired

Action Response

data
object
error
successful
boolean
Retrieves a list of sql snippets for the logged-in user, optionally filtered by a specific supabase project if `project ref` is provided.

Action Parameters

project_ref
string

Action Response

data
object
error
successful
boolean
Lists all database branches for a specified supabase project, used for isolated development and testing of schema changes; ensure the project reference id is valid.

Action Parameters

ref
stringRequired

Action Response

data
array
error
successful
boolean
Lists metadata for all edge functions in a supabase project (specified by 'ref'), excluding function code or logs; the project must exist.

Action Parameters

ref
stringRequired

Action Response

data
array
error
successful
boolean
Lists all organizations (id and name only) associated with the supabase account, excluding project details within these organizations.

Action Parameters

Action Response

data
array
error
successful
boolean
Retrieves a list of all supabase projects, including their id, name, region, and status, for the authenticated user.

Action Parameters

Action Response

data
array
error
successful
boolean
Retrieves all secrets for a supabase project using its reference id; secret values in the response may be masked.

Action Parameters

ref
stringRequired

Action Response

data
array
error
successful
boolean
Retrieves all members of a supabase organization, identified by its unique slug, including their user id, username, email, role, and mfa status.

Action Parameters

slug
stringRequired

Action Response

data
array
error
successful
boolean
Deletes a specific sso provider by its id (`provider id`) from a supabase project (`ref`), which disables it and returns its details; ensure this action will not inadvertently lock out users.

Action Parameters

provider_id
stringRequired
ref
stringRequired

Action Response

data
object
error
successful
boolean
Resets an existing supabase database branch, identified by `branch id`, to its initial clean state, irreversibly deleting all its current data and schema changes.

Action Parameters

branch_id
stringRequired

Action Response

data
object
error
successful
boolean
Restores a supabase project's database to a specific unix timestamp using point-in-time recovery (pitr), overwriting the current state; requires a paid plan with pitr and physical backups enabled.

Action Parameters

recovery_time_target_unix
integerRequired
ref
stringRequired

Action Response

data
object
error
successful
boolean
Retrieves detailed information, metadata, configuration, and status for a specific edge function using its project reference id and function slug.

Action Parameters

function_slug
stringRequired
ref
stringRequired

Action Response

data
object
error
successful
boolean
Retrieves the source code (body) for a specified serverless edge function using its project reference and function slug; this is a read-only operation that does not execute the function or return runtime logs.

Action Parameters

function_slug
stringRequired
ref
stringRequired

Action Response

data
object
error
successful
boolean
Retrieves the read-only mode status for a specified supabase project to check its operational state; this action does not change the read-only state.

Action Parameters

ref
stringRequired

Action Response

data
object
error
successful
boolean
Updates an existing sso provider's saml metadata, associated email domains, or attribute mappings for a supabase project, identified by `ref` and `provider id`.

Action Parameters

attribute__mapping__keys
object
domains
array
metadata_url
string
metadata_xml
string
provider_id
stringRequired
ref
stringRequired

Action Response

data
object
error
successful
boolean
Updates postgrest configuration settings (e.g., `max rows`, `db pool`, `db schema`, `db extra search path`) for a supabase project to fine-tune api performance, data exposure, and database resource usage.

Action Parameters

db_extra_search_path
string
db_pool
integer
db_schema
string
max_rows
integer
ref
stringRequired

Action Response

data
object
error
successful
boolean
Updates specified postgresql configuration parameters for an existing supabase project (`ref`) to optimize database performance; note that unspecified parameters remain unchanged, and caution is advised as incorrect settings can impact stability or require a restart.

Action Parameters

effective_cache_size
string
maintenance_work_mem
string
max_connections
integer
max_locks_per_transaction
integer
max_parallel_maintenance_workers
integer
max_parallel_workers
integer
max_parallel_workers_per_gather
integer
max_slot_wal_keep_size
string
max_standby_archive_delay
string
max_standby_streaming_delay
string
max_wal_size
string
max_worker_processes
integer
ref
stringRequired
session_replication_role
string
shared_buffers
string
statement_timeout
string
wal_keep_size
string
work_mem
string

Action Response

data
object
error
successful
boolean
Updates the supavisor (database pooler) configuration, such as `default pool size`, for an existing supabase project identified by `ref`; the `pool mode` parameter in the request is deprecated and ignored.

Action Parameters

default_pool_size
integer
pool_mode
string
ref
stringRequired

Action Response

data
object
error
successful
boolean
Updates an existing supabase edge function's properties (like name, slug, source code, jwt settings, import map) identified by project `ref` and `function slug`, supporting plain text code or eszip for the body.

Action Parameters

body
string
entrypoint_path
string
function_slug
stringRequired
import_map
boolean
import_map_path
string
name
string
ref
stringRequired
slug
string
verify_jwt
boolean

Action Response

data
object
error
successful
boolean
Updates the custom hostname for a supabase project, requiring subsequent dns changes to a user-controlled domain for ssl certificate issuance and domain ownership.

Action Parameters

custom_hostname
stringRequired
ref
stringRequired

Action Response

data
object
error
successful
boolean
Updates the configuration of a supabase database branch, allowing modification of its name, associated git branch, reset-on-push behavior, persistence, and status.

Action Parameters

branch_id
stringRequired
branch_name
string
git_branch
string
persistent
boolean
reset_on_push
boolean
status
string

Action Response

data
object
error
successful
boolean
Updates the ssl enforcement configuration (enable/disable) for a specified supabase project's database.

Action Parameters

ref
stringRequired
requestedConfig__database
boolean

Action Response

data
object
error
successful
boolean